Stack Overflow
Stack Overflow

Questions tagged [devart]

Devart is a software development company specializing in native data access solutions, tools and database tools for the most popular databases, including MS SQL Server, MySQL, Oracle, PostgreSQL, InterBase, Firebird, and SQLite.

Devart is a software development company specializing in native data access solutions, tools and database tools for the most popular databases, including:

  • MS SQL Server
  • MySQL
  • Oracle
  • PostgreSQL
  • InterBase
  • Firebird
  • SQLite.

We try to provide high-end products to let you have the fastest data access and the broadest database support.

386 questions
0
votes
1 answer

why is devart DefaultValue attribute not working on version 9.7

We're using Devart dotConnect for oracle with Entitiy Framework. We've been using the solution described here to generate IDs with sequences and all worked well, untill we upgraded to devart 9.7 It looks as if the DefaultValue is being ignored. For…
user13565243
  • 1
  • 2
0
votes
1 answer

DevArt Oracle EF Core - Case insensitive string compare + NULLS

I can't seem to find any sensible/reliable way of performing case-insensitive string comparison when using DevArt EF Core with Oracle when NULLs are involved Assume there's a table with column "Name" which is a nullable string…
Ziloni
  • 101
  • 1
  • 6
0
votes
1 answer

ORA-64219: invalid LOB locator encountered

We migrated from oracle c12 to c19. And now we have simple test case that fails: //arrange string data = new string('x', 5000); var connection = tm.GetConnection(); var createTableCmd = connection.CreateCommand(false); createTableCmd.Text = "CREATE…
Stas BZ
  • 1,184
  • 1
  • 17
  • 36
0
votes
2 answers

Devart InsertAllOnSubmit doesn't update db generated fields

I'm using Devart's Linq to Oracle components. I've got a table with a field that's updated via a sequence in the database. This works fine when inserting one row: Dim db As New…
Joshua Frank
  • 13,120
  • 11
  • 46
  • 95
0
votes
2 answers

ORA-00923 dot net core devart provider FirstOrDefault() query error

I'm developing a .net core web API which use database oracle and data provider devart when I try to get some data on login operation I have a this problem {"ORA-00923: FROM keyword not found where expected"} my code drop catch on this line throw…
errorau
  • 2,121
  • 1
  • 14
  • 38
0
votes
1 answer

What is the difference between Initial Review and Regular Review in Review Assistant?

I'm using Review Assistant in Visual Studio 2017. When creating a review there are two options, Regular Review and Initial Review. I was wondering what the difference is between them? All I could find was Initial Review was to review the project…
CodeLearner
  • 389
  • 2
  • 6
  • 14
0
votes
0 answers

Why can't I connect to encrypted sqlite database file in C#

I encrypt my sqlite database file and set its password to 123 as follows. var conn = new SQLiteConnection("Data Source=Encrypted.db;Version=3;"); conn.Open(); conn.ChangePassword("123"); I don't get an error when I try to connect to the encrypted…
Quince
  • 144
  • 11
0
votes
1 answer

Scaffolding for .net core 3 and Devart.Data.Oracle.EFCore ends with error

I am trying to use .net-core 3 with Devart.Data.Oracle.EFCore by this article: https://www.devart.com/dotconnect/oracle/articles/efcore-database-first-net-core.html#nuget I created new project, installed packages as the article said but Scaffolding…
Petr Schmidke
  • 3
  • 1
0
votes
2 answers

Oracle Change Notification Registration is not cleaning on Oracle 18c

I am using devart dotConnect for Oracle with Oracle 12c database. My application has an OracleDependency object instanced to read notifications when I got a table changed. It is working fine for Oracle 12C. Recently, I have created a new instance…
Leonardo Willrich
  • 3
  • 2
0
votes
1 answer

Varray data type is not getting mapped with .net core entity using Devart oracle dot connect 9

I am trying to fetch data from a table(oracle db 12c) using Devart EFCore 9.8 and Oracle dot connect trial license in MSEFCore 2.2.4. But the VARRAY column is not getting mapped. It's throwing an exception - System.InvalidOperationException: The…
Ajijul
  • 1
  • 3
0
votes
1 answer

Entity Framework - Simple query takes 3 minutes to complete

I'm using Entity Framework 6 Code First with an Oracle database (using Devart DotConnect for Oracle) With a specific query with a SingleOrDefault, the query takes 1 second to complete : -- Executing at 08.10.2019 10:04:04 +02:00 -- Completed in 1211…
Gab
  • 1,861
  • 5
  • 26
  • 39
0
votes
1 answer

How to fix a pyodbc connection, make a query and read as pandas Dataframe

I'm trying to query via pd.read_sql(sql, db_connection_dw) The connection works properly and is the following: driver= '{Devart ODBC Driver for ASE}' server='---' db_environment='----' username='----' password='----' port='----' connectionString =…
jordi588
  • 37
  • 7
0
votes
2 answers

Keep alive oracle connection in c#

My oracle connection is getting closed before execution of procedure in c#. Oracle procedure takes more than a hour to execute completely. Please suggest how to keep same connection alive till my procedure return a value.
Abhijeet Kumar
  • 1
  • 1
0
votes
1 answer

Error dotConnect for Oracle to test a ASP.NET 2.2 app in Azure

I am trialing dotConnect for Oracle to test a ASP.NET 2.2 app in Azure, to see if the web technology and database providers would work for us on a new project. However, I recive: [Error] Feature is not supported. This error is thrown by Devart .NET…
ArielGomeX
  • 46
  • 2
0
votes
0 answers

Devart Oracle stored procedure performance issue

There is a performance problem about executing stored procedures in Oracle. Procedure's name is : myutil_api.move Plsql executes this procedure in 0.2 sec. Web App executes this procedure in 30 secs. Same users, same procedures but there is huge…
Mennan
  • 4,451
  • 13
  • 54
  • 86
1 2 3
…
25 26