Entity Framework Core - Knowledge Base (KB)

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...

EF Core - Firebird Migration auto-increment problem

I'm testing the migration with EF Core with MSSQL-Server and Firebird 3.0. ...I create a new table with a few fields. The key-field has the property ....ValueGeneratedOnAdd()..., but the key-field in the Firebird database doesn't get an auto-increment dur...

How to implement Entity Framework Core 3.1.2 with Firebird database using 'database first approach'

I am currently developing a .NET Core 3.1 Web API which should communicate with a Firebird database (storing/retrieving data). I would like to handle that communication using ...Microsoft.EntityFrameworkCore... 3.1.2. Entity Framework is completely new fo...

Handling relationships in EF Core 3.1.2 & FirebirdClient 7.5.0

I am not quite sure how to handle a relationship in entity framework core using the firebird provider. I got a table 'Users' and 'Employees'. They got a One-To-One relationship using the column 'username'. I tried several tutorials but could not get it to...