有关讨论请看
https://www.cnblogs.com/choon/p/3951312.html
https://www.cnblogs.com/xishuai/p/entity-framework-code-first-computed-getdate.html
解决办法就是
添加这个特性: [DatabaseGenerated(DatabaseGeneratedOption.Computed)]
[DatabaseGenerated(DatabaseGeneratedOption.Computed)]
public DateTime CreationTime { get; set; }
代码验证如下
Program.cs
using System;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Data.Entity;
namespace CodeFirstDemo
{
class Program
{
static void Main(string[] args)
{
using (var db = new ProductContext())
{
var product = new Product { Name = "xishuai" };
db.Products.Add(product);
db.SaveChanges();
Console.WriteLine("success");
Console.ReadKey();
}
}
}
public class Product
{
[Key]
public int ID { get; set; }
public string Name { get; set; }
[DatabaseGenerated(DatabaseGeneratedOption.Computed)]
public DateTime CreationTime { get; set; }
}
public class ProductContext : DbContext
{
public DbSet<Product> Products { get; set; }
}
}
App.config
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
<section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
</configSections>
<entityFramework>
<defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
<parameters>
<parameter value="v11.0" />
</parameters>
</defaultConnectionFactory>
<providers>
<provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
</providers>
</entityFramework>
<connectionStrings>
<add name="ProductContext" providerName="System.Data.SqlClient" connectionString="Server=.; Database=GzhhAbp; Trusted_Connection=true" />
</connectionStrings>
</configuration>