How to fix problems with entity framework decimal precision

The Problem

You are attempting to change a database column of type decimal from a precision of two decimal place to one decimal place via data annotations, and there does not seem to be a good way to do it.

The Cause

There isn’t a good way to do it.

The Solution

However, there is at least one non-elegant way to do it – in your OnModelCreating code in your data context, enter in the following piece of code

protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
modelBuilder.Entity().Property(xx=>xx.Handicap).HasPrecision(12, 1);
base.OnModelCreating(modelBuilder);

}
The “HasPrecision” part is the key – the second parameter is the number of decimal places to use

 

Written By Steve French

 

This entry was posted on Wednesday, December 12th, 2012 at 8:34 pmand is filed under ASP.net MVC, Entity Framework, How To Fix . You can follow any comments to this entry through the RSS 2.0 feed. You can leave a comment, or trackback from your own site.

 

 

Latest Tweets & Social