Set decimal(16, 3) for a column in Code First Approach in EF4.3

151 阅读1分钟

private decimal _SnachCount; [Required] [DataType("decimal(16 ,3")] public decimal SnachCount { get { return _SnachCount; } set { _SnachCount = value; } }

private decimal _MinimumStock; [Required] [DataType("decimal(16 ,3")] public decimal MinimumStock { get { return _MinimumStock; } set { _MinimumStock = value; } }

private decimal _MaximumStock; [Required] [DataType("decimal(16 ,3")] public decimal MaximumStock { get { return _MaximumStock; } set { _MaximumStock = value; } }

The DataType Attribute is a Validation Attribute. You need to do that using the ModelBuilder.

public class MyContext : DbContext { public DbSet MyClass; protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.Entity().Property(x => x.SnachCount).HasPrecision(16, 3); modelBuilder.Entity().Property(x => x.MinimumStock).HasPrecision(16, 3); modelBuilder.Entity().Property(x => x.MaximumStock).HasPrecision(16, 3); } }