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

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?

share|improve this question
  • Have you investigated what is currently the reason for the performance issues? I'd say it's quite difficult for anyone to give tips without knowing where the problem is – James Z Apr 17 at 14:02
  • Hiya James, thank you. I haven't yet. The work is in progress and I may not experience performance issues. I am research if I need to preempt a change early. Perhaps, I should wait and solve the problem if it arrises. My biggest point of processing will be calculating moving averages, bollenger bands and various indicators on price/timeseries data. Typically, 250milliseconds apart over 24 hours. (Its a sports trading app) I figured I probably should be exploring database alternatives before getting really deep into the project then finding out I have to change a whole bunch of things. – Obbles Apr 18 at 1:37
  • Just run all your tests and see what breaks. (You have a bunch of automatic tests, haven't you?) – CL. Apr 18 at 7:10
  • I have tests in place. Fairly rudamentary though. I'm to some degree a noob. It sounds like I'll have to just go and do it and see what happens :) So that's what I'll do. Thank you. – Obbles Apr 18 at 23:32

active oldest votes

Your Answer

StackExchange.ifUsing("editor", function () { StackExchange.using("externalEditor", function () { StackExchange.using("snippets", function () { StackExchange.snippets.init(); }); }); }, "code-snippets"); StackExchange.ready(function() { var channelOptions = { tags: "".split(" "), id: "1" }; initTagRenderer("".split(" "), "".split(" "), channelOptions); StackExchange.using("externalEditor", function() { // Have to fire editor after snippets, if snippets enabled if (StackExchange.settings.snippets.snippetsEnabled) { StackExchange.using("snippets", function() { createEditor(); }); } else { createEditor(); } }); function createEditor() { StackExchange.prepareEditor({ heartbeatType: 'answer', convertImagesToLinks: true, noModals: false, showLowRepImageUploadWarning: true, reputationToPostImages: 10, bindNavPrevention: true, postfix: "", onDemand: true, discardSelector: ".discard-answer" ,immediatelyShowMarkdownHelp:true }); } });
StackExchange.ready( function () { StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f49876749%2fwhat-is-involved-in-switching-a-project-from-sql-server-localdb-to-sqlite%23new-answer', 'question_page'); } );

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged .net sqlite localdb or ask your own question.

StackExchange.ready(function () { StackExchange.responsiveness.addSwitcher(); }) (function(i, s, o, g, r, a, m) { i['GoogleAnalyticsObject'] = r; i[r] = i[r] || function() { (i[r].q = i[r].q || []).push(arguments) }, i[r].l = 1 * new Date(); a = s.createElement(o), m = s.getElementsByTagName(o)[0]; a.async = 1; a.src = g; m.parentNode.insertBefore(a, m); })(window, document, 'script', 'https://www.google-analytics.com/analytics.js', 'ga'); StackExchange.ready(function () { StackExchange.ga.init({ sendTitles: true, tracker: window.ga, trackingCodes: [ 'UA-108242619-1' ] }); StackExchange.ga.setDimension('dimension2', '|.net|sqlite|localdb|'); StackExchange.ga.setDimension('dimension3', 'Questions/Show'); StackExchange.ga.trackPageView(); }); /**/ var _qevents = _qevents || [], _comscore = _comscore || []; (function() { var ssl = 'https:' == document.location.protocol, s = document.getElementsByTagName('script')[0], qc = document.createElement('script'); qc.async = true; qc.src = (ssl ? 'https://secure' : 'http://edge') + '.quantserve.com/quant.js'; s.parentNode.insertBefore(qc, s); _qevents.push({ qacct: "p-c1rF4kxgLUzNc" }); /**/ var sc = document.createElement('script'); sc.async = true; sc.src = (ssl ? 'https://sb' : 'http://b') + '.scorecardresearch.com/beacon.js'; s.parentNode.insertBefore(sc, s); _comscore.push({ c1: "2", c2: "17440561" }); })();
You need to login account before you can post.

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

© 2016 Powered by mzan.com design MATCHINFO