What happens to date-times and booleans when using DbLinq with SQLite?

Posted by DanM on Stack Overflow See other posts from Stack Overflow or by DanM
Published on 2010-05-03T03:04:11Z Indexed on 2010/05/03 3:08 UTC
Read the original article Hit count: 342

Filed under:
|
|
|

I've been thinking about using SQLite for my next project, but I'm concerned that it seems to lack proper datetime and bit data types.

If I use DbLinq (or some other ORM) to generate C# classes, will the data types of the properties be "dumbed down"? Will date-time data be placed in properties of type string or double? Will boolean data be placed in properties of type int?

If yes, what are the implications? I'm imaging a scenario where I need to write a whole second layer of classes with more specific data types and do a bunch of transformations and casts, but maybe it's not so bad. If you have any experience with this or a similar scenario, what are your "lessons learned"?

© Stack Overflow or respective owner

Related posts about sqlite

Related posts about dblinq