EFCore.ODBC.SqlServer
1.0.1.470
dotnet add package EFCore.ODBC.SqlServer --version 1.0.1.470
NuGet\Install-Package EFCore.ODBC.SqlServer -Version 1.0.1.470
<PackageReference Include="EFCore.ODBC.SqlServer" Version="1.0.1.470" />
<PackageVersion Include="EFCore.ODBC.SqlServer" Version="1.0.1.470" />
<PackageReference Include="EFCore.ODBC.SqlServer" />
paket add EFCore.ODBC.SqlServer --version 1.0.1.470
#r "nuget: EFCore.ODBC.SqlServer, 1.0.1.470"
#:package EFCore.ODBC.SqlServer@1.0.1.470
#addin nuget:?package=EFCore.ODBC.SqlServer&version=1.0.1.470
#tool nuget:?package=EFCore.ODBC.SqlServer&version=1.0.1.470
EFCore.ODBC.SqlServer
A custom EF Core provider that enables ODBC-based access to Microsoft SQL Server.
Useful for cloud environments, DSN-only infrastructure, or platform-specific drivers.
Features
- ✅ Compatible with Entity Framework Core 8 ONLY
- ✅ Uses
System.Data.Odbc
- ✅ Reuses EF Core's SQL Server translation pipeline
- ✅ Supports LINQ, parameters, and raw SQL
Installation
dotnet add package EFCore.ODBC.SqlServer
Notes
OPENJSON is not handled well via odbc, so in some cases it might be causing specific queries to fail. Recommended solution is to change compatibility level to 120 to prevent EF Core from using OPENJSON.
Multiple use of the same parameter passed to query might be causing issues during translations, recommended mitigation is to use contitionally EF.Constant to wrap that variable whenever you're going to use odbc.
This release is only for downgraded version of ODBC to 4.7.0.
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net8.0 is compatible. 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. |
-
net8.0
- Microsoft.EntityFrameworkCore (>= 8.0.15)
- Microsoft.EntityFrameworkCore.Relational (>= 8.0.15)
- Microsoft.EntityFrameworkCore.SqlServer (>= 8.0.15)
- System.Data.Odbc (>= 4.7.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.