Hello,
I've recently started using System.Data.SQLite (v1.0.65.0) and already like it very much :-). I've encountered two issues though, of which I'm wondering whether I'm doing something wrong or that they are bugs in the designer:
-
When I create a TableAdapter for table x using the designer and the table contains nullable fields, the TableAdapter uses a default 'Throw Exception' for field 'NullValue'. Is there a way to change the default of this value (so when I create a new TableAdapter, this fields is automatically set to 'Null') ?
-
When I have a nullable DateTime field in my table, it can never return null (NullValue seems to be fixed to 'Throw Exception' for this type. Changing the value results in an error by the Designer (Property value is not valid). Is this a limitation by C#, since DateTime is a struct ?
Hopefully someone can help me with these questions...
Regard,
Martijn