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
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
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 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. ...
Cannot Open Table ‘Case’ and ‘Order’ in SSMS with ODBC Driver for Salesforce
When working with SQL Server Management Studio (SSMS) and the Devart ODBC Driver for Salesforce, you may encounter difficulties accessing certain tables such as Case or Order. Important Note on SSMS Behavior Queries in SSMS are first processed by SQL ...
How to Install MySQL on Windows Using MySQL Installer
The article provides a comprehensive walkthrough outlining the aspects of how to install MySQL Server on Windows using MySQL Installer. Learn the subtleties of the MySQL installation process step-by-step to ensure you have MySQL Server together with ...