Gehtsoft.EF.Db.SqlDb 1.8.5

.NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package Gehtsoft.EF.Db.SqlDb --version 1.8.5                

                    
                

            
NuGet\Install-Package Gehtsoft.EF.Db.SqlDb -Version 1.8.5
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.SqlDb" Version="1.8.5" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add Gehtsoft.EF.Db.SqlDb --version 1.8.5                

                    
                

            
#r "nuget: Gehtsoft.EF.Db.SqlDb, 1.8.5"
#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 Gehtsoft.EF.Db.SqlDb as a Cake Addin
#addin nuget:?package=Gehtsoft.EF.Db.SqlDb&version=1.8.5

// Install Gehtsoft.EF.Db.SqlDb as a Cake Tool
#tool nuget:?package=Gehtsoft.EF.Db.SqlDb&version=1.8.5

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!

Please feel

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. 
.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 (9)

Showing the top 5 NuGet packages that depend on Gehtsoft.EF.Db.SqlDb:

Package Downloads
Gehtsoft.EF.Db.SqliteDb

Gehtsoft Entity Framework: SQLite Driver
Gehtsoft.EF.Db.MysqlDb

Gehtsoft Entity Framework: MySQL/MariaDB Driver
Gehtsoft.EF.Db.PostgresDb

Gehtsoft Entity Framework: Postgres Driver
Gehtsoft.EF.Bson

Gehtsoft Entity Framework: Entity framework BSON serializer
Gehtsoft.EF.Db.SqlDb.OData

Gehtsoft Entity Framework: Utilities: OData support.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.8.8 566 10/3/2023
1.8.7 961 4/11/2023
1.8.6 1,302 3/7/2023
1.8.5 1,887 12/21/2022
1.8.4 1,667 11/22/2022

- Fix entity query when optional dependent entity has non-optional dependent entity.