This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, I have a SQLite database where one of my table have a column of type boolean. We also know that SQLite doen't support boolean datatype but there is an affinity type where 'boolean' is automatically transform in 'numeric'; one of the 4 types supported by SQLite. (http://www.sqlite.org/datatype3.html) The problem is when I try to update my model from source (Database first approach), the engine of LightSpeed always try to change the type of the properties linked with the column from 'System.Boolean' to 'System.Object'. My question is: What kind of type in SQLite database column should I use so that when I try to update my model from source, LightSpeed to recognize that type 'Boolean'.? Thanks for the support. |
|
|
|
|
Use the BIT data type. |
|
|
|
