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?
Managing UniDAC Connections for Multi-Threaded Fetch & Transactional Updates
Could you please tell me how to use UniDAC? I'd like to use separate connections in threads for data retrieval (Select). For saving data, I want to update multiple datasets within a single transaction. Previously, I used TClientDataSet and switched its
SSIS Data Flow Components for MySQL and MariaDB Install err
An error occurs when attempting to install the current version of SSIS Data Flow Components for MySQL and MariaDB (version SSIS Data Flow Components for MySQL v.4.0.0). (Runtime error (at 239:515): Type Mismatch. The error occurs on all systems (more
Virtual Query and Blob
Hi, With last version of Unidac 11.0.1 and delphi 13 (september and october patch installed), i've this error when adding blob in virtualquery : Le projet MSat5.exe a déclenché la classe d'exception EAssertionFailed avec le message 'TBlob.Free RefCount
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,
pgDac and Google AlloyDB
Hello configuration: pgdac 9.0 standard, delphi 11.2, database Google AlloyDB (Cloud Database & postgresql share same issue anyway) AlloyDB is configured for public ips and "require SSL"; connection from PgAdmin on dev machine ok. blank project, PgConnection
UniDAC and OpenSSL 3.x compatibility for MySQL SSL connections
Hello, I am using UniDAC 10.0.0 to connect to MySQL over SSL/TLS. Currently my application uses external OpenSSL libraries libssl-1_1.dll / libcrypto-1_1.dll (OpenSSL 1.1.1w). Since OpenSSL 1.1.1 is EOL, I would ask. Does UniDAC 11.x support OpenSSL 3.x
Direct Mode is not supperted with DBF file connection
if set Direct Mode=False,get error. older version uniDac work well on delphi 11.
IBDAC Connection
Firebird 3/ IBDAC 7 Hello, i have a small client server network (2 pc's) . On the Client PC my connection ini file is : Data Source=192.168.1.10 Port=3050 DataBase=192.168.1.10:eOlive <-----Alias on Database.conf Client Library=C:\Windows\System32\FBCLIENT.DLL
Unidac express and Oracle
Hello I am doing some experiment with Unidac express together with odac but I am experiencing an issue with latest release. I have installed version 14.0.1 of Odac professional, and version 11.0.1 of Unidac express. Simple form with UniConnection, UniQuery,
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
Unidac and PostgreSQL 18.1
Does latest Unidac 11.0.0 support PostgreSQL 18 (which was released in September) or the latest version 18.1 ?
Maximum Depth Of An Expression Tree in direct mode on TUniConnection
Hi, how I can increase Maximum Depth Of An Expression Tree value in direct mode on TUniConnection?
dbexpress for Oracle and PostgreSQL different behaviour (probably bug in oracle one)
Hello Environment Delphi 11.2 Latest dbexpress drivers for Oracle and PostgreSQL PostgreSQL database: Insert sqlconnection, configure access, connected := Truee Insert SQLQuery, link to connection, edit SQL: "select * from TABLE where field = :P1" Confirm
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
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:
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.
ODAC and Oracle Home
Hello... I am doing some test with ODAC ... for possible switch from dbexpress... I have Oracle 26ai FREE installed in my windows 11 machine I do see that OraSession does not populate "Home", and by consequence neither the Server names... If I try to
connection to cloud autonomous database in direct mode
Hello all, I know how to connect using OCI client to cloud oracle autonomous database, what I am asking is if there's a way to connect using dbxoda in direct mode... Is there some tutorial or blog post or whatever on this topic? in case dbexpress is unable
TUniConnection feature request
Hello Please add TUniConnection.CommandTimeout specific option for SQL Server because ConnectionTimeout and CommandTimeout are not the same things. See MSClassesUni.pas, line 1246 It's need for Connection.ExecProc and Connection.ExecProcEx
How to retrieve the field structure in a dataset ?
I searched Google and couldn't find anything about it. I use "Unidac" and I'd like to know if anyone has created a function to return the SQL field structure. Example SQL SELECT
Case When (CC.FOTO is Not Null) Then 'Sim' Else Null End as FOTO
FROM CADASTRO_PESSOAS
SDAC 8.2.8 - stored procedure output parameter
I am using SDAC 8.2.8 with D 10.2 and have strange problem that I think might have already solved, however it is all strange, maybe someone will be able to explain what is going on. I have stored procedure in MS SQL Server: CREATE PROCEDURE [dbo].[AAAA]
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";
new UNIDAC (11.0) don't support Unicode? older version (9.3) done well.
new UNIDAC (11.0) don't support Unicode? older version (9.3) done well.
ODAC 13.4.1 different behaviour related to ODAC 9.0.1 related to persistent fields on Delphi 7 and Oracle 19.22
Hello, Recently we updated our libraries on an old but important project from ODAC 9.0.1 to ODAC 13.4.1 and we observed the following: After the update in case an OraQuery gets a persistent field having the size property holding a value less than the
Update Failed
Hi I upgraded to IBDAC 10.0.0 and now there is an error after inserting a record. (after the refresh) "Update Failed Found 0 records" Now I have downgraded to 9.3.0 and it works again. I have a TIBCQuery-Object with SQL: SELECT KDMANAG.*, (Select MINAME
Update from 9.5.15 for RAD Studio XE4 to most recently
Hello, I am currently using version 9.5.15 of your product with RAD Studio XE4. I would like to know if there are commercial options available to upgrade my license to a more recent version. Could you please provide details on the upgrade process, pricing,
MyDAC with Lazarus
I am currently using myDAC Professional 13 with Delphi 12.1 and would like to test with Lazarus. Just checking - I would need to upgrade to MyDAC Professional with Source Code? Are there any docs on how to install myDAC for Lazarus?
Firebird - RETURNING not working
Hello. I'm having problem in Firebird with RETURNING value with latest Unidac 10.1.0 on Delphi 11 update 3. Problem occurs when "same" query is used for SELECT and INSERT/UPDATE. I've attach db.txt with sample table T1 with three fields (ID,f1,f2). Here
Connecting to a PostgreSQL database using SSL when the server requires SNI
Hello, We have a problem connecting to a certain cloud PostgreSQL database using SSL, because the server requires a server name indicator (SNI). We tried the both connection ways described in the "Connection to PostgreSQL through SSL in Delphi" manual
RAD Studio 13 Florence
Hi, I was wondering when mysqldac delphi components would be available for RAD Studio 13 Florence?
dbExpress Driver for SQL Server support for TLS 1.3
Does dbExpress Driver for SQL Server supports TLS 1.3?
Strange Refresh Failed error message
Hello, I have a TOraQuery component, with a relatively simple select. It joins tables for the master table called ATB. select atb.rowid, atb.*, sby.c_nev1 c_belep_szintnev, bko.c_nev c_szervezetnev, saj.c_nev1 c_uzemkodnev, bkp.c_nev c_onelszamolonev,
Any plans to create an ODBC driver for Xero?
Hi Just wondering if there is any plans in the works to create an ODBC driver for the Xero platform?
Next Page