Oracle Problem upgrading to NET10/EF10 with queries using contains.
Hi, after upgrading to the latest version simple queries with contains no longer work for me. I'm using an - Oracle 19c database patched to 19.26.0.0 and - EF 10.0.4 - Devart.Data.Oracle.EFCore 11.1.35.10 and 11.1.33.10 (both verified not working for
Intermittent error "Unknown prepared statement handler (14) given to mysql_stmt_precheck"
Product version: dotConnect for MySQL Professional 10.1.35 OS Version and Bitness: Windows 10, Windows Server 2012 R2 and Windows Server 2022. All x64. Project Type: Winforms app (.NET Framework 4.8) Please describe the issue: We are facing intermittent
Linq Connect Update Timeline
Is there a timeline for an update to LinqConnect 5.-0.151 to support the recent updates to visual studio? Thanks -Pete
Entity Developer and Composite Keys
Hello, Is there are way within Entity Developer, prior to code generation, to flag attributes, and remove the warnings e.g. Northwind db (image) so my generated code mappings won't have an issue. Thanks.
EF Core 10 for MySQL dotConnect exact support state
Hello, I'm trying to migrate to .NET10 and EF Core 10 an application. According to the website the connector supports both .NET 10 and EF Core 10. The current latest NuGet dependency also shows package requirements for EF Core 10 But running queries actually
Problem with Devart.Data.PostgreSql.EFCore 9.1.33.10
Hello, i just started to upgrade an application to net10 and i get following error: System.TypeLoadException: Method 'VisitRightJoin' in type 'System.Data.Common.CommandTrees.PgSqlExpressionCloner' from assembly 'Devart.Data.PostgreSql.Entity.EFCore,
EF Core 10 support (Oracle)
It's been some time since dotnet 10 release. When can we expect version of Devart.Data.Oracle.EFCore that supports EF Core 10 ?
Missing parentheses in a where clause with EF Core and IsNullOrWhiteSpace
Hi, With EF Core I have a parentheses issue with this kind of code : _context.MyModels.Where(m => string.IsNullOrWhiteSpace(m.Name) && m.Id > 1) When using IsNullOrWhiteSpace, the generated SQL does not encapsulate correctly with parentheses, which looks
Devart Oracle EF Core: NullReferenceException in paging pipeline for join with filtered subquery (EF Core 9.0.11)
## Environment - OS: Windows 10 x64 (10.0.26200) - .NET SDK: 9.0.310 - EF Core: 9.0.11 - Devart.Data.Oracle.EFCore: 11.0.0.9 - Provider: Devart dotConnect for Oracle ## Database Oracle database with existing tables: - Items (Id, OwnerId) - Itemsub (Id,
dotConnect for postgresql 8.0 not compatible with NetTopologySuite?
I used dotConnect version 7.17 with NetTopologySuite 1.14 + GeoAPI 1.7.4. I update dotConnect to version 8.0. Now I can't run my application: When I compile I have the warning warning MSB3277: détection de conflits non résolus entre différentes versions
EF Core 10 support (MySQL/MariaDB)
.NET 10 has been available for a long time now (currently 10.0.3), but there is still no Devart.Data.MySql.EFCore version available that supports .NET Core 10. The latest version only supports versions 8 and 9. When can we expect support for .NET 10?
License key in connection string
we have a purchased license of dotconnect for postgresql. today i installed the new version (9.0.0.0) and tried it with a .net framework 4.7.1 project. i tried the deployment and realized that i have to use the activation key in the licencse key field
DotConnect for SQLite TransactionScope
Hi, I am trying to use TransactionScope together with EFCore but I am getting this error: System.InvalidOperationException : Cannot enlist local transaction, because current global transaction already contains distributed transactions. Stack Trace: DbConnectionClosed.Open(DbConnectionBase
On Mac M3 moving from Devart.Data.MySql.EFCore 9.3.21.8 to 9.4.290.9 causes AccessViolationException
Hi, We try to move from EF Core 8 to 9 but looks like on Mac M3 it crashes instantly when we update the Devart.Data.MySql.EFCore package. It throws this : Fatal error. System.AccessViolationException: Attempted to read or write protected memory. This
dotConnect for Oracle - Devart.Data.Oracle.OracleException - ORA-00933: SQL command not properly ended
Devart.Data.Oracle.OracleException (0x80004005): ORA-00933: SQL command not properly ended was raised when I use MaxBatchSize. Versions: - Devart.Data.Oracle.EFCore :10.4.235.8 - Devart.Data.Oracle :10.4.235 - EntityFrameworkCore: 8.0.13 Ex: optionsBuilder.UseOracle(_oracleSessionManager.GetOrCreateOracleConnection(),
A collection of enum array values get translated as (NULL, NULL ...)
Hello, I have found another regression since .NET 9. I am unsure which version specifically caused it because I can't test due to the other problems I have logged in the past. In any case, this worked in .NET 8. We store our enums as a string in the database
Devart.Data.Oracle.EF6: Can it have .Net Framework support in Nuget?
Hello, I am currently updating our dotConnect for Oracle (DevArt.Data.Oracle) package to 10.3.10 in our .NET Framework 4.6.2 solution. I would also like to update Devart.Data.Oracle.EF6 to 10.3.10 but the dependencies in nuget requires .NET Standard 2.1:
Oracle connection error - Invalid Bytes count
I am getting error when connecting to oracle. I have tried with .NET 6 and .NET 8 string connectionString = "" + "Server=myserver;" + "Port=1521;" + "User Id=myuserid;" + "Password=mypassword;" + "Service Name=myserver;" + "Direct=True;" + "License Key=mykey";
Devart.Data.Oracle.EFCore in Azure Web Apps
I have an open ticket for this but wanted to see if anyone else has been able to get EFCore to work with Oracle, dotnet9 in an Azure Web App. Using the line works locally but not in Azue. builder.Services.AddDbContext<TestOracleDbContext>(options => options.UseOracle(vcisDbConnection));
dotConnect C# MySQL: Setting charset at global level?
I'm using the generated great TableAdapters in C#, where I had errors with my Hungarian strings (containing á, é letters) until I added any of these before opening the connection: this.Adapter.InsertCommand.Connection.Unicode = true; this.Adapter.InsertCommand.Connection.Charset
Unexpected SqlParameterExpression implementation when using Oracle spatial functions in EF Core 8
We are planning to upgrade EF Core 6 to EF Core 8 along with upgrade from .NET 6 to .NET 8. We frequently use Oracle spatial functions: "SDO_RELATE" and "SDO_WITHIN_DISTANCE", which unfortunately do not have built-in support in dotConnect for Oracle according
How to use dotConnect for Oracle Express Edition?
I am using dotConnect for Oracle Express edition, Can I reference to the library using NuGet or have to install manually?
Reset/Set Sequence in PostgresQL programmatically from c#
Is there a way to programmatically (c#) to update a sequence value in postgresql? I know from a sql perspective, you can do something like: SELECT setval('my_sequence', 10, TRUE); How do you do this with the devart.postgresql dotConnect for Postgres
.NET 9 - Devart.Data.Oracle.EfCore - NullReferenceException
Hi, On EFCore 9, with today driver v10.4.191.9, many operators are failing with this error : System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression.PushdownIntoSubqueryInternal(Boolean
dotConnect for MySQL parses sbyte incorrectly
Hello, I've recently bought dotConnect for MySQL and this is the first problem. All versions are current, .NET 8 with EF Core 9 and Devart's 9.4.191.9 My database has some columns that are tinyint in MySQL, which has the range -128...127. dotConnect's
invalid bytes count error - DotConnect for Oracle
Hi, we moved from Oracle 12c to 19c and upgraded Devart.Data.Oracle to 10.0.0.0 and to Devaty.Data.Oracle EntirtE6 and we getting that error invalid bytes count right at the start up, during getting user profiles from database. What can be a reason for
'relation "__EFMigrationsHistory" already exists' when running multiple migration sets
Hello, I am working on upgrading my company's application, based on dotConnect for PostgreSQL, from EF6 to EF Core. The application has multiple modules with migrations for module-specific entities and all migrations are applied to the same database.
Sqlite support to Microsoft Visual Studio Community 2022 (ARM 64-bit)
I'm using Microsoft Visual Studio Community 2022 om a macbook pro M4. Everything work just fine except dotConnect for SQlite. Using latest version 6.4.190 Getting error when try to open SQLiteConnection in debug mode. Application is running fine standalone.
.NET 9 - Devart.Data.Oracle.EfCore - Discriminator issue with include
Hello Devart, When using discriminators in EF Core and then including navigational properties which aren't available on all discriminated types, only on specific derived types: var result = await ctx.Vehicles .Include(_ => ((Car)_).PossibleEngineTypes)
.NET9 Ef Core 9.0.1+ Object reference not set to an instance of an object.
Hi, I'm getting Object reference not set to an instance of an object. from Microsoft.EntityFrameworkCore.Relational at pretty much each query. For example: await context.TV_USERS.AsNoTracking().Where(x => x.ID == Id).FirstOrDefaultAsync(ct); I'm using
DateTimeOffset.Date does not correctly truncate time in dotConnect for PostgreSQL
Hello, I am working on upgrading my company's application, based on dotConnect for PostgreSQL, from EF6 to EF Core. We have been using multiple methods from the DbFunctions class, many of which were removed in EF Core. From my understanding, DateTimeOffset.Date
Why no feature to convert T-SQL to LINQ for .NET 9 Core?
I keep requesting and keep hoping my yearly subscription will get T-SQL to LINQ for .NET 9 core. But sadly every year passes an no feature added? Stored Procedures are a thing of the past and most development projects no longer use them. It's 2025, can't
Invalid SQL when ordering on a calculated boolean field: "ORA-00920: invalid relational operator"
We are experiencing malformed SQL when ordering on a calculated boolean field. This is an example of the invalid SQL: SELECT "c".ID, "c".NAME "Brand", (CASE WHEN ( SELECT COUNT(*) FROM MODELS "m0" WHERE "m0".CAR_ID = "c".ID) > 1 THEN 1 ELSE 0 END) "HasMoreThenOneModel",
Ora error when filtering/ordering on a calculated boolean field: "ORA-00933: SQL command not properly ended"/"ORA-00920: invalid relational operator"
We are experiencing malformed SQL when ordering/filtering on a calculated boolean field. This is an example of the invalid SQL SELECT "c".ID, "c".NAME "Brand", (CASE WHEN ( SELECT COUNT(*) FROM MODELS "m" WHERE "m".CAR_ID = "c".ID) > 1 THEN 1 ELSE 0 END)
.NET 9 - devart.Data.Oracle.EFCore method not found
Updating everything for .NET 9.0 and suddenly I get the following error: System.MissingMethodException: 'Method not found: 'Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlConstantExpression Microsoft.EntityFrameworkCore.Query.SqlExpressionFactory.Constant(System.Object,
Access denied for user 'x'@'ip' (using password: YES)
Hello, This is maybe a strange question, but I am evaluating the mysql connector and I started by trying to generate a model Entity Developer (with entity framework - database first approach). The problem is that I am not even able to connect to my server,
Universal Error in Mysql
hi all ! Im getting the following error and I dont know whats causing it. Exception thrown: 'System.NotSupportedException' in Devart.Data.dll UniDbType not supported by current data provider This is how I setup the connection public new Devart.Data.Universal.UniConnection
.Net 9 / EF Core 9 support
Hi, What is the roadmap / delay to support .Net 9 / EF Core 9 on the Devart.Data.MySql.EFCore library ? Regards.
Oracle AQ - Dequeue from a sharded queue causes invalid cast exception
Since i converted my Oracle queue into a sharded queue, the OracleQueue.Dequeue function always throws an invalid cast exception in Devart.Data.Oracle.dll. When i used a normal queue everything worked fine.
Oracle-19-24 issue in DirectMode
Hi, We have the same issue: https://support.devart.com/portal/en/community/topic/oracle-19-24-aso-directmode Is there any forecast for the release of the official version? Could you give us the access to the pre-release build? Regards
Next Page