Overview
Basics
Operations
Providers
Providers
SQL Server
Installation Requirements
Install the NuGet package Microsoft.EntityFrameworkCore.SqlServer
An example web application is available for this database engine on our GitHub page.
Last tested versions
- 7.0.0
- 6.0.0
Supported Data Types and Operations
See the table below to view supported data types and operations.
Supported Data Types By Version
Version | bool | bool? | byte | byte? | char | char? | double | double? | DateTime | DateTime? | DateTimeOffset | DateTimeOffset? | decimal | decimal? | float | float? | Guid | Guid? | int | int? | long | long? | sbyte | sbyte? | short | short? | Single | Single? | string | string? | TimeSpan | TimeSpan? | UInt16 | UInt16? | UInt32 | UInt32? | UInt64 | UInt64? | UInt128 | UInt128? |
.NET 7 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
.NET 6 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
Information for .NET Standard 2.1, 2.0, 1.3, .NET 4.5, 4.0 and 3.5 Coming Soon!
Supported Operations By Version
Version | Select | Distinct | Sort | Average | Count | Minimum | Maximum | Sum | Null | NotNull | Between | Equal | NotEqual | LessThan | LessThanOrEqual | GreaterThan | GreaterThanOrEqual | InSet | NotInSet | Contains | StartsWith | EndsWith |
.NET 7 | Yes | Yes | Yes | decimal double float int long Single | decimal double float int long Single | decimal double float int long sbyte short Single UInt16 UInt32 UInt64 | decimal double float int long sbyte short Single UInt16 UInt32 UInt64 | decimal double float int long Single | Yes | Yes | byte char DateTime DateTimeOffset decimal double float int long Guid sbyte short Single TimeSpan UInt16 UInt32 UInt64 | Yes | Yes | byte char DateTime DateTimeOffset decimal double float Guid int long sbyte short Single TimeSpan UInt16 UInt32 UInt64 | byte char DateTime DateTimeOffset decimal double float Guid int long sbyte short Single TimeSpan UInt16 UInt32 UInt64 | byte char DateTime DateTimeOffset decimal double float Guid int long sbyte short Single TimeSpan UInt16 UInt32 UInt64 | byte char DateTime DateTimeOffset decimal double float Guid int long sbyte short Single TimeSpan UInt16 UInt32 UInt64 | Yes | Yes | Yes | Yes | Yes |
.NET 6 | Yes | Yes | Yes | decimal double float int long Single | decimal double float int long Single | decimal double float int long sbyte short Single UInt16 UInt32 UInt64 | decimal double float int long sbyte short Single UInt16 UInt32 UInt64 | decimal double float int long Single | Yes | Yes | byte char DateTime DateTimeOffset decimal double float int long sbyte short Single TimeSpan UInt16 UInt32 UInt64 | Yes | Yes | byte char DateTime DateTimeOffset decimal double float int long sbyte short Single TimeSpan UInt16 UInt32 UInt64 | byte char DateTime DateTimeOffset decimal double float int long sbyte short Single TimeSpan UInt16 UInt32 UInt64 | byte char DateTime DateTimeOffset decimal double float int long sbyte short Single TimeSpan UInt16 UInt32 UInt64 | byte char DateTime DateTimeOffset decimal double float int long sbyte short Single TimeSpan UInt16 UInt32 UInt64 | Yes | Yes | Yes | Yes | Yes |
Information for .NET Standard 2.1, 2.0, 1.3, .NET 4.5, 4.0 and 3.5 Coming Soon!