LINQ to DB

Also check command-line scaffolding tool: linq2db.cli.

This nuget package contains database scaffolding T4 templates to generate POCO classes from your database.

You can read about T4 templates options here. Demonstration video could be found here.

Important

This package includes only scaffolding functionality. Additionally you will need to reference:

1. main linq2db package
2. database provider nuget (see list of supported providers below) or assembly

Supported database providers

• MS Access (.NET Core-only)
  • System.Data.Odbc for ODBC Access provider
  • System.Data.OleDb for OLE DB Access provider
• ClickHouse
  • ClickHouse.Driver for use with HTTP protocol (recommended provider)
  • MySqlConnector for use with MySql protocol
  • Octonica.ClickHouseClient for use with binary protocol (we wouldn't recommend it as it displays several times worse performance in our tests)
• DB2 LUW and Informix
  • IBM.Data.DB.Provider: .NET Framework provider
  • IBM.Data.DB2.Core: .NET Core Windows provider
  • IBM.Data.DB2.Core-lnx: .NET Core Linux provider
  • IBM.Data.DB2.Core-osx: .NET Core MacOS provider
  • Net5.IBM.Data.Db2: .NET 5+ Windows provider
  • Net5.IBM.Data.Db2-lnx: .NET 5+ Linux provider
  • Net5.IBM.Data.Db2-osx: .NET 5+ MacOS provider
  • Net.IBM.Data.Db2: .NET 6+ Windows provider
  • Net.IBM.Data.Db2-lnx: .NET 6+ Linux provider
  • Net.IBM.Data.Db2-osx: .NET 6+ MacOS provider
  • for Informix you can also use legacy ODS or SQLi IBM.Data.Informix providers, but we don't recommend it
• DB2 iSeries
  • linq2db4iSeries: Don't reference linq2db package explicitly. This package already references supported linq2db version
• Firebird
  • FirebirdSql.Data.FirebirdClient
• MySQL
  • MySqlConnector (recommended)
  • MySql.Data (highly discouraged, low quality provider)
• MariaDB
  • MySqlConnector (recommended)
• Oracle
  • Oracle.ManagedDataAccess (.NET Framework)
  • Oracle.ManagedDataAccess.Core (.NET Core)
  • also native legacy ODP.NET provider supported, but not recommended
• PostgreSQL
  • Npgsql
• SAP HANA 2
  • System.Data.Odbc for ODBC provider
  • also native ADO.NET provider could be used (Windows-only)
• SQL Server Compact Edition
  • System.Data.SqlServerCe provider
• SQLite
  • System.Data.SQLite.Core (recommended as it use most recent SQLite engine and provides access to SQLite functions)
  • Microsoft.Data.Sqlite
• SQL Server
  • Microsoft.Data.SqlClient (recommended)
  • System.Data.SqlClient (legacy)
• SAP/Sybase ASE
  • AdoNetCore.AseClient (recommended)
  • Sybase.AdoNet45.AseClient native provider (not recommended, low quality provider)