Home What is involved in switching a project from Sql Server LocalDB to SQLite
Reply: 0

What is involved in switching a project from Sql Server LocalDB to SQLite

user930
1#
user930 Published in July 21, 2018, 4:06 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?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.309756 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO