dotnet / dotnet/EntityFramework.Docs

EF Core maps DateTime type to TEXT in SQLite

Open
#3,080 14 comments 0 reactions 0 assignees View on GitHub
area-sqlite
Dominant language
Mermaid
Stars
1.7k
Forks
2k
Avg merge
7d 23h
Merged PRs (30d)
16

Description

This may be considered one more limitation, but it may not. Nevertheless, it's good to document that the provider available in the Nuget package Microsoft.EntityFrameworkCore.SQLite, Version 5.0.1 maps C# DateTime objects to TEXT in SQLite. How this design caught me off my feet is documented [here](https://sgurukrupa.wordpress.com/2021/02/04/ef-core-maps-c-datetime-type-to-text-in-sqlite/).

---
#### Document Details

⚠ *Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.*

* ID: dbc4d900-28a8-9c04-2443-7407f15a684f
* Version Independent ID: 545bb0b5-f15b-584e-cef7-7283a0e0729f
* Content: [SQLite Database Provider - Limitations - EF Core](https://docs.microsoft.com/en-us/ef/core/providers/sqlite/limitations)
* Content Source: [entity-framework/core/providers/sqlite/limitations.md](https://github.com/dotnet/EntityFramework.Docs/blob/master/entity-framework/core/providers/sqlite/limitations.md)
* Product: **entity-framework**
* Technology: **entity-framework-core**
* GitHub Login: @bricelam
* Microsoft Alias: **avickers**

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.