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: 347
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