What is involved in switching a project from Sql Server LocalDB to SQLite
user45757 Published in September 19, 2018, 9:08 am
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?
.net sqlite localdb
share|improve this question
edited Apr 17 at 14:01
asked Apr 17 at 11:21
Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.
Browse other questions tagged .net sqlite localdb or ask your own question.