Telerik Forums RSShttp://www.telerik.com/urn:uuid:6534d30c-6d5b-446e-aa41-0c7e3da2eedchttp://www.telerik.com/forums/permalink/DNM0ZVttbkSqQQx-PaLu3ASQLite and DateTimeHi Craig,<br />
<br />
yes, SQLite is a bit special with data types. However, it seems that you are using a decimal? field to hold the content of a column of DATE sql type. Can you double-check this, and correct that to DateTime? .<br />
I just verified locally that using the latest version it is possible to map DATE&lt;-&gt;DateTime? .<br />
<br />
Regards,<br />
Thomas <br />
Telerik
<div class="forumBaloonTop"></div>
<div class="forumBaloon">OpenAccess ORM Q2 2013 brings you a more powerful code generation and a unique Bulk Operations support with LINQ syntax. <span style="color: #e64b00;">Check out the list of <a href="http://www.telerik.com/products/orm/whats-new.aspx">new functionality and improvements</a> shipped with this release.</span> </div>
<div class="forumBaloonBottom"></div>urn:uuid:39ddc489-bc35-4450-9837-0aea69a716a5http://www.telerik.com/forums/permalink/icTdOTW8UESYNwrqaacWpQSQLite and DateTimeI have read about SQLite and how there are issues handling DateTime with Telerik OA ORM.&nbsp;<br>
<br>
I am getting the following exception when I try to access a table that has a DateTime CLR type that is mapped to a datetime field in SQLite.<br>
<br>
Type converter initialization failed. The converter with name 'Timestamp2DateTimeConverterNoTimeSpan' does not convert from CLR type 'System.Nullable`1[[System.Decimal, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]' to SQL type 'date'.<br>
<br>
I have tried changing the connection string to include DateTimeFormat=ISO8601 parameter, but that doesn;t seem to make any difference. Is there any specific tips you can give me to get this to work?<br>
<br>
Thanks in advance<br>
Craig