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
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,
Updated to Entity Developer 7, Code generation default value not working for String
Hi, We updated our version of Entity Developer from 5.8 to 7.0 and the code generation default value for String properties stopped working. It still works for ints. We are using EF6 Models with Sql Server, code first. Generates: However Generates: I tried
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
Entity Framework Core 7 (EF7) / .NET 7.0 support
Hello, are there any estimates when Entity Developer will start supporting Entity Framework Core 7 (EF7) and .NET 7.0? Thank you
Relation Many-To-Many from Diagram Devart version 7
Hi all, I am working with the latest version of devart 7, with .net core 6 MVC, Visual Studio 2022 and with Sql server 2019. I need to relate two Many-to-Many tables and in the middle table I need to add more fields besides the two Ids of the related
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.
Help adding QuickBook invoice using DotConnect
I receive the following error: System.NullReferenceException HResult=0x80004003 Message=Object reference not set to an instance of an object. Source=BaptistTrumpetInvoicingV2 StackTrace: at EOL.BaptistTumpetInvoicing.GenerateSubscriptionInvoices.AddQBInvoice(Customer
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
Error when opening EDML from VS2022
Starting a few days ago, I am experiencing this error when opening the EDML within VS2022 that was working before:
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.
Generate Entities Prefixed with Schema Name
Hello, We are evaluating Entity Developer for purchase. We currently use "EF Core Power Tools". One of the few nice things about it is that when using Database First, it generates entity names that are prefixed with the schema name followed by an underscore.
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
Entity Framework support
Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
LinqConnect (LINQ to SQL support)
Discussion of open issues, suggestions and bugs regarding LinqConnect – Devart's LINQ to SQL compatible ORM
dotConnect for Oracle
Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
dotConnect for MySQL
Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
dotConnect for PostgreSQL
Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQ
dotConnect for SQLite
Discussion of open issues, suggestions and bugs regarding ADO.NET provider for SQLite
dotConnect for DB2
Discussion of open issues, suggestions and bugs regarding ADO.NET provider for DB2
dotConnect for SQL Server
Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Microsoft SQL Server
dotConnect for Cloud Applications
Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Cloud Applications
Next Page