EF - Backend vs .NET Datatypes
Here's a list of what datatypes that Entity Framework uses to store .NET datatypes in a couple different database engines.
| .NET Datatype | SQL Server | PostgreSQL | SQLite | Comments |
| bool | bit | boolean | INTEGER | |
| byte | tinyint |
smallint (Postgres lack tinyint) |
INTEGER | |
| short | smallint | smallint | INTEGER | |
| int (32-bit) | int | integer | INTEGER | |
| long (64-bit) | bigint | bigint | INTEGER | |
| ||||
| decimal | decimal(18,2) |
numeric(18,2) Adjustable for domain |
REAL | |
| float | real | real | REAL | |
| Guid | uniqueidentifier | uuid | TEXT | |
| string | nvarchar(max) | text | TEXT | |
| char | nchar(1) | char(1) | TEXT | |
| byte[] | varbinary(max) | bytea | BLOB | |
TEXT Use ISO-8601 text for SQLite |
||||
| DateTimeOffset | datetimeoffset | timestamp with time zone | TEXT | |
| TimeSpan | time | interval | TEXT | |
|
JsonDocument / Dictionary<string, object> |
nvarchar(max) SQL Server has no native JSON type; EF stores as text. |
jsonb Native JSON support |
TEXT | |
| object |
sql_variant Only if configured manually |
|||
|
|
|