SharpTools / sharpdata

An awesome ORM for querying and modifying databases
MIT License
11 stars 6 forks source link

Data type for SQL Server for DbType.Date #13

Closed beppler closed 5 years ago

beppler commented 6 years ago

On DbTypes x SqlServer is documented that the types generated for DbType.Date is the following:

Based on SQL Server Data Type Mappings the type used for DbType.Date should be:

Only if SQL Server is version 2005 or older, the datetime should be used, but as the DbType.Time is already generating the time datatype I think that compability with SQL Server 2005 is not needed.

beppler commented 6 years ago

I've created a project fork at https://github.com/mpsinfo/sharpdata that contains this update using SQL Server date datatype.

beppler commented 5 years ago

Resolved by #19.