Gehtsoft.EF.Db.SqliteDb 1.9.2

.NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher. 
dotnet add package Gehtsoft.EF.Db.SqliteDb --version 1.9.2
                    


                    

                
NuGet\Install-Package Gehtsoft.EF.Db.SqliteDb -Version 1.9.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="Gehtsoft.EF.Db.SqliteDb" Version="1.9.2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="Gehtsoft.EF.Db.SqliteDb" Version="1.9.2" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="Gehtsoft.EF.Db.SqliteDb" />
                    


                            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 Gehtsoft.EF.Db.SqliteDb --version 1.9.2
                    


                    

                
#r "nuget: Gehtsoft.EF.Db.SqliteDb, 1.9.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. 
#:package Gehtsoft.EF.Db.SqliteDb@1.9.2
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=Gehtsoft.EF.Db.SqliteDb&version=1.9.2
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=Gehtsoft.EF.Db.SqliteDb&version=1.9.2
                    


                            Install as a Cake Tool

Why?

Why anyone would bother having yet another Entity Framework when there are one in .NET?

Well...

In short... if you ever tried to:

  • Create DB-agnostic application in Microsoft EF Core...
  • Implement domain-driven design with multiple isolated contexts but pointed to the same database instance
  • And then make the DB update process also DB agnostic
  • And had to spend hours optimizing LINQ created by yet another guy who doesn't understand what is behind LINQ in RDMBS...
  • Yet again update your code because Microsoft decided to drop half of functionality and rename another half in the new version.

Then you may got the idea why... We switched to our own solution back in 2015 and never ever looked back because:

  • The framework is 100% pure code-first framework and does NOT require any kind of dependency between the project and the certain database instance. This helps to run the project in distributed environment and even let different developers use different database (not instances, but literally database engines, e.g. Postgres and SQLite) while working on the same project. This also lets use SQLite for running unittests instead of mocking DAO behavior that saves time to develop unit tests and improves the coverage.
  • The framework is 100% database-agnostic and domain-driven-design focused. Create as many context as you need, mix and match them. Use the database driver that matches you needs the best - from in-memory SQLite for automated tests to Oracle for production. And let the framework to take care of all the nuances.
  • While framework supports LINQ, it is heavily oriented to be used without LINQ. The reason is that LINQ is not 100% compatible with SQL select query structure and therefore the LINQ queries compiled into SQL SELECT queries are far from optimal. Gehtsoft.EF framework generates selects which are almost as good as written manually. Unfortunately, due to reason above, LINQ-produced queries are as bad as for any other LINQ-based framework.
  • It is lighter and do not consists of needless dependencies. Actually, for the most queries it is as fast as it would be running these queries directly to the database without EF at all.
  • It allows to use plain and raw SQL. Moreover, it allows to use SQL constructors which creates database-specific SQL SELECTs on the fly.
  • Last but not not least - it is open source. Understand how it works, make it better, make it custom!

Packages

Core

Package Designation Links
Gehtsoft.EF.Db.Sql Main Entity Framework Package Gehtsoft feed, nuget
Gehtsoft.EF.Entities Entities Definition (use this package if only entities definition is needed) Gehtsoft feed, nuget
Gehtsoft.EF.Utils Various tools (you don't need to install it, it will be installed automatically) Gehtsoft feed, nuget
Gehtsoft.EF.Bson BSON support (will be installed automatically if MongoDB driver is used) Gehtsoft feed, nuget

Utils

Package Designation Links
Gehtsoft.EF.FTS Tools to create a full-text-search in your project Gehtsoft feed, nuget
Gehtsoft.EF.Db.SqlDb.OData OData support Gehtsoft feed, nuget
Gehtsoft.EF.Db.SqlDb.Sql Platform-agnostic SQL 92 parser & executor Gehtsoft feed, nuget

Driver

Package Designation Links
Gehtsoft.EF.Db.Sql.MssqlDb Driver for Microsoft SQL Server Gehtsoft feed, nuget
Gehtsoft.EF.Db.Sql.MysqlDb Driver for MySQL/MariaDB Gehtsoft feed, nuget
Gehtsoft.EF.Db.Sql.OracleDb Driver for Oracle Gehtsoft feed, nuget
Gehtsoft.EF.Db.Sql.PostgresDb Driver for Postgres Gehtsoft feed, nuget
Gehtsoft.EF.Db.Sql.SqliteDb Driver for Sqlite Gehtsoft feed, nuget
Gehtsoft.EF.Db.MongoDB Driver for MongoDB Gehtsoft feed, nuget

See also

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
1.9.2 0 9/18/2025
1.8.8 230 10/3/2023
1.8.7 355 4/11/2023
1.8.6 335 3/7/2023
1.8.5 453 12/21/2022
1.8.4 456 11/20/2022

- dependencies updated