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
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
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
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 ?
Event when a connection is taken or put back into the pool
Hi, Is there an event when a connection is made or reset in the pool ? Thank you
How to Renew my dotconnect Oracle
How do I renew my licenses key of oracle dotconnect because I am facing the following error. Error : LicenseException: Feature is not supported. This error is thrown by Devart .NET Standard assemblies if license key validation fails. Possible reasons:
Missing Methods in Toolbox
Hello, I'm having an error when trying to access the ZohoConnection with the dotConnect, it hits me with a missing method error and im a little lost on where to go from there.
Lots of issues updating to version 6.1.134 of dotConnect SQLite Free in the Visual Studio 2022 community.
When upgrading to version 6.1.134 of dotConnect SQLite Free the Visual Studio 2022 community app stops working. Is it possible to roll back dotConnect version 6.0 for Microsoft Visual Studio 2022?
DotConnect for Oracle express edition version 9.14 cause serious memory leak!
I have this code to open Oracle connection: private OracleConnection _OpenDBConn() { bool successed = false; OracleConnection conn = new OracleConnection(ConnectString) { AutoCommit = false }; try { conn.Open(); successed = true; return conn; } finally
Integer[] value cannot be inserted into a PostgreSql database with LinqConnect
Hello, We have a column with datatype integer[] in one of our database tables. Using repository pattern, when we run this code: OurTableEntity entity = new OurTableEntity(); entity.OurColumn = "{-1,-1,-1,-1,-1}"; ourTableRepository.Add(entity); unitOfWork.Save();
ORA-01745: invalid host/bind variable name when parameters are reused in the linq query version 10.0.1.134.7 & EF7
Using 10.0.1.134.7 & EF7 When in .net the same variable is used more than once in a linq query, the bind variable in the query is rendered the second with 2 time ':' thus ::p__query_varname eg. excerpt: qry = qry.Where(z => z.DidoDocDosVersies.Where(y
dotConnect for Oracle and Entity Framework guide
Hello, I would like you to guide me about dotConnect for Oracle and Entity Framework configurations for the project I described with the following keywords. This help can be a sample project already exists, a post explaining the configuration, or a help
Save as different framework model?
As I requested a year ago, the reason I bought this was to migrate to EF from Telerik but my models are significant in size. I just need the basic relations in order for me to migrate since they list in the hundreds if not thousands in my models as the
Error "System.InvalidOperationException: Transaction already exists."
Hi, That error has already been mentioned here, but no solution. Wen can reproduce by doing this: //-------------------------------- try { //--step 1 try { Data1 dat1 = new() { field1 = 1, field2 = 2 }; ctx.Add(dat1); ctx.SaveChanges(); } catch(Exception
No DbUpdateConcurrencyException when OracleDbContextOptionsBuilder.MaxBatchSize > 1
Hi, we have an issue while enforcing optimistic concurrency in combination with an OracleDbContextOptionsBuilder.MaxBatchSize greater than 1 (eg. 50): there is no thrown DbUpdateConcurrencyException when there should be one. How to reproduce: Create an
Old DLL Reference (Devart.Data.PostgreSql)
Hello, in my Web Forms App I did upgrade to current Devart DLLs but there's somehow a hard reference to an older DLL and the only way I could solve it, was by using a DLL redirection - see below. Here's what I tried to solve it the right way: - I removed
Expecting Devart.Data.Oracle.OracleConnection but got Devart.Data.Oracle.Entity.av when using DbConnectionInterceptor
Version used: Used NuGet Package in .net 6 Project: Devart.Data.Oracle.EFCore 10.1.134.7 Problem: I need to Intercept the DbConnection to set some metadata but when using Microsoft.EntityFrameworkCore.Diagnostics.DbConnectionInterceptor instead of getting
Wrong number or types of arguments in call to 'SF_GET_CLIENTS_QUERY'
Hi Team, Facing this error, when we try to call a specific Oracle function, which has a input of type Table. there are no other mismatch on the number or type of arguments. Issue only when we use this particular parameter(atbl_client_nr). Below i have
Multiple Query
Hi I have a following problem: trying to utilize multiple query feature but getting error about incorrect sql syntax (ORA-00933). I want to pass few sql queries into one command, then execute reader, fetch data from first query, then call NextResult and
facing issue as Cannot describe stored procedure arguments
Hi Team, we are facing the same issue which is mentioned in below link, this is created around 2 years ago. Do not find any solution/fix provided. please help in understand the resiolution required. For reference we are adding the Procedure for reference.
Snapshot functionality or getting sqlite3* connection handle from SQLiteConnection
I need the snapshot functionality offered by SQLite as described here: https://www.sqlite.org/c3ref/snapshot_get.html but in context of a SQLiteConnection in turn used with Enity Framework 6. As far as I can see dotConnect for SQLite does not support
Installation Questions
I am installing dcoracle101pro.exe on a server that functions as a development environment as well as a production web server. When I attempted the installation it said that it was going to remove any old versions and I told it to go ahead and then another
Can a "dotConnect for Oracle" license be transfered from 1 developer to another developer
We're planning to buy a "dotConnect for Oracle" license type Team (up to 4 developers) for the company, and we analizyng the following scenario: If the 4 licenses are assigned to 4 different developers in the company, and at some point 1 of the developer
EF7: query (with JSON and CLOB) is much slower with directmode=true than without directmode
When querying an oracle view that has a CLOB which stores JSON using a connectstring with direct=true is much slower then without direct=true. <PackageReference Include="Devart.Data.Oracle.EFCore" Version="10.1.134.7" /> <PackageReference Include="Microsoft.EntityFrameworkCore"
Oracle RAC connectivity issue (regression)
Hi Devart Team, In early 2021 we updated our dorConnect for Oracle dependency to 9.14.1180 due to a client not being able to connect to their Oracle RAC database with our software. After the update all was good. Late last year we again updated our dotConnect
Could not load file or assembly 'Devart.Data.Oracle.Entity.EF5'
Hi, we moved from devart 8.4 to version 10.0 so current entity dll is devart.data.oracle.enity.EF6 but after running program on a new user environment we're getting below error although we never had or used such dll devart.data.oracle.enity.EF5 - no idea
Long response time for a query
Hi, Last year, I posted a question on the old forums and the answer was: you need to install the latest version... Which we did in September (version 9.16.1434). Now we're back in that period where our application is used a lot and we're still experiencing
Next Page