Last post Jun 05, 2015 04:44 PM by Mikesdotnetting
Jun 04, 2015 10:33 AM|wavemaster|LINK
There are a some limitations to SQL CE with regards to dealing with local time, making my queries complicated.
I have been made aware of the benefits of SQL Express, however at this time I cannot commit to the extra expense of hosting a SQL Express / or SQL Azure solution.
Looking to converse with someone who is using SQLite with Web Pages.
Jun 04, 2015 02:29 PM|rrrsr7205|LINK
If you are considering SQL Lite as a replacement for SQL CE 4.0 in an existing application using Entity Framework, you are very likely to experience a great amount of grief and extensive rework in trying to do the conversion. There are differences in how
SQL Lite handles a SQL scenario from SQL Server. E.G.,
Most of the SQL CE vs SQL Lite comparisons tend to assume that you are starting from a blank slate and do not have lots of SQL code written usin proprietary functions or using all of the datatypes in the SQL standard (e.g., DATETIME datatype)
Also, if there is a likelihood that your app may require multiple simultaneous writers to the db, SQL-Lite has a limitation of one writer in any one instance of time; all others are locked out (SQL Lite locks the entire database) pending completion of the
current write operation.
You might want to use Erik's tool to create a SQL Lite db from your SQL CE db and then run selected queries against it to compare the results. You will also need to check out whether the limited EF support in SQL Lite will work for any of your EF-based
Jun 04, 2015 02:33 PM|wavemaster|LINK
Yup, I do use EF, so that is a non starter.
Guess I need to find cheaper hosting.
Jun 05, 2015 02:13 AM|Mikesdotnetting|LINK
Probably not much help to you in the short term, but SQLite is one of the platforms that the EF team will be focusing on developing better providers for. They will be looking at this after the RTM of ASP.NET 5.
Jun 05, 2015 10:11 AM|rrrsr7205|LINK
Mike (and Erik, if he is listening):
What is your feeling concerning into the level of effort involved in converting from SQL CE to SQL Lite in an existing app which has nearly a hundred pages with extensive and rather complex SQL queries all throughout? This would include the effort required
to actually convert and also the effort to thoroughly regression test all the legacy code (both SQL and C#).
Jun 05, 2015 10:57 AM|wavemaster|LINK
Apparently there is a need in the market for a single file db solution.
Looks like Microsoft's solution is to kill off SQL CE, and then turnaround and make their stuff work on someone elses db.
Jun 05, 2015 04:41 PM|Mikesdotnetting|LINK
What is your feeling concerning into the level of effort involved in converting from SQL CE to SQL Lite in an existing app which has nearly a hundred pages with extensive and rather complex SQL queries all throughout?
Jun 05, 2015 04:44 PM|Mikesdotnetting|LINK
and make their stuff work on someone elses db.
I don't know why they didn't start by doing that.