I am considering converting a project that currently uses Sql Server LocalDB over to SQLite. (My goal is performance improvements).
I am using Entity Framework 6 and codefirst migrations. The project is a personal, WPF, .Net 4.52, single computer, single user trading application of which I have full control over. I do not need to keep or retain any existing databases. That is, in switching, I can trash any old databases.
On the surface of things from my noobie perspective it looks quiet simple. Just implement the system.data.sqlite package from nuget. Modify the connection strings. Allow the migrations to create the new database. And boo yah...
My question is, What are the differences I am likely to encounter?
For example, Is any of my LINQ code going to need to be changed? Am I going to encounter difficulties with different data types? What other difficulties might I face?