Entity Framework DDL Generation Template for MSSQL2008 should take Precision into consideration when choosing DB Column Data Type for DateTime properties - by Anders

Status : 

  Deferred<br /><br />
		The product team has reviewed this issue and has deferred it for consideration at a later time.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


3
0
Sign in
to vote
ID 705630 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 11/18/2011 5:45:57 AM
Access Restriction Public
Moderator Decision Sent to Engineering Team for consideration

Description

When creating an Entity Framework 4 Model in the VS2010 designer (Model First), having SQL Server 2008 as provider, the DATETIME2 data type should be used when specifying a DateTime property with a precision that requires higher granularity in the correspoding DB column.
Sign in to post a comment.
Posted by Microsoft on 10/23/2012 at 2:45 PM
Hello,
Thank you for taking the time to provide feedback. We addressed a lot of connect suggestions in our last release, but we weren’t able to address them all. We have copied this issue to our backlog and will consider it for a future release. You can view this suggestion on our public backlog – http://entityframework.codeplex.com/workitem/list/basic?keywords=DevDiv%20[Id=321623].
~Entity Framework Team
Posted by Microsoft on 4/23/2012 at 8:57 PM
Hello Anders,

Thanks a lot for taking the time to raise this issue. We agree that changing the default column type for DateTime properties to DATETIME2 would be an improvement. However we have decided not to implement this suggestion in this release.

We will keep this work item active for future versions.

Thanks,
Entity Framework Team
Posted by Microsoft on 4/23/2012 at 8:56 PM
Hello Anders,

Thanks a lot for taking the time to raise this issue. We agree that changing the default column type for DateTime properties to DATETIME2 would be an improvement. However we have decided not to implement this suggestion in this release.

We will keep this work item active for future versions.

Thanks,
Entity Framework Team
Posted by MS-Moderator10 [Feedback Moderator] on 11/20/2011 at 11:54 PM
Thank you for submitting feedback on Visual Studio 2010 and .NET Framework. Your issue has been routed to the appropriate VS development team for investigation. We will contact you if we require any additional information.
Posted by MS-Moderator01 on 11/18/2011 at 6:48 AM
Thank you for your feedback, we are currently reviewing the issue you have submitted. If this issue is urgent, please contact support directly(http://support.microsoft.com)