Home Dashboard Directory Help
Search

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


Status: 

Closed
 as Deferred Help for as Deferred


3
0
Sign in
to vote
Type: Bug
ID: 705630
Opened: 11/18/2011 5:45:57 AM
Access Restriction: Public
Moderator Decision: Sent to Engineering Team for consideration
0
Workaround(s)
view
1
User(s) can reproduce this bug

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.
Details
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)
Sign in to post a workaround.