Entity Framework 6 - Knowledge Base (KB)

Entity Framework and Views

I've created a view in my database which I would like to include in my entity model. However, when I try to update the entity model through VS 2008, a warning message informs me that the TABLE OR VIEW I'm trying to add doesn't have a primary key. ...It se...

How can I register Firebird as an Entity Framework data provider?

How do I register a Firebird data provider to use it with Entity Framework?... What should I do to make it appear in the ...Entity Data Model Wizard/Choose Data Source... window?... I expect it to appear in the ...Data sources:... or ...Data provider:... ...

Entity Framework Code First - Cast smallint and integer to int32

Im working on a small service tool for a database. My problem is that due the last update, some smallint-colums had to be be changed into integer. ...public class TEST { public int ID { get; set; } //public Int16 ID { get; set; } public string...

"Unknown data type" error with Firebird embedded and Entity Framework 6

I'm using an embedded Firebird database with code first (Entity Framework 6). The first time the application runs, it works fine: the database gets created and the data gets inserted. But every time it runs after that, it throws the following exception:...

Firebird 2.5 + EF6, how to set transaction to wait

How can I set transactions in EF6 with firebird provider 4.0 EF6 to wait. Default is no wait, so I get a lot of exceptions....To set the transaction isolation level, I use ...dbContext.Database.StartTransaction().... I try to use isolation level serializa...

Firebird + Entity Framework 6 in Visual Studio 2012 / 2013. How do I get both visual & non-visual components to work?

Does anyone have Firebird working with Entity Framework 6 at both design time and run time?...I'm mainly using VS 2012, but I get the same results in VS 2013. ...Depending on the components I install I can get either design time or run time to work, but ...

Entity Framework 6 / Firebird database provider compatibility issue in Visual Studio 2013 Prof

I'm using Visual Studio 2013 Professional and .Net 4.5 on Windows 7-x64. I have Firebird 2.5.4-x64 installed....I know that others are able to use Firebird with Entity Framework 6, and I figured out several issues on my own by reading lots of blogs and s...

New embedded Firebird, code first, EF6 project results in SerializationException

I'm trying to set up Firebird with EF6 as an embedded server for a simple app I'm writing but haven't been able to get it to work. I have a CLI project which is the app and the DAL project which is the DB. I added the NuGet packages to both and created a ...

Firebird .NET Provider 5.0.0 and EF6

I have been trying to create Entity Data Model of Firebird database, but i can't get past this error: ...I have installed:...DDEX provider 3.0.2.0 ...Firebird .NET Provider 5.0.0.0 (tried both installing it with .msi from Firebird's official site and ma...

FirebirdSql.Data.FirebirdClient.FbException: too many open handles to database

Today I did a larger data import into a firebird 2.5.6 database and I got this exception:...System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> Firebi...

Entity Framework and Firebird DB Dialect 1 - not generating compatible sql

I am trying to setup a project with EF on top of a firebird DB but it is generating extra quotes that the Firebird db is rejecting....The db already exists and there is a matching record for this query there. Error is FbException: Dynamic SQL Error SQL er...