Using Scaffold-DbContext in EF Core 2.1 with Firebird database (edit)

Currently supported by EF Core:

  • Microsoft SQL Server
  • SQLite
  • Postgres (Npgsql)
  • SQL Server Compact Edition
  • InMemory (for testing purposes)
  • MySQL
  • IBM DB2
  • Oracle
  • Firebird

Forcus on:

  • .NET Core 2.1
  • EF Core 2.1
  • Firebird Database
  • Scaffold-DbContext
  • Generate Models from Existing Database

Nugets:

  • .NET Core 2.1
  • ASP.NET Core MVC 2.1
  • Install-package EntityFrameworkCore.FirebirdSql -Version 2.1.2.2
  • Install-package Microsoft.EntityFrameworkCore -Version 2.1.14
  • Install-package Microsoft.EntityFrameworkCore.Tools -Version 2.1.14

EF 6:

  • EntityFramework (EF 6)
  • EntityFramework.SqlServerCompact (EF 6)

EF Core:

  • Microsoft.EntityFrameworkCore
  • FirebirdSql.Data.FirebirdClient
  • FirebirdSql.EntityFrameworkCore.Firebird

.NET Provider for Firebird

  • Firebird ADO.NET Data Provider
  • Microsoft SQL Server Compact Data Provider 4.0
  • More ...

How to build a Connection String?

Class: FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder

var connectionString = new FbConnectionStringBuilder
{
    Database = "mydb",
    DataSource = "localhost",
    ServerType = FbServerType.Default,
    UserID = "sysdba",
    Password = "masterkey",
}.ToString();

How to use Scaffold-DbContext?

Scaffold-DbContext "character set=none;data source=localhost;initial catalog=mydb;user id=sysdba;password=masterkey;" EntityFrameworkCore.FirebirdSql -Force -OutputDir Models

Scaffold-DbContext "User=xxxx;Password=xxxx;Database=xxxx;DataSource=xxxxxx;Port=3050;Dialect=3;Charset=NONE;Role=;Connection lifetime=15;Pooling=true;MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0;" FirebirdSql.EntityFrameworkCore.Firebird -OutputDir Models

.NET Core CSharp Project (.csproj)

<Project Sdk="Microsoft.NET.Sdk.Web">

 <PropertyGroup>
 <TargetFramework>netcoreapp2.1</TargetFramework>
 </PropertyGroup>

 <ItemGroup>
 <PackageReference Include="EntityFrameworkCore.FirebirdSql" Version="2.1.2.2" />
 <PackageReference Include="Microsoft.AspNetCore.App" />
 <PackageReference Include="Microsoft.AspNetCore.Razor.Design" Version="2.1.2" PrivateAssets="All" />
 <PackageReference Include="Microsoft.EntityFrameworkCore" Version="2.1.14" />
 <PackageReference Include="Microsoft.EntityFrameworkCore.Tools" Version="2.1.14">
 <PrivateAssets>all</PrivateAssets>
 <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
 </PackageReference>
 </ItemGroup>

</Project> 

Next with .NET Core 3.1:

  • .NET Core 3.1
  • ASP.NET Core MVC 3.1
  • EF Core 3.1

Next with .NET Core 5.0:

  • .NET Core 5.0
  • ASP.NET Core MVC 5.0
  • EF Core 5.0

References:

https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient

https://github.com/ralmsdeveloper/EntityFrameworkCore.FirebirdSQL (HAY HAY HAY)

https://www.programmersought.com/article/6109272731/ (HAY HAY HAY)

https://hoanguyenit.com/create-database-using-code-first-in-aspnet-core-21.html

https://docs.microsoft.com/en-us/aspnet/core/data/ef-mvc/intro?view=aspnetcore-5.0

http://www.binaryintellect.net/articles/87446533-54b3-41ad-bea9-994091686a55.aspx

https://docs.oracle.com/cd/E17952_01/connector-net-en/connector-net-entityframework-core-example.html