Decimal报错:
No store type was specified for the decimal property 'GridElectricityPurchase' on entity type 'ChargeDischarge'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType', specify precision and scale using 'HasPrecision', or configure a value converter using 'HasConversion'.
给报错的属性添加注解
[Column(TypeName = "decimal(18,2)")]
public decimal ChargeCapacity { get; private set; }
这样在进行数据库迁移的时候就不会报错了
1 | 整数 | bit | Boolean | True转换为1False转换为0 |
---|---|---|---|---|
2 | tinyint | Byte | C Sharp 数据类型都位于System命名空间 | |
3 | smallint | Int16 | ||
4 | int | Int32 | ||
5 | bigint | Int64 | ||
6 | smallmoney | Decimal | ||
7 | money | Decimal | ||
8 | numeric | Decimal | ||
9 | decimal | Decimal | ||
10 | 浮点数 | float | Double | |
11 | real | Single | ||
12 | 日期和时间 | smalldatetime | DateTime | |
13 | datetime | DateTime | ||
14 | timestamp | DateTime | ||
15 | 字符串 | char | String | |
16 | text | String | ||
17 | varchar | String | ||
18 | nchar | String | ||
19 | ntext | String | ||
20 | nvarchar | String | ||
21 | 二进制数据 | binary | Byte[] | |
22 | varbinary | Byte[] | ||
23 | image | Byte[] | ||
24 | 其他 | uniqueidentifier | Guid | |
25 | Variant | Object |