Entity Framework 6 - Knowledge Base (KB)

System.Data.MetadataException: Unable to load the specified metadata resource

My connection strings are as follows:...<add name="RollCallDBEntities" connectionString="metadata=res://System.Engine/RollcallNS.csdl|res://System.Engine/RollcallNS.ssdl|res://System.Engine/RollcallNS.msl;provider=Devart.Data.Oracle;provider connection st...

Connection closed when doing Transaction rollback on Mysql with Entity Framework 6 and Devart provider

I'm working on a project that uses Entity Framework 6 RC to connect to a Mysql database with the Devart provider(v7.8.322.0)....But now I run into a problem that when a query fails, the rollback of the transaction fails because the connection is closed...

How to call a Stored Procedure inside an oracle package with Entity Framework?

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_in in string, is_current_in in num...

Error "column c.CreatedOn does not exist..." in PostgreSQL logs during code first context initialization using the Devart dotConnect provider

I'm getting the following error in my PostgresSQL logs whenever my context is initialized:...2014-06-03 09:51:25 PDT ERROR: column c.CreatedOn does not exist at character 10 2014-06-03 09:51:25 PDT STATEMENT: SELECT c."CreatedOn" FROM "__Migr...

Calling an Oracle stored procedure with Entity Framework code-first and DevArt Drivers

I have an Oracle stored procedure that I am trying to call with EF code-first (...DbContext...) using the DevArt Oracle drivers (latest version). I don't know why this has to be so hard (I wish I was using SQL Server), but I cannot make it work. I am doin...

OutOfMemoryException with SQL Select

I'm currently analyzing an OutOfMemoryException occuring in our application when doing a SQL select....Environment:... - x86 .NET 4.6.1 application (No possibility to use it as x64)... - Devart.Data 5.0.1491.0... - Devart.Data.Oracle 9.1.67.0... - Entity ...

ORA-01450: maximum key length (6398) exceeded (Devart.Data.Oracle.OracleException)

First dataaccess method using entityframework fluent api , Dev Art in oracle database getting below error....actual table design :...this query failing.... CREATE TABLE DADeskSettings ( UserID NVARCHAR2(2000) NOT NULL, Password NVARCHAR2(2000) NOT N...

System.Data.Entity.Core.MetadataException: Schema specified is not valid

I tried to add a db-Migration to my solution. But it quit with the folloing error:...System.Data.Entity.Core.MetadataException: Schema specified is not valid. Errors: (0,0) : error 0040: The Type NVARCHAR2 is not qualified with a namespace or alias. Onl...

Postgresql Devart EF : The underlying provider failed on Open

i got this exception when executing a simple read query using entity framework on our Postgre Db, in the code, which throw this exception, i dont use transactions the code do not fail systematically but randomly...this the stack trace :...{ "Depth": 0, ...

Entity Framework not cascade deleting

In short EF default is to delete cascade. I have a parent/child relationship I set up using Entity Developer by Devart. It is set to delete cascade. The parent table looks like this:...CREATE TABLE `Tools` ( `ToolNumber` TEXT, `ToolID` INTEGER PRIMA...

Entity Framework - Simple query takes 3 minutes to complete

I'm using Entity Framework 6 Code First with an Oracle database (using Devart DotConnect for Oracle)...With a specific query with a SingleOrDefault, the query takes 1 second to complete :...-- Executing at 08.10.2019 10:04:04 +02:00 -- Completed in 1211 m...