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, How do we force the LS Designer to create datetime2 fields? I have the model set up as 2008 or 2012 and the only option I have it DateTime. So when the model is auto created it is created as datetime - so our code fails when we send DateTime.Min as LS does convert this to a datetime2 Running a nightly build from around a week ago. Cheers, Sean |
|
|
|
|
Hi Sean, You will need to define/update the schema manually Im afraid. We convert the datatype to datetime2 when preparing a query if the value is out of range of a normal SQL datetime and you are using the 2008/2012 provider.
|
|
|
|
