If you installed Firebird ADO.NET provider 6.3.0.0 and EntityFramework.Firebird from nuget you also need to add the DDEX provider for Firebird into Visual Studio 2017 following these steps.
SouchProd.EntityFrameworkCore.Firebird is an Entity Framework Core provider built on top of the Firebird ADO.NET Data Provider. It enables use the Entity Framework Core 2.0 ORM with Firebird (2.x, 3.0) and Interbase.
CRUD operations are working (insert, update, delete, select), Scaffolding and migrations too (still contain a few bugs, some scenario could lead to an exception). Firebird 3 Identity columns are supported. Firebird 4 Alpha metadata charlength limitation (63 vs 31 before) supported.
Check more here.
It may came as a shock but Firebird does not have direct support for neither bools nor guids. On the other hand people around Firebird are smart and came with more or less standard solutions for both.
Did you ever think about how cool would be to have fully featured SQL database, without installation (just xcopy) and with Entity Framework support?
I was wondering whether the Entity Framework support I’m creating in FirebirdClient will work with Embedded version. Taking into account that the communication layers are under the EF support, there should be no problem. But you’ll never be sure until you try it. 😉 And it works.
