Prevent decimal rounding in Entity Framework database first
asp.net-mvc-4, entity-framework
Solution
Should I be modifying the OnModelCreating in the context file - even though it warns changes may be lost on regeneration and how do I keep the code from rounding the decimals?
No - implement a partial class of your context in another file and implement there OnModelCreating
As for the precision - have you checked the values in the objects in the debugger vs. displaying on a page? The rounding may be occurring during rendering.
Try adding the `DisplayFormat` attribute to the property in the entity class:
[DisplayFormat(DataFormatString = "{0:0.0#####}", ApplyFormatInEditMode = true)]
Problem
I am attempting to write/read latitude and longitude to a ms sql database using c#, entity framework - database first, and mvc. The problem is that the lat/long are being shown with only 2 decimal places even though they are correct in the database. The database has the fields as numeric(18,6). I have modified the context file as follows: ``` protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder) { modelBuilder.Entity<STORE_LOCATION>().Property(location => location.LATITUDE).HasPrecision(18, 6); modelBuilder.Entity<STORE_LOCATION>().Property(location => location.LONGITUDE).HasPrecision(18, 6); } ``` 2 Questions - Should I be modifying the OnModelCreating in the context file - even though it warns changes may be lost on regeneration and how do I keep the code from rounding the decimals? Any help appreciated!