linq2db.SQLite 6.0.0-preview.2

Prefix Reserved

This is a prerelease version of linq2db.SQLite.

There is a newer prerelease 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 6.0.0-preview.2

NuGet\Install-Package linq2db.SQLite -Version 6.0.0-preview.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="6.0.0-preview.2" />

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

<PackageVersion Include="linq2db.SQLite" Version="6.0.0-preview.2" />
                    

                            Directory.Packages.props

<PackageReference Include="linq2db.SQLite" />
                    

                            Project file

For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.

paket add linq2db.SQLite --version 6.0.0-preview.2

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

#r "nuget: linq2db.SQLite, 6.0.0-preview.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.

#addin nuget:?package=linq2db.SQLite&version=6.0.0-preview.2&prerelease
                    

                            Install linq2db.SQLite as a Cake Addin

#tool nuget:?package=linq2db.SQLite&version=6.0.0-preview.2&prerelease
                    

                            Install linq2db.SQLite as a Cake Tool

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

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:

main linq2db package
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.Client 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)

There are no supported framework assets in this package.

Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

NuGet packages (3)

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

Package	Downloads
Hardcore.Megalog Provides extended logging into local db	7.1K
AsdDotNet.Db.Linq2db.Sqlite AsdFrameworks2	2.8K
AsdDb.Linq2db.Sqlite AsdFrameworks	348

GitHub repositories (2)

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

Repository	Stars
linq2db/linq2db Linq to database provider.	3.1K
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.	576

Version	Downloads	Last updated
6.0.0-preview.4	112	a month ago
6.0.0-preview.3	151	3 months ago
6.0.0-preview.2	69	3 months ago
6.0.0-preview.1	922	6/17/2024
5.4.1	28,411	4/7/2024
5.4.0	7,563	2/20/2024
5.3.2	33,475	10/18/2023
5.3.1	272	10/16/2023
5.3.0	842	10/12/2023
5.2.2	9,677	6/8/2023
5.2.1	1,254	5/18/2023
5.2.0	431	5/4/2023
5.1.1	5,327	3/25/2023
5.1.0	1,072	3/16/2023
5.0.0	2,032	2/23/2023
5.0.0-rc.2	123	2/16/2023
5.0.0-rc.1	136	2/9/2023
5.0.0-preview.2	148	2/2/2023
5.0.0-preview.1	159	1/12/2023
4.4.1	1,479	2/2/2023
4.4.0	4,150	12/15/2022
4.3.0	6,433	10/1/2022
4.2.0	1,195	9/1/2022
4.1.1	5,436	7/7/2022
4.1.0	8,233	6/16/2022
4.0.1	1,143	5/27/2022
4.0.0	814	5/19/2022
4.0.0-rc.2	161	5/15/2022
4.0.0-rc.1	170	4/29/2022
4.0.0-preview.10	272	11/15/2021
4.0.0-preview.9	199	11/11/2021
4.0.0-preview.8	262	10/22/2021
4.0.0-preview.7	253	10/14/2021
4.0.0-preview.6	277	10/2/2021
4.0.0-preview.5	261	9/10/2021
4.0.0-preview.4	1,678	8/13/2021
4.0.0-preview.3	259	7/9/2021
4.0.0-preview.2	269	7/1/2021
4.0.0-preview.1	244	6/9/2021
3.7.0	13,470	4/7/2022
3.6.0	6,512	11/15/2021
3.5.2	474	11/11/2021
3.5.1	692	10/22/2021
3.5.0	1,428	10/14/2021
3.4.5	761	10/2/2021
3.4.4	984	9/10/2021
3.4.3	1,411	8/13/2021
3.4.2	4,617	7/9/2021
3.4.1	764	7/1/2021
3.4.0	57,177	6/3/2021
3.3.0	2,589	3/25/2021
3.2.3	40,362	1/4/2021
3.2.2	673	12/26/2020
3.2.1	718	12/17/2020
3.2.0	620	12/17/2020
3.1.6	12,216	10/31/2020
3.1.5	833	10/15/2020
3.1.4	1,576	10/8/2020
3.1.3	1,134	9/17/2020
3.1.2	2,566	9/3/2020
3.1.1	982	8/27/2020
3.1.0	728	8/20/2020
3.0.1	16,903	7/13/2020
3.0.0	757	7/10/2020
3.0.0-rc.2	476	7/5/2020
3.0.0-rc.1	732	6/17/2020
3.0.0-rc.0	396	5/30/2020
3.0.0-preview.2	398	3/28/2020
3.0.0-preview.1	788	10/17/2019
2.9.8	8,471	4/16/2020
2.9.7	1,706	3/5/2020
2.9.6	1,083	1/30/2020
2.9.5	2,915	12/30/2019
2.9.4	7,674	11/12/2019
2.9.3	901	10/30/2019
2.9.2	849	10/17/2019
2.9.1	871	10/3/2019
2.9.0	1,040	8/8/2019
2.8.1	861	7/29/2019
2.8.0	798	7/25/2019
2.7.4	1,135	6/14/2019
2.7.3	831	6/13/2019
2.7.2	999	6/1/2019
2.7.1	845	5/23/2019
2.7.0	1,086	4/25/2019
2.6.4	3,182	2/2/2019
2.6.3	1,021	1/20/2019
2.6.2	1,023	1/3/2019
2.6.1	959	12/21/2018
2.6.0	961	12/14/2018
2.5.4	1,328	11/21/2018
2.5.3	1,206	11/20/2018
2.5.2	1,255	11/12/2018
2.5.1	1,254	11/5/2018
2.5.0	1,237	11/1/2018
2.4.0	1,315	10/4/2018
2.3.0	1,415	8/30/2018
2.2.0	1,371	7/26/2018
2.1.0	1,318	6/21/2018
2.0.0	1,634	5/17/2018
1.10.0	5,015	11/19/2017
1.9.0	2,603	8/30/2017
1.8.3	2,192	7/6/2017
1.8.2	1,560	6/6/2017
1.8.1	1,268	6/4/2017
1.8.0	1,607	5/18/2017
1.7.6	2,228	2/19/2017
1.7.5	1,319	2/7/2017
1.0.7.3	3,871	9/7/2015
1.0.7.2	2,199	8/13/2015
1.0.7	2,704	2/1/2015

https://github.com/linq2db/linq2db/wiki/releases-and-roadmap#release-600-preview2

Total 410.6K

Current version 69

Per day average 93

Sqlite T4 datamodel linq linq2db LinqToDB ORM database DB SQL