Home About Eric Topics SourceGear

From .NET + SQL Server to SQLite on Mobile

This is a series of articles about using SQLite when developing mobile apps. The target audience is folks who are coming from the world of SQL Server and .NET.

Table of Contents

Friday, 18 April 2014


SQLite has no distinction between CHAR and NCHAR. Everything is Unicode.

Tuesday, 8 April 2014

Data Types

At the SQL language level, the biggest difference with SQLite is the way it deals with data types.

Friday, 14 March 2014

Foreign Keys

SQLite has excellent support for foreign keys, including the ability to defer them until commit time, which I wish that SQL Server could do.

Friday, 7 March 2014


SQL Server treats NULL as a value. SQLite treats it as the absence of a value.

Wednesday, 26 February 2014

Issues with sync and constraints

In a replicate-and-sync app, it would be really nice if the SQLite database on the mobile device had exactly the same constraints as the SQL Server database on the backend.

Friday, 21 February 2014

EF6 on Xamarin: Progress (or lack thereof)

Er, see Entity Framework Core

Thursday, 20 February 2014


In a number of ways, you can tell that SQLite was not originally written specifically for Windows folks.

Monday, 17 February 2014


A big distinction between SQL Server and SQLite is visible in the fact that only one of them has the word 'server' in its name.

Sunday, 16 February 2014


Microsoft apparently considers SQLite to be the replacement for SQL Server Compact.

Stuff not written yet