Keep getting an exception of "ORA-00971: missing SET keyword" where SET keyword is there.
Hello friends, I keep getting an exception of "ORA-00971: missing SET keyword" for the following source code. I have no idea why. As you can see, it has SET keyword. Any ideas? Thank you so much! try { OracleConnection connection = new OracleConnection(_connectionString);
Entity Developer - generated metadata error - Delphi and MariaDB
Hello, in table are BIT type fileds. After generate code are errors in datamodel.metadata.pas file now in source code: FKontrolamnozstvi := TMappedAttribute.Create(Self, 'Kontrolamnozstvi', etBoolean, False, 'KontrolaMnozstvi', False, False, 'b'0'', 'BIT
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.
MAX number of connections reached
hi. I have a C# .net WebForms app with several hundred users. it is running on windows server 2016. my connection string looks like this: value="direct=True;Min Pool Size=5;Max Pool Size=200;Validate Connection=true;Connection Timeout=5;Default Command
ORA-01745: invalid host/bind variable name when using the same variable multiple times in EF7 query Where()
Hi, were are currenly using Devart.Data.Oracle.EFCore v10.1.134.7 in combination with EF7 on net6.0. Whenever we use a query that uses the same variable 2 times or more in a Where() method we get an ORA-01745 exception. Example: var today = DateTime.Today;
Cannot find Datamodel.hbml file error NHibernate
I am following the instructions for database first creation. However, at the end, the template fails to find the hbml file in the appdata folders. This only happens with NHibernate templates.
quick question about Connection Lifetime
I have a asp.net webforms app with several hunderd users, and I would like to shorten the connection life time. currently it is set to 1800, which is 30 minutes. I am wondering if setting "Connection Lifetime=300" is too agresive. that is 5 minutes of
dispose datacontext
I am disposing dc like this: private void DisposeDB() { if (DB != null) { if (DB.Connection != null) { DB.Connection.Close(); DB.Connection.Dispose(); } DB.Dispose(); DB = null; } } I am 100% sure I am a always uysing the "using" C# keyword to instentiate
performance monitor
may I use windows performance monitor to watch dotconnect oracle connections? I am using direct mode to connect to database. I would like to add some counters for dotconnect conections. do I have to install dotconnect on the server in order to use the
Performance Counters Support
hi. I would like to use performance monitor tool to monitor IIS connections on the server. how may I create counters for dotConnect for oracle? do I need to install dotconnect on the server? thank you
Czech accent characters
Hi, I have an issue with dotConnect for Oracle and Czech accent characters. I do not understand why on one computer I need "Unicode=true" settings in the dotconnect connection string (without it the Czech accent characters do not work) but on another
Test
Test
Entity developer (NHibernate) 7.1.151 generating wrong SQL at Update the Database from Model
Hello If you add an association between two entities with composite primary keys, entity developer (NHibernate) 7.1.151 will generate the wrong sql script at "Update the Database from Model". Example (Assoc is One Cat to Many Dogs, ISet) The generated
Issue on Fresh installation of ADO.NET Data Providers whit VS 2022 x64 and win 11
Hi on first trial installation of ADO.NET Data Providers I have this issue when try to add on VS 2022 windows form a devart Uniconnection : Is it because it uses x86 references? Tks for any info....
Unhandled exception. System.ArgumentNullException: Value cannot be null. (Parameter 'expr')
Hi Devart team, I am facing an issue in my .NET 7 application connecting to an Oracle Database using Devart.Data.Oracle.EF library. When I try to query the parent table that is configured using table-per-type (TPT) I got the next error: Unhandled exception.
Entity Framework Core 8 (EF8) / .NET 8.x support
I am wondering when .Net 8 support will be released for Entity Developer? Do we have an ETA on that yet?
How to add DefaultValue attribute
Hi, I am using Entity Developer 7.2.10, in DB First on EF Core 7 and Data Annotations for Validation Framework. I want to add the standard attribute: [DefaultValue(false)] to a boolean field, but this is not available in the properties at all. I am aware
Multiple DbContext in one transaction in NET6 Devart.Data.Oracle.EFCore 10.2.0.7
Hi, When trying to use multiple dbContexts in one transaction I get the following error when setting the transaction: dbContext.Database.UseTransaction(transaction) System.InvalidOperationException: 'The specified transaction is not associated with the
Support .NET 8
Hi With the release of the LTS .NET 8 version, is there a plan for support for .NET 8 dotConnect Universal? https://learn.microsoft.com/en-us/dotnet/core/whats-new/dotnet-8
dotConnect Oracle Entity Framework 8 and Oracle Database 11/12
There is already a question about the release of dotConnect Universal. This question is about dotConnect Oracle. Do you already have a release date planned? As Oracle dropped support for Database 11/12 in their EF 8 driver. Will your EF 8 driver keep
License issue
Hey, I'm having an LinqConnect professional license with expiration date 13th october 2022. Today I tried with the included version 5 using LinqConnect with PostgreSQL and it raised an LicenseException. So the question is, what happend ? As I can see
InvalidCastException with value types and logging applied to the DbContext
Hi, We are using Microsoft.EntityFrameworkCore 7.0.15 and Devart.Data.Oracle.EFCore 10.2.0.7. Some of our queries use value types in the where clause but don't work when we enable logging for the DbContext. I have a attached a small project which reproduces
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
Error No Entity Framework Provider found for Devart.Data.SQLite
Hi! I maintain a .NET Framework 4.8 app that uses DevArt DotConnect for SQLite. It uses Entity Framework to talk to a database where application logs are stored. Anyway, starting about a year ago something changed in the app's config that's causing an
Devart.Data.Oracle.OracleException : ORA-00920: invalid relational operator
Hi Devart team, I am getting the error Devart.Data.Oracle.OracleException : ORA-00920: invalid relational operator when querying the database using a bool property in a where clause like: var students = _dbContext.Students.Where(s => s.IsActive).ToList();
dotConnect MySQL Info
2 questions with the dotConnect for MySqL 1) does dotConnect for sql work with the square brackets in mySQL? The devArt MySQL Odbc driver handles the square brackets but it looks like the [] are throwing an error? Example select * from [Company] 2) using
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
How to determine which version of dotConnect for Oracle is being used?
Hello, let me first give you my context as succinctly as possible. Our .Net Framework application uses dotConnect for Oracle NuGet package 9.X.X. When I joined the team and started developing for the app, I realized that certain queries took extremely
Oracle Advanced Queuing - OracleQueue.Dequeue
OracleQueue.Dequeue only returns the first message. In my test I enqueue 20 messages, and only the first one gets dequeued. I have no idea why.
Does DotConnect Universal also support Net 7 ?
Hi, I saw that with Build 134 DotConnect Support Net 7. Does this also includes DotConnect Universal ? I only found information for the individual Daztabases. Thanks and regards Uwe
Doesn DotConnect Universal support Net7
Hi, does DotConnect Universal already support Net 7. I get the following Error Message when I try to open a database: System.MissingMethodException: "Method not found: 'System.String System.AppDomainSetup.get_LicenseFile()'." I am using the SQLiteCrypt
Oracle.EFCore: saving to DB fails with error "NetTopologySuite spatial service is not registered"
Hi, I am currently trying to migrate my Blazor Entity Framework Identity app from Oracle Managed EF package to Devart EF package. Reading from DB seems to work fine, however, I can't update any rows in DB getting the following exception: 13:27:08.90 fail:
EF7: issue with case/when in version 10.1.151.7 (ORA-00920 : invalid relational operator)
Hi, In version 10.1.151.7 a wrong query is generated. We currently use version 10.1.134.7 which doesn't have this issue. The generated query looks as follows (in bold the incorrect part): ---- SELECT "l".A "A", "l".B "B", (CASE WHEN "l".C THEN 2 ELSE
Compiled query errors
Hello, After I 'v updated DB connector from version "10.1.134.7" to "10.1.151.7" , I started to get errors on compiled queries. I'm using EF7 on NET7. In the previous version, everything worked pretty well. Example of call: private static readonly Func<Model,
Handling of a bit array
Hello, recently we moved from 7.24.2066 to 8.1.151. Is there a difference now in handling a bit array? In the database there is a field of type "bit(7)". When filling a datatable (PgSqlDataAdapter.Fill), there is a different result in the corresponding
AccessViolationException in OCI mode, Devart 10, EF 6.4.4, Oracle 19
Hello Devart team. We are using Devart.Data.Oracle 10.0.0.0 for .NET Framework + EntityFramework 6.4.4. Our application is targeted to .NET Framework 4.8 and runs as 32 bit service process with "Local System" permissions. Devart.Data.Oracle runs in OCI
How can I query the WorkstationID value assigned in a connection string using T-SQL?
I am assigning the ApplicationName and WorkstaionID properties on a SqlConnectionStringBuilder. I can query the ApplicationName from sys.dm_exec_sessions. I would like be able to query the WorkstationID value using T-SQL, also. My goal is to be able to
dotConnect for MySQL components not appearing in Visual Studio 2022 toolbox
I have installed dotConnect for MySql product The MySQL menu item appears in the Tools menu of 2022 I am building a project for .Net 7.0 - see attached image The dotConnect components do not appear in the Toolbox. I followed the instructions for adding
Asp.net project Getting Devart error during build pipeline (Azure Devops) - License compilation file - Unable to resolve type 'Devart.Data.Oracle.OracleConnection,
Asp.net VB Project. It has Class library project & Asp.net website project in solution. Builds in dev machine. During Azure Devops build pipeline, getting below Unable to Resolve Type error during license file compilation. Please help on resolving this
Connecting Delphi client to .NET FireDAC alike server ?
I am aiming to replace Delphi FireDAC based server with .NET C# ASP.NET server which to keep providing the FireDAC requests to the Delphi clients. Is there such a thing ?
Next Page