如何首先在实体框架代码中设置身份主键的起始值? [英] How to set starting value for an Identity primary key in Entity Framework code first?

问题描述

在我的项目中，我首先使用实体​​框架代码创建 Appointments 表.当我将整数主键 AppointmentNo 设置为 [Key] 和 [Required] 时，它会创建初始主键以 1 开头的表.

In my project I am creating the Appointments table using Entity Framework code first. When I set my integer primary key, AppointmentNo as [Key] and [Required], it creates the table with initial primary key starting with 1.

我希望约会号码从 1000 开始.我的数据库是 SQL Server.请帮我.先感谢您.

I want the appointment numbers to start at 1000. My database is SQL Server. Please help me. Thank you in advance.

[DataContract]
public class Appointment
{
    [DataMember]
    [Key]
    [Required]
    public int AppointmentNo { get; set; }

    [DataMember]
    [Required]
    public string DoctorUN { get; set; }

    [DataMember]
    [Required]
    public string PatientUN { get; set; }
}

推荐答案

不能使用ef注解，但是可以在迁移UP方法中执行sql

It's not possible using ef annotations,but you can execute sql in migration UP method

Sql("DBCC CHECKIDENT ('Appointment', RESEED, 1000)");

这篇关于如何首先在实体框架代码中设置身份主键的起始值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！