As I said a few days ago, I'm quite impressed by SQLite, but I had to
confirm that I could actually read the thing in an app. Here's what I've
found so far.
ADO.NET -- Good
Using the provider you can code in the usual old-fashioned ADO way and it
just works.
netTiers -- Bad
The CodeSmith template recognised the database, but the list of tables is
empty and running a generation from the UI does nothing and from the command
prompt you get an empty output folder with no messages. I've asked in the
support group if SQLite is supported (you get the impression it is).
Entity Framework 4 -- Bad
You pick from "other database" and SQLite is there and the whole wizard runs
and you get a nice EDMX diagram with all the tables and joins. I was all
excited, but then a tiny bit of test code like this crashes because the
ToArray() call returns an array of 9 null references.
using (FooContext context = new FooContext())
{
Thing[] things = (from t in context.Thing select t).ToArray();
}
If I make a connection and context for a SQL Server database with the same
tables then this works correctly. From SQL I get an array of 9 Thing
objects, from SQLite I get an array of 9 nulls. Anyone been through this
misery before?
Greg
