dotnet / dotnet/EntityFramework.Docs
EF Core maps DateTime type to TEXT in 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
Assessment
This issue has not been assessed yet.