My connection strings are as follows: <add name="RollCallDBEntities" connectionString="metadata=res://System.Engine/RollcallNS.csdl|res://System.Engine/RollcallNS.ssdl|res://System.Engine/Rollc...

I've recently been dealing with some performance problems and am trying to figure out how to exponentially increase the performance of some calls to an Oracle DB. Technologies: .NET Core 2 Oracl...

I'm using Entity Framework Core 2.1.4 with Oracle 11 database and Devart.Data.Oracle.EFCore provider. Database first approach. I want to get from sequence value for ID column (primary key) on inse...

How to add Devart's Code Compare as custom diff & merge tool within Sourcetree?

I'm getting Nullable object must have a value after checking for null on a regular object, after a null check. I've found various questions, mostly regarding linq-to-sql, having the same problem bu...

Why does not Oracle ODP recognize the parameter Unicode=true and Devart's Provider does? WHen I have data containing the string : "ñãõ,éóúý" , my asp.net application shows "???,????" if I'm using ...

a few days back i was trying the new ORM for delphi from Devart called EntityDAC, well i was reading the docs specific the LINQ part, when i saw something like: Linq.From(Emp).Where(Emp['Sal'] &gt...

I have a package in oracle 11g as follow: CREATE OR REPLACE PACKAGE "HRS.PKG_TRAINING_SP" as TYPE T_CURSOR IS REF CURSOR; procedure GETPERSONNELTRAINIGLIST( personnel_Id_in in string, base_date...

I am developing a rich client application that will use the Entity Framework (with DevArt's DotConnect for Oracle) to connect to a central Oracle database. However, I have found that this scenario ...

Why does .NET Entity Framework produce SQL that uses a subquery and left outer join on a simple 1-to-1 relationship? I expected to see a simple join on the two tables. I'm using Devart Dotconnect f...

I have a postgresql database with postGIS and I'm using entity framework with dotconnect 6.7 for postgreSQL. With the following table in my database: CREATE TABLE geo ( the_geom geometry, id i...

This is a follow-on from this question really: Moving From LINQpad to a Proper Visual Studio Project? ..but I'm not able to get it to work properly. An answer to that question suggestions dumpin...

I have an Oracle database that I access using Devart and Entity Framework. There's a table called IMPORTJOBS with a column STATUS. I also have multiple processes running at the same time. They e...

I am facing a problem that drives me crazy for couple of days now, hoping someone can help me. Here it is ; I'm using EF4 with oracle database, using dotConnect for oracle from devart as provider....

I am using DevArt's dotConnect and Entity Developer for my application. I've created the tables using the Entity-First feature. I notice that many of the column types are set to CLOB. I only have ...

Can somebody tell me, why does Linq to Entities translate many to 1 relationships to left outer join instead of inner join? Because there's referential constraint on DB itself that ensures there's ...

I'm using LINQ to Entities to display paged results. But I'm having issues with the combination of Skip(), Take() and OrderBy() calls. Everything works fine, except that OrderBy() is assigned too ...

Has anybody done a comparative analysis of dotConnect for Oracle from DevArt and the ADO.NET data provider from DataDirect. We are thinking of using the Entity Framework support available in these...