linq2db.SQLite 5.0.0-rc.2

Prefix Reserved

This is a prerelease version of linq2db.SQLite.

There is a newer version of this package available.
See the version list below for details.

Requires NuGet 3.3.0 or higher.

dotnet add package linq2db.SQLite --version 5.0.0-rc.2

NuGet\Install-Package linq2db.SQLite -Version 5.0.0-rc.2

This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.

<PackageReference Include="linq2db.SQLite" Version="5.0.0-rc.2" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

paket add linq2db.SQLite --version 5.0.0-rc.2

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: linq2db.SQLite, 5.0.0-rc.2"

#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.

// Install linq2db.SQLite as a Cake Addin
#addin nuget:?package=linq2db.SQLite&version=5.0.0-rc.2&prerelease

// Install linq2db.SQLite as a Cake Tool
#tool nuget:?package=linq2db.SQLite&version=5.0.0-rc.2&prerelease

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

LINQ to DB

Starting from version 4 we obsolete T4 nugets in favor of new command-line scaffolding tool: linq2db.cli. Consider migration as we don't plan to introduce new features and fixes to T4 functionality.

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

Don't use this package if you don't need database scaffolding functionality. Instead of this package, use:

main linq2db package
database provider nuget (see list of supported providers below)

Supported database providers

MS Access (.NET Core-only)
- System.Data.Odbc for ODBC Access provider
- System.Data.OleDb for OLE DB Access provider
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)

Obsoletion Note

T4 templates obsoleted starting from Linq To DB 4.0.0 and replaced with new scaffolding utility. We still release newer versions of templates to maintain compatibility with new LinqToDB releases but don't actively develop new features for them.

There are multiple reasons for it:

T4 templates doesn't work well outside of Visual Studio. MacOS/Linux users or users of alternate IDEs could face serious issues trying to use T4 templates.
T4 templates executed using .NET Framework by Visual Studio, which also creates issues for non-Windows users.
T4 host use x86 process for Visual Studio 2019- and x64 process for Visual Studio 2022+. This creates issues with native providers as they are platform-dependent (ODBC and OleDb providers, various native ADO.NET providers).
It's very hard to maintain big code generation framework, written in T4 templates.

These are the most significant issues with T4 templates.

There are no supported framework assets in this package.

Learn more about Target Frameworks and .NET Standard.

- linq2db (>= 5.0.0-rc.2)
- System.Data.SQLite.Core (>= 1.0.117)

NuGet packages (4)

Showing the top 4 NuGet packages that depend on linq2db.SQLite:

Package	Downloads
Rockatuestilo.DataRepoMain Package Description	12.6K
Hardcore.Megalog Provides extended logging into local db	6.4K
AsdDotNet.Db.Linq2db.Sqlite AsdFrameworks2	1.8K
AsdDb.Linq2db.Sqlite AsdFrameworks	313

GitHub repositories (1)

Showing the top 1 popular GitHub repositories that depend on linq2db.SQLite:

Repository	Stars
ClosedXML/ClosedXML.Report ClosedXML.Report is a tool for report generation with which you can easily export any data from your .NET classes to Excel using a XLSX-template.	549

Version	Downloads	Last updated
6.0.0-preview.1	144	6/17/2024
5.4.1	11,315	4/7/2024
5.4.0	7,458	2/20/2024
5.3.2	28,076	10/18/2023
5.3.1	261	10/16/2023
5.3.0	828	10/12/2023
5.2.2	9,399	6/8/2023
5.2.1	1,215	5/18/2023
5.2.0	374	5/4/2023
5.1.1	5,268	3/25/2023
5.1.0	1,036	3/16/2023
5.0.0	1,973	2/23/2023
5.0.0-rc.2	106	2/16/2023
5.0.0-rc.1	119	2/9/2023
5.0.0-preview.2	129	2/2/2023
5.0.0-preview.1	137	1/12/2023
4.4.1	1,417	2/2/2023
4.4.0	3,882	12/15/2022
4.3.0	6,276	10/1/2022
4.2.0	1,164	9/1/2022
4.1.1	5,396	7/7/2022
4.1.0	7,787	6/16/2022
4.0.1	1,109	5/27/2022
4.0.0	777	5/19/2022
4.0.0-rc.2	139	5/15/2022
4.0.0-rc.1	147	4/29/2022
4.0.0-preview.10	243	11/15/2021
4.0.0-preview.9	172	11/11/2021
4.0.0-preview.8	235	10/22/2021
4.0.0-preview.7	224	10/14/2021
4.0.0-preview.6	250	10/2/2021
4.0.0-preview.5	235	9/10/2021
4.0.0-preview.4	1,652	8/13/2021
4.0.0-preview.3	230	7/9/2021
4.0.0-preview.2	243	7/1/2021
4.0.0-preview.1	214	6/9/2021
3.7.0	13,181	4/7/2022
3.6.0	6,390	11/15/2021
3.5.2	442	11/11/2021
3.5.1	657	10/22/2021
3.5.0	1,283	10/14/2021
3.4.5	720	10/2/2021
3.4.4	908	9/10/2021
3.4.3	1,371	8/13/2021
3.4.2	4,583	7/9/2021
3.4.1	731	7/1/2021
3.4.0	57,131	6/3/2021
3.3.0	2,284	3/25/2021
3.2.3	40,189	1/4/2021
3.2.2	626	12/26/2020
3.2.1	677	12/17/2020
3.2.0	579	12/17/2020
3.1.6	11,815	10/31/2020
3.1.5	783	10/15/2020
3.1.4	1,522	10/8/2020
3.1.3	1,083	9/17/2020
3.1.2	2,485	9/3/2020
3.1.1	939	8/27/2020
3.1.0	687	8/20/2020
3.0.1	16,819	7/13/2020
3.0.0	715	7/10/2020
3.0.0-rc.2	438	7/5/2020
3.0.0-rc.1	695	6/17/2020
3.0.0-rc.0	355	5/30/2020
3.0.0-preview.2	357	3/28/2020
3.0.0-preview.1	743	10/17/2019
2.9.8	8,414	4/16/2020
2.9.7	1,659	3/5/2020
2.9.6	1,032	1/30/2020
2.9.5	2,861	12/30/2019
2.9.4	7,628	11/12/2019
2.9.3	856	10/30/2019
2.9.2	804	10/17/2019
2.9.1	826	10/3/2019
2.9.0	988	8/8/2019
2.8.1	814	7/29/2019
2.8.0	751	7/25/2019
2.7.4	1,083	6/14/2019
2.7.3	784	6/13/2019
2.7.2	950	6/1/2019
2.7.1	798	5/23/2019
2.7.0	1,035	4/25/2019
2.6.4	3,118	2/2/2019
2.6.3	971	1/20/2019
2.6.2	972	1/3/2019
2.6.1	908	12/21/2018
2.6.0	912	12/14/2018
2.5.4	1,243	11/21/2018
2.5.3	1,116	11/20/2018
2.5.2	1,160	11/12/2018
2.5.1	1,160	11/5/2018
2.5.0	1,148	11/1/2018
2.4.0	1,222	10/4/2018
2.3.0	1,315	8/30/2018
2.2.0	1,273	7/26/2018
2.1.0	1,224	6/21/2018
2.0.0	1,489	5/17/2018
1.10.0	4,895	11/19/2017
1.9.0	2,493	8/30/2017
1.8.3	1,909	7/6/2017
1.8.2	1,457	6/6/2017
1.8.1	1,165	6/4/2017
1.8.0	1,501	5/18/2017
1.7.6	2,123	2/19/2017
1.7.5	1,213	2/7/2017
1.0.7.3	3,756	9/7/2015
1.0.7.2	2,030	8/13/2015
1.0.7	2,578	2/1/2015

https://github.com/linq2db/linq2db/wiki/releases-and-roadmap#release-500-rc2

Total 375.6K

Current version 106

Per day average 88

linq linq2db SQLite LinqToDB ORM database DB SQL