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
Table Mapping Generator
Hi All, during the generation of the mapping for a Database in EF Core v 7, importing the tables in model we have an error because is inserted a wrong value into a table definition. The wrong value is: .UseTptMappingStrategy() another problem is that
ExecuteDeleteAsync Error
Hello, every time i try to use ExecuteDeleteAsync in EF7 , for example context.TABLE_NAME.Where(x => x.ID == id).ExecuteDeleteAsync(cancellationToken: cancellationToken) i get error like : System.InvalidCastException: Unable to cast object of type 'Microsoft.EntityFrameworkCore.Query.SqlExpressions.DeleteExpression'
Saving NULL geometries in Oracle DB with EF Core
We are migrating our solution from EF6 to EF Core and .NET Framework to .NET 6. When saving an entity using EF Core (using UseNetTopologySuite on the DbContext) where a column of type Geometry is NULL, it results in the following error: Microsoft.EntityFrameworkCore.DbUpdateException:
Oracle - Query Type class '____' cannot have primary key.
In the Oracle Entity Developer, I'm getting this error on some tables: Query Type class '____' cannot have primary key. The table does have a primary key in Oracle, but it is a varchar column. How can this table be used?
Unknown Database error when running initial migration
Connection string is: "Server=127.0.0.1;Database=MyDatabase;Uid=username;Pwd=secret;" Entity Framework Core 7 My SQL version 8.0.32 Initial migration is scaffolded using `add-migration`. However `update-database` fails with error: "Unknown Database MyDatabase"
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
TUniMetadata and database structure.
Hi! Now I can get tables, columns, columns types and indexes. tables procedure var FUniMetaData: TUniMetaData; begin FUniMetaData := TUniMetaData.Create(nil); try FUniMetaData.Connection := FConnection; FUniMetaData.MetaDataKind := 'Tables'; FUniMetaData.Open;
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
Next Page