linq2db.SQLite
6.0.0-preview.1
Prefix Reserved
Requires NuGet 3.3.0 or higher.
dotnet add package linq2db.SQLite --version 6.0.0-preview.1
NuGet\Install-Package linq2db.SQLite -Version 6.0.0-preview.1
<PackageReference Include="linq2db.SQLite" Version="6.0.0-preview.1" />
paket add linq2db.SQLite --version 6.0.0-preview.1
#r "nuget: linq2db.SQLite, 6.0.0-preview.1"
// Install linq2db.SQLite as a Cake Addin #addin nuget:?package=linq2db.SQLite&version=6.0.0-preview.1&prerelease // Install linq2db.SQLite as a Cake Tool #tool nuget:?package=linq2db.SQLite&version=6.0.0-preview.1&prerelease
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
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 SQLiIBM.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
- 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
- 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)
Learn more about Target Frameworks and .NET Standard.
-
- linq2db (>= 6.0.0-preview.1)
- System.Data.SQLite.Core (>= 1.0.118)
NuGet packages (4)
Showing the top 4 NuGet packages that depend on linq2db.SQLite:
Package | Downloads |
---|---|
Rockatuestilo.DataRepoMain
Package Description |
|
Hardcore.Megalog
Provides extended logging into local db |
|
AsdDotNet.Db.Linq2db.Sqlite
AsdFrameworks2 |
|
AsdDb.Linq2db.Sqlite
AsdFrameworks |
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.
|
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 |