[MonoTouch] Simple sqlite-net question

[Guido Van Hoecke]

Hi,

I am happily using sqlite-net http://code.google.com/p/sqlite-net/ but
need some help with the simple task to retrieve the count of records in
a particular table.

Here's what I do:

        var list = Db.Con.Query<int>("select count(*) from mytable");
        return list[0];

When I issue this select at the sqlite3 prompt, it returns the correct
nr of rows. Unfortunately sqlite-net always returns 0.

Any ideas?

Thanks in advance,



Guido
_______________________________________________
MonoTouch mailing list
MonoTouch@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/monotouch