sapiens / SqlFu

Fast and versatile .net core data mapper/micro-orm
Other
229 stars 50 forks source link

SqlServer2012Provider is using DbType 'datetime' instead of 'datetime2' (v3.0) #88

Closed preslavnd closed 8 years ago

preslavnd commented 8 years ago

Is there a particular reason to be using it or an easy way to override this behavior? MSDN doc is recommending using datetime2 over datetime, and we are currently facing an issue where because of this, the precision of the datetime is lowered and we are receiving incorrect results.

sapiens commented 8 years ago

SqlFu uses DateTime2 for values with year < 1753 when updating. But I guess I can make it default.

sapiens commented 8 years ago

ver 3.2.0 solves this issue