如何在EF中使用代码First插入时间戳字段

debugcn 发表于 Dev

用户名

我有Timestamp字段类型VARBINARY，我想问如何首先使用代码在Timestamp字段上插入byte []

private void AddDataToFormsTable(AthenaContext context)
{
    List<Form> listOfForms = new  List<Form>( )
                                 {
                                     new Form(){ UniqeId = Guid.NewGuid(), Name = "Form", Description = "form", ModifiedBy = " ",ModifiedOn = DateTime.Now,CreatedBy = " ",CreatedOn = DateTime.Now},
                                     new Form(){ UniqeId = Guid.NewGuid(), Name = "Form2", Description = "form2", ModifiedBy = " ",ModifiedOn = DateTime.Now,CreatedBy = " ",CreatedOn = DateTime.Now},
                                     new Form(){ UniqeId = Guid.NewGuid(), Name = "Form3", Description = "form3", ModifiedBy = " ",ModifiedOn = DateTime.Now,CreatedBy = " ",CreatedOn = DateTime.Now},
                                     new Form(){ UniqeId = Guid.NewGuid(), Name = "Form4", Description = "form4", ModifiedBy = " ",ModifiedOn = DateTime.Now,CreatedBy = " ",CreatedOn = DateTime.Now},
                                     new Form(){ UniqeId = Guid.NewGuid(), Name = "Form5", Description = "form5", ModifiedBy = " ",ModifiedOn = DateTime.Now,CreatedBy = " ",CreatedOn = DateTime.Now},
                                 };

    listOfForms.ForEach(i =>context.Forms.Add(i));

    context.SaveChanges();

}

迪伦·斯拉宾克（Dylan Slabbinck）

简单的解决方案，在数据库中将CreatedOn的类型更改为DateTime，

否则： Convert.ToByte(DateTime.Now)

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。