Compiled query errors
Hello, After I 'v updated DB connector from version "10.1.134.7" to "10.1.151.7" , I started to get errors on compiled queries. I'm using EF7 on NET7. In the previous version, everything worked pretty well. Example of call: private static readonly Func<Model,
Handling of a bit array
Hello, recently we moved from 7.24.2066 to 8.1.151. Is there a difference now in handling a bit array? In the database there is a field of type "bit(7)". When filling a datatable (PgSqlDataAdapter.Fill), there is a different result in the corresponding
AccessViolationException in OCI mode, Devart 10, EF 6.4.4, Oracle 19
Hello Devart team. We are using Devart.Data.Oracle 10.0.0.0 for .NET Framework + EntityFramework 6.4.4. Our application is targeted to .NET Framework 4.8 and runs as 32 bit service process with "Local System" permissions. Devart.Data.Oracle runs in OCI
How can I query the WorkstationID value assigned in a connection string using T-SQL?
I am assigning the ApplicationName and WorkstaionID properties on a SqlConnectionStringBuilder. I can query the ApplicationName from sys.dm_exec_sessions. I would like be able to query the WorkstationID value using T-SQL, also. My goal is to be able to
Asp.net project Getting Devart error during build pipeline (Azure Devops) - License compilation file - Unable to resolve type 'Devart.Data.Oracle.OracleConnection,
Asp.net VB Project. It has Class library project & Asp.net website project in solution. Builds in dev machine. During Azure Devops build pipeline, getting below Unable to Resolve Type error during license file compilation. Please help on resolving this
Connecting Delphi client to .NET FireDAC alike server ?
I am aiming to replace Delphi FireDAC based server with .NET C# ASP.NET server which to keep providing the FireDAC requests to the Delphi clients. Is there such a thing ?
Visual Studio 2022 error not loading Devart.Data.PostgreSql.Vs.dll (dotConnect for PostgreSQL 8.1 Express)
Hi, I cannot find this topic in FAQ. So I posted here. It will always appear when I start Visual Studio even when with empty project. Please advice if this error can be ignored. Regards Samuel Toh
EF Core 7 MaxBatchSize and auto generated ID's
When using a MaxBatchSize I get an Exception when inserting a record, the ID is auto generated by the database: The property 'Planning.PLANNING_ID' has a temporary value while attempting to change the entity's state to 'Unchanged'. Either set a permanent
Event when a connection is taken or put back into the pool
Hi, Is there an event when a connection is made or reset in the pool ? Thank you
PostgreSql.EFCore: problem querying spatial data
Hello I migrated from .Net Framework to .NET Core 6.0 and have a problem querying spatial data. DbContext is extended with: optionsBuilder.UsePostgreSql(connectionString, options => { options.UseNetTopologySuite(); }); I use database first approach, the
How to Renew my dotconnect Oracle
How do I renew my licenses key of oracle dotconnect because I am facing the following error. Error : LicenseException: Feature is not supported. This error is thrown by Devart .NET Standard assemblies if license key validation fails. Possible reasons:
Missing Methods in Toolbox
Hello, I'm having an error when trying to access the ZohoConnection with the dotConnect, it hits me with a missing method error and im a little lost on where to go from there.
Lots of issues updating to version 6.1.134 of dotConnect SQLite Free in the Visual Studio 2022 community.
When upgrading to version 6.1.134 of dotConnect SQLite Free the Visual Studio 2022 community app stops working. Is it possible to roll back dotConnect version 6.0 for Microsoft Visual Studio 2022?
DotConnect for Oracle express edition version 9.14 cause serious memory leak!
I have this code to open Oracle connection: private OracleConnection _OpenDBConn() { bool successed = false; OracleConnection conn = new OracleConnection(ConnectString) { AutoCommit = false }; try { conn.Open(); successed = true; return conn; } finally
Integer[] value cannot be inserted into a PostgreSql database with LinqConnect
Hello, We have a column with datatype integer[] in one of our database tables. Using repository pattern, when we run this code: OurTableEntity entity = new OurTableEntity(); entity.OurColumn = "{-1,-1,-1,-1,-1}"; ourTableRepository.Add(entity); unitOfWork.Save();
ORA-01745: invalid host/bind variable name when parameters are reused in the linq query version 10.0.1.134.7 & EF7
Using 10.0.1.134.7 & EF7 When in .net the same variable is used more than once in a linq query, the bind variable in the query is rendered the second with 2 time ':' thus ::p__query_varname eg. excerpt: qry = qry.Where(z => z.DidoDocDosVersies.Where(y
dotConnect for Oracle and Entity Framework guide
Hello, I would like you to guide me about dotConnect for Oracle and Entity Framework configurations for the project I described with the following keywords. This help can be a sample project already exists, a post explaining the configuration, or a help
"CROSS APPLY" is not supported in Postgresql?
Hello If I use a LINQ query over 2 tables, I get an error 42601: syntax error at "APPLY" It seems that the SQL contains "CROSS APPLY" which is unknown in Postgresql. How can I avoid that ? Never had that problem with the previous versions (.NET Framework)
Save as different framework model?
As I requested a year ago, the reason I bought this was to migrate to EF from Telerik but my models are significant in size. I just need the basic relations in order for me to migrate since they list in the hundreds if not thousands in my models as the
Error "System.InvalidOperationException: Transaction already exists."
Hi, That error has already been mentioned here, but no solution. Wen can reproduce by doing this: //-------------------------------- try { //--step 1 try { Data1 dat1 = new() { field1 = 1, field2 = 2 }; ctx.Add(dat1); ctx.SaveChanges(); } catch(Exception
No DbUpdateConcurrencyException when OracleDbContextOptionsBuilder.MaxBatchSize > 1
Hi, we have an issue while enforcing optimistic concurrency in combination with an OracleDbContextOptionsBuilder.MaxBatchSize greater than 1 (eg. 50): there is no thrown DbUpdateConcurrencyException when there should be one. How to reproduce: Create an
Old DLL Reference (Devart.Data.PostgreSql)
Hello, in my Web Forms App I did upgrade to current Devart DLLs but there's somehow a hard reference to an older DLL and the only way I could solve it, was by using a DLL redirection - see below. Here's what I tried to solve it the right way: - I removed
Expecting Devart.Data.Oracle.OracleConnection but got Devart.Data.Oracle.Entity.av when using DbConnectionInterceptor
Version used: Used NuGet Package in .net 6 Project: Devart.Data.Oracle.EFCore 10.1.134.7 Problem: I need to Intercept the DbConnection to set some metadata but when using Microsoft.EntityFrameworkCore.Diagnostics.DbConnectionInterceptor instead of getting
Wrong number or types of arguments in call to 'SF_GET_CLIENTS_QUERY'
Hi Team, Facing this error, when we try to call a specific Oracle function, which has a input of type Table. there are no other mismatch on the number or type of arguments. Issue only when we use this particular parameter(atbl_client_nr). Below i have
Multiple Query
Hi I have a following problem: trying to utilize multiple query feature but getting error about incorrect sql syntax (ORA-00933). I want to pass few sql queries into one command, then execute reader, fetch data from first query, then call NextResult and
facing issue as Cannot describe stored procedure arguments
Hi Team, we are facing the same issue which is mentioned in below link, this is created around 2 years ago. Do not find any solution/fix provided. please help in understand the resiolution required. For reference we are adding the Procedure for reference.
Unable to create entity model
Hi, Using Visual Studio; When I try to add a new Devart Entity Model; I can create a model using the thick client app and open it in Visual Studio but the entities are not generated and I do not see Run Custom Tool.
Snapshot functionality or getting sqlite3* connection handle from SQLiteConnection
I need the snapshot functionality offered by SQLite as described here: https://www.sqlite.org/c3ref/snapshot_get.html but in context of a SQLiteConnection in turn used with Enity Framework 6. As far as I can see dotConnect for SQLite does not support
Installation Questions
I am installing dcoracle101pro.exe on a server that functions as a development environment as well as a production web server. When I attempted the installation it said that it was going to remove any old versions and I told it to go ahead and then another
Can a "dotConnect for Oracle" license be transfered from 1 developer to another developer
We're planning to buy a "dotConnect for Oracle" license type Team (up to 4 developers) for the company, and we analizyng the following scenario: If the 4 licenses are assigned to 4 different developers in the company, and at some point 1 of the developer
EF7: query (with JSON and CLOB) is much slower with directmode=true than without directmode
When querying an oracle view that has a CLOB which stores JSON using a connectstring with direct=true is much slower then without direct=true. <PackageReference Include="Devart.Data.Oracle.EFCore" Version="10.1.134.7" /> <PackageReference Include="Microsoft.EntityFrameworkCore"
Oracle RAC connectivity issue (regression)
Hi Devart Team, In early 2021 we updated our dorConnect for Oracle dependency to 9.14.1180 due to a client not being able to connect to their Oracle RAC database with our software. After the update all was good. Late last year we again updated our dotConnect
Could not load file or assembly 'Devart.Data.Oracle.Entity.EF5'
Hi, we moved from devart 8.4 to version 10.0 so current entity dll is devart.data.oracle.enity.EF6 but after running program on a new user environment we're getting below error although we never had or used such dll devart.data.oracle.enity.EF5 - no idea
Long response time for a query
Hi, Last year, I posted a question on the old forums and the answer was: you need to install the latest version... Which we did in September (version 9.16.1434). Now we're back in that period where our application is used a lot and we're still experiencing
Table Mapping Generator
Hi All, during the generation of the mapping for a Database in EF Core v 7, importing the tables in model we have an error because is inserted a wrong value into a table definition. The wrong value is: .UseTptMappingStrategy() another problem is that
ExecuteDeleteAsync Error
Hello, every time i try to use ExecuteDeleteAsync in EF7 , for example context.TABLE_NAME.Where(x => x.ID == id).ExecuteDeleteAsync(cancellationToken: cancellationToken) i get error like : System.InvalidCastException: Unable to cast object of type 'Microsoft.EntityFrameworkCore.Query.SqlExpressions.DeleteExpression'
Saving NULL geometries in Oracle DB with EF Core
We are migrating our solution from EF6 to EF Core and .NET Framework to .NET 6. When saving an entity using EF Core (using UseNetTopologySuite on the DbContext) where a column of type Geometry is NULL, it results in the following error: Microsoft.EntityFrameworkCore.DbUpdateException:
Oracle - Query Type class '____' cannot have primary key.
In the Oracle Entity Developer, I'm getting this error on some tables: Query Type class '____' cannot have primary key. The table does have a primary key in Oracle, but it is a varchar column. How can this table be used?
Unknown Database error when running initial migration
Connection string is: "Server=127.0.0.1;Database=MyDatabase;Uid=username;Pwd=secret;" Entity Framework Core 7 My SQL version 8.0.32 Initial migration is scaffolded using `add-migration`. However `update-database` fails with error: "Unknown Database MyDatabase"
Oracle trial license key
Hi, After having installed and used DevArt Oracle driver for EF I tried to renew my trial license key without success. I uninistalled software (clean program files and program data folders) and installed again using dcoracle.exe downloaded from your site.
Next Page