CODEWITHSUNDEEP
c#entity-frameworksqliteado.net
Allan Xu
Allan Xu

Reputation: 9368

How stable is System.Data.SQLite

I am about to consider using SQLite in my .NET application. I am experienced with SQL Server, EF and ADO.NET; however, I have not knowledge of SQLite.

While I can learn SQLite in no time, I wanted to consult with the experts here and see how stable is System.Data.SQLite?

Is there any known frustration or issues with SQLite having memory leak issue?

Does it work okay with Entity Framework?

Upvotes: 1

Views: 291

Answers (2)

Connell.O'Donnell
Connell.O'Donnell

Reputation: 3723

In my experience, SQLite works quite well with Entity Framework Core but I've only been using it for code first.

It is under active development as you can see from its NuGet page and its contribution graph on GitHub.

https://www.nuget.org/packages/Microsoft.EntityFrameworkCore.Sqlite/

https://github.com/aspnet/Microsoft.Data.Sqlite/graphs/contributors

For a list of SQLite limitations, see this page at doc.microsoft.com:

https://learn.microsoft.com/en-us/ef/core/providers/sqlite/limitations

Upvotes: 1

ErikEJ
ErikEJ

Reputation: 41819

No issues, it has been around for at least 10 years.

It has basic support for EF6 (no Code First Migrations)

Upvotes: 3

Related Questions