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.
MySQL Router SSL Handshake error dotconnect mysql
I am trying upgrade my development machine and need to reinstall dot connect on the new machine, however, I cannot get dotconnect to work with mysql router - even though it's setup the exact same on the current development environment. I always receive
dotconnect for Quickbooks
I have doconnect for SQL Server. Can the dotconnect for Quickbooks co-exist? I got an error when I tried to install the Trial version.
Is there a way to remove decryption out of sqlite db
Hi, I use dotconnect universal with sqlite and the Encryption of SQLiteCrypt: UniConnection conn = new UniConnection("Provider=SQLite; Data Source=database.db; Encryption=SQLiteCrypt; SQLiteCrypt License Key=00000-000-0000000-00000; FailIfMissing = false;
Synchronize two sqlite databases .NET Core
Im not able to use dbConnect to synchronize two sqlite databases in .NET Core
MySQL: Determine AutoIncrement column by using GetSchema
Hi, I'd like to determine the existence of an auto-increment column in a table by using GetSchema. Could you please provide a small sample as I couldn't find any description of the various column attributes? Thanks in advance.
LinqConnect Migration Wizard in Visual Studio 2022 Community
We bought a copy of LinqConnect in 2020, but it didn't work for us as there were a bunch of things that worked in LinqToSQL and failed in LinqConnect. I was hoping after a few years we might have more luck with the latest version as we still want to migrate
Syncing an Oracle 11g with Partitioning
Hello, i'm trying to sync an Oracle 11g with Partitioning. The Provisioning works for a while (a few minutes) then throws an Exception: Devart.Data.Oracle.OracleException (0x80004005): ORA-00604: error occurred at recursive SQL level 1 ORA-01013: user
TUniMetadata and database structure.
Hi! Now I can get tables, columns, columns types and indexes. tables procedure var FUniMetaData: TUniMetaData; begin FUniMetaData := TUniMetaData.Create(nil); try FUniMetaData.Connection := FConnection; FUniMetaData.MetaDataKind := 'Tables'; FUniMetaData.Open;
Oracle Database Sync Is Very Slow Then Throw An Exception
Hallo, i'm using dotConnect for Oracle and dotConnect for SQLite to sync an huge Oracle database with an SQLite database using a windows service. By starting the windows service started the sync process. The Oracle 19c server and the windows service are
Problems with mapping types to ATTACHed SQLite databases (latest Devart.Data.SQLite.EFCore 6.0 on NET 7.0)
Hello. I've created a simple project (latest Devart.Data.SQLite.EFCore 6.0 on NET 7.0) with 3-level entities: public class UserRole { public Int64 Id { get; set; } public String Name { get; set; } public virtual IList<User> Users { get; set; } } public
Built-in Oracle spatial functions for EF Core
We are migrating our solution from EF6 to EF Core and .NET Framework to .NET 6. Previously in LINQ queries we frequently used spatial functions which were nicely translated to SQL, such as Devart.Data.Oracle.Entity.OracleSpatialFunctions.SdoRelate(geometry1,
User defined functions in Entity Framework Core 7.0
Hello. I'm porting my code from "classic" Entity Framework 6.4 to Entity Framework Core 7.0. What is replacement for the following code (User defined functions setup)? Most classes doesn't exist in both Devart.Data.SQLite and Microsoft.EntityFrameworkCore
.Net 7 support
Do dotConnect for Oracle support .Net 7? If not when will you will support it? Thanks.
Devart.Data.MySql & .NET 7 support
Hello, .NET 7 is out and we would like to upgrade our projects. Unfortunately the Devart.Data.MySql.EFCore package seems to not be compatible with it. Do you plan to have a compatible version any time soon ? Regards
Deployment issue, System.TypeLoadException
We recently updated our web application from dotConnect for MySQL 8.17 to 9.0.0 (with EF5). Everything works fine on dev machines but not when deployed to the web server (Windows Server 2012): System.Data.EntityCommandCompilationException: An error occurred
Is it possible to convert back from EDML to EDMX?
Is it possible to convert back from EDML to EDMX? If so, what are the steps? I'm in a situation where I have to change one of our applications back to just using ODP .NET Data Provider and Entity Framework 6 default in Visual Studio.
Weird Issue, happening once in a while...
hello, once a month or so, one user (out of 100) faces issues to login into one schema (out of 50 in the average) of one database (out of 100). Happens suddenly without any change to this user, schema or database. This 'lock' disappears after a few hours,
executeScalar() isn't recognized using sqliteCommand
I'm trying the dotconnect for sqlite trial. I've defined a sqliteCommand &I'm trying sqliteCommand.executeSalar() but executeSalar() isn't coming up when I type .e after the command instance.
Devart dotConnect for Oracle professional version
Hi, we're using version 8.4.437 for our oracle 12 connections and it worked well. Recently we tested on oracle 19c and we're getting this error: ORA-64219 invalid LOB locator encounter Could be of version of dotConnect? thanks
Using the Devart.Data.PostgreSql.dll assembly in a PowerShell 7 script?
I am trying to use a licensed Devart.Data.PostgreSql.dll in a PowerShell 7 script (there is no exe or dll file involved) It works with Windows PowerShell 5.1 without having to provide any addition license information but I cannot use the .NET Standard
Oracle error OCI-21500 and hard crash
I'm raising this again here in the new forum as we are still receiving this error after upgrading to the latest oracle 19.16 client. have an application using the latest version of dotconnect which is crashing randomly and being terminated by the .net
Devart Postres pgDataReader/PgDataAdapter Decimal value with Precision
Could someone please help me with the following question...
I migrated the Assembly Devart version to Postgres Express to version 8.0.0.0... after the changes the decimal value that is brought from the PgSqlDataAdapter is coming numerically with precision
Change sqlite version
How to update sqlite version? For now sqlite 3.40 is newest but it's 3.36 in devart 6.0.x package.
Using ILIKE
Hi there, How can I use "ILIKE" in a LINQ query in DotnetConnect for Postgres? If I try to use Devart.Data.PostgreSQL.Entity.PgSqlFunction.ILIKE, it throws an error "Method 'Boolean ILike(System.String, System.String)' is not supported for execution
Popular Articles
How to Download and Install a Previous Version of the Product
If you need to download and install an earlier version of a product, other than the latest release available on the website, follow these steps: Uninstall the Newer Version: To install a previous version available under your license, you must first ...
How to Connect to MySQL Server
In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server. You can connect to MySQL Server using MySQL Client, dbForge Studio for MySQL, and MySQL Workbench. In this article, we ...
How to Activate a Trial Version in dbForge Products
Starting from release 2025.1, the method of using the trial version and Express Edition has been updated for all paid dbForge products. To help you get started smoothly, please follow the step-by-step instructions below. As of version 2025.1, ...
"Cannot obtain Oracle Client information from registry" Error
The error message "Cannot obtain Oracle Client information from registry" when working with Oracle typically indicates that either the Oracle Client is not installed on your system, or there is a mismatch in the bitness between your application and ...
How to Automatically Create a Dump File on Crash for Studios, Standalone Tools, and MiniTools
If a crash occurs, you can configure the system to automatically create a dump file for debugging purposes. Follow the steps below to create the required registry keys for different products, such as dbForge Studio, Standalone Tools, and MiniTools. ...