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
VirtualQuery IsNULL
Hi, Is use a virutalQuery to show informations : 1. SELECT A.INT_COUT,A.MAT_ID,A.INT_DEB,A.INT_TECH,CAST(SUBSTR(A.INT_DESC,0,255) AS VARCHAR(255)) AS INT_DESC_T,CAST(SUBSTR(A.INT_ACT,0,255) AS VARCHAR(255)) AS INT_ACT_T,A.INT_FIN,A.INT_TYPE,(B.T_CIVILITE
SqLite Localized Order
Hi With Android Studio Java I can select a sqlite table like Select * From MyTable Order By Name Collate Localized The data returns ordered by with my language specific characters But there is no such an option with Delphi/Unidac I receive an exception
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,
Batch move and creating destination table in Access
Hello! I'm experimenting so that we can move away from Paradox onto something a little bit more useful. For the time being, however, the "temporary fix" is Access. Let's not go into the why, how, etc. For now this is the best course of action. The access
ODAC local filter raises EVariantTypeCastError
We have tried to use a newer ODAC version in production. The following issue is a showstopper for us. It seems that this issue exists since version 12.3.0. Steps: - compile and execute the following command line application Expected: the output is PASS
DBExpress driver for PostgreSQL
Hello, I've read that you can't use multi transaction with Devart drivers for PostgreSQL. But I also read that PostgreSQL seemed to support it. Can you tell me what's going on? Thank you in advance. Lbn69
ODAC: "Invalid Field Type" when calling a stored function with VARCHAR2 params
We have developed a VCL application in C++Builder, using RAD Studio 12 Version 29.0.51961.7529 (Version 12.1 basically) with a target platform Windows64. Our database is Oracle 19 running on an ODA with latest patches. The problem always occurs when I
EntityDAC developer on Oracle
Hello, I'm trying to use Entity Developer to generate model for my Oracle database. It seems that after model generation some table are not still present in the database. I'm using Entity Developer version 6.12.1354 trial. Thank you, Luca
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
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
Module Class connect() method ConnectMode = "Unsafe" parameter
Hi All, I am using this connector for a few days now and I am quite happy with it. Recently I had to deal with a connection to a 3rd party Visual Foxpro database in which I couldn't connect because the dbf file I wanted to access was locked by another
XDBGrid sort function doesn't work
I'm using the XDBGrid sorting feature in FireDac, but it doesn't work in uniDac. If you have any solutions, please let me know. XDBGrid Designer -> Contrlo2 -> sortingControl
opened connection by an exception
In the TCustomPgDataSet.Execute(PgAccess) becomes TCRConnection.FAutoCommit(CRAccess) set to false and not reset after the exception in the RefreshRecord. Then the error dialog, through our THauptForm.ShowServerTimer a ConnectionCheck with "Select true,"
Firbird 5.0 / Substring in IbcQuery.Filter
Hello devart team, Try to filter an IbcQuery (latest release) with firebird 5.0 : IbQuery1.Filtered :=False; IbQuery1.Filter := Substring( MyField from 1 for 5) = 'Hello' IbQuery1.Filtered :=True; This rise an error : "Substring is an unknown Field" (Something
SOQL queries - field/column aliases not recognized and/or toLabel() function duplicate field errors
Currently running Devart ODBC Driver for Salesforce 3.4.1, set up as linked server in MSSQL 2019 (15.0.4405.4), and I don't seem to be able to use field aliases when running SOQL queries via an OPENQUERY statement. For example: SELECT * FROM OPENQUERY(PCCUSFPROD,
.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.
Access Direct Mode Connection Fails if Database has a Query (View)
We get EAssertionFailed with a message beginning "jTYPE_ATTRIBUTE" (JetTable.pas line 5126) when using an Access database in Direct mode, but only if there is a query defined in the database. We are using UniDAC 10.3.1 for Rad Studio 10.4. Recent release
Skip exception
hi all ! I have the following code that returns a bool value. If there is no connection it should be false. The problem is that I always get the exception and get out of the program. Is there a way to avoid it? private static bool IsMariaDBServer(string
SOQL error: unexpected token: '('
I have a complex SOQL query that includes nested queries of child objects that works in the Salesforce workbench but fails with the error "OLE DB provider "MSDASQL" for linked server "SALESFORCE" returned message "[Devart][ODBC][Salesforce]Invalid SOQL:
DIRECT Mode fails with "Net: error 99" if a TYPE is modified between uses in a SELECT
Hello, Using the attached demo project with the latest version of ODAC and Delphi. You'll have to enter your own user/pass/server. The bug happens on any Oracle version. After connecting in direct mode, a script runs which does the following: 1) Creates
TUniLoader
I'm using TUniLoader with SQL Server and it works fine. I would to know when the component finishes writing data on the database. Is it at the end of OnPutData event?
Firebird query statistics, int32 of int64?
Hi, In my application, I'm using TIBCConnection.DatabaseInfo to fetch query statistics, the Reads/Writes/Fetches/Marks fields. These are int32, but I think these should be int64. Can you check with the API? Here's an example of values that clearly overflow
Direct connect to MS Access in 64bit application
Hi, Since we have issues with connectivity through OLE DB (using ADO) on certain installations (mostly windows hosts with win32 Office installed) we're trying to use UniDac in order to connect to a MS Access database in direct mode. Delphi 10.4 and UniDac
securebridge with mydac
ThirdParty demo mydac are SecureBridge(Deprecated) and SecureBridge With last delphi 12 with patch wich one should be install deprecated has MySSHIOHandler and MySSLIOHandler In mydac connection handler properties have no longer available components if
Received error message not overriden in inherited class
with securebridge (ssh connection i received this error message. In local connection not received nothing Any idea why I received this error see attach file
UniScript unterminated dollar-quoted string
I have a problem with Uniscript when running the command below CREATE OR REPLACE FUNCTION public.fin_fc_cte_integracao_fin() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE vFlgBaixado boolean; BEGIN IF (TG_OP = 'DELETE') THEN SELECT (CASE WHEN dat_bai
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
System.AccessViolationException when having parallel db writes using Devart.Data.SQLite.EFCore
Hi, I've observed and AccessViolationException when running unit tests in parallel. Investigating this I found out that creating multiple different databases, or even inserting new entities in a database, in parallel can cause this exception: Fatal error.
OptimizedBigInt on Mysql 8.*
Hi, I have OptimizedBigInt on in options, and in MySQL server 5.7 this SQL works well and produces an integer field type: FLOOR((DATEDIFF(CURRENT_DATE, STR_TO_DATE(Birthdate, "%Y-%m-%d")) / 365)) AS Age But on MySQL 8.*, I am getting: Type mismatch for
PostgreSql.EFCore: problem querying spatial data
Hello I migrated from .Net Framework to .NET Core 6.0 and have a problem querying spatial data. DbContext is extended with: optionsBuilder.UsePostgreSql(connectionString, options => { options.UseNetTopologySuite(); }); I use database first approach, the
"CROSS APPLY" is not supported in Postgresql?
Hello If I use a LINQ query over 2 tables, I get an error 42601: syntax error at "APPLY" It seems that the SQL contains "CROSS APPLY" which is unknown in Postgresql. How can I avoid that ? Never had that problem with the previous versions (.NET Framework)
No data gets written to the database with Devart.Data.Oracle.EFCore 10.2.0.7 and Microsoft.EntityFrameworkCore 7.0.15
Hi, I'm working on migrating an application from .NET Core 3.1 to .NET 6. This project previously used to following nuget packages without any issue: * Microsoft.EntityFrameworkCore 5.0.4 * Devart.Data.Oracle.EFCore 9.14.1228 I have now updated those
EF Core 7 MaxBatchSize and auto generated ID's
When using a MaxBatchSize I get an Exception when inserting a record, the ID is auto generated by the database: The property 'Planning.PLANNING_ID' has a temporary value while attempting to change the entity's state to 'Unchanged'. Either set a permanent
Unitable with postgreSQL (v17)
I'm using TUniTable with postgreSQL v17. When I open semi large table (140 000 rows, 220 fields) with unitable it takes 3-4 secods. is there any way to avoid this delay, like take just first record etc unidac is latest 10. Server version: PostgreSQL 17.0
How much time does it need Devart to fix bugs in ODAC?????
Honest Question on ODAC Support Quality I am in the process of porting a massive application (5 million lines of code) from DOA to ODAC. The application uses an intermediate access layer, so my job is to port this layer from DOA to ODAC. I started this
Next Page