Improve the Microsoft.EntityFrameworkCore.Sqlite EF Core database provider

[ajcvickers]

This is a grouping of related issues. Feel free to vote (👍) for this issue to indicate that this is an area that you think we should spend time on, but consider also voting for individual issues for things you consider especially important.

---

This an "epic" issue for the theme of improving the EF Core provider for SQLIte. Specific pieces of work will be tracked by linked issues.

Done in 6.0

• Sqlite Support translation of ToString #17223
• SQLite: Translate Regex.IsMatch() #18845
• Add EF.Functions.Random() #16141

Done in 7.0

• Map JSON values stored in database to EF properties #4021
• SQLite SaveChanges: Use RETURNING clause #24835

Backlog

• Upgrade to SpatiaLite 5 #22138
• SQLite: Translate TimeSpan members #18844
• SQLite: Translate more DateOnly and TimeOnly members #25103
• SQLite full-text search support #4823
• SQLite: Enable Decimal #19635
• Optimistic Offline Lock #2195
• HiLo Id generation for Sqlite #20750
• SQLite RevEng: Reverse engineer index filters #8800
• SQLite RevEng: Reverse engineer constraint names #8802
• SQLite RevEng: Sample data to determine CLR type #8824
• SQLite: Make AUTOINCREMENT more first-class #10228
• Sqlite Spatial RevEng: Column SRID and Dimension not configured #13765
• Sqlite Spatial RevEng: Ignore empty string column default #13766
• Improve the experience for using SQLite in-memory databases #16103
• SQLite: Translate more Math members #18843
• SQLite - Can't insert null into TIMESTAMP column #20475
• Sqlite create user defined function in model. #21253
• Drop/create SQLite columns when changing column type to something not convertible #22598
• Support specifying catalog for table mapping #4019
• Support database window functions #12747
• Sqlite RevEng: Scaffold CHECK constraints #23142
• Sqlite: Cast from char to int gives incorrect results #23161
• Clean up date and time formats

[nolanblew]

Any update on the progress of this?

[ErikEJ]

This? This is an umbrella epic for multiple issues.

[luoyunchong]

Any update on UseSpatiaLite?