I am working on an MVC 3 application in C# that is having trouble updating an entry in the table.The update string that is being called from EF is sending in the date as such (all other values in the where statement have been removed for clarity):\[code\]where [CreateDate] = '2012-09-24 19:12:08'\[/code\]The actual database entry has the date and the sql data type is datetime2(7):\[code\]2012-09-24 19:12:08.6457698\[/code\]When the code is executed the dates don't match and nothing is updated. I created my models using Reverse Engineering Code First from existing database. Here is my Model:\[code\]public class NPost{ [HiddenInput(DisplayValue = http://stackoverflow.com/questions/12587843/false)] public int NPostID { get; set; } [HiddenInput(DisplayValue = false)] public System.Guid UserId { get; set; } [Required(ErrorMessage ="Please enter a title!")] [StringLength(Int32.MaxValue)] public string Title { get; set; } [AllowHtml] [Required(ErrorMessage = "Please enter the body of the post!")] [StringLength(Int32.MaxValue)] public string Body { get; set; } [Required(ErrorMessage = "Please enter at least one tag!")] [StringLength(Int32.MaxValue)] public string Tags { get; set; } public System.DateTime CreateDate { get; set; } public Nullable<System.DateTime> PublishDate { get; set; } public Nullable<double> Rating { get; set; } [Required(ErrorMessage = "Please enter a topic!")] [StringLength(Int32.MaxValue)] public string Topic { get; set; } [StringLength(Int32.MaxValue)] public string TitleImage { get; set; } [StringLength(Int32.MaxValue)] public string ListingImage { get; set; } [StringLength(Int32.MaxValue)] public string BoxImage { get; set; } public virtual aspnet_Users aspnet_Users { get; set; }}\[/code\]What do I need to do to get these dates to line up and work correctly?