1

I have the following Mapper in Entity Framework 7 RC1:

  b.ToTable("Categories");
  b.HasKey(x => x.Id);
  b.Property(x => x.Id) ... ??

How to make Id and identity column in EF 7 RC1?

The SQL equivalent is:

Id int identity not null

I've read that would be like this:

b.Property(x => x.Id).ForSqlServer().UseIdentity();

But in EF7 RC1 I do not find ForSqlServer(). I do find:

.ForSqlServerHasComputedSql()
.ForSqlServerHasColumnName()
.ForSqlServerHasColumnNameType()
.ForSqlServerHasDefaultValue()
.ForSqlServerHasDefaultValueSql()
.ForSqlServerUseSequenceHiLo()
...
Miguel Moura
  • 36,732
  • 85
  • 259
  • 481

2 Answers2

3

You can explicitly configure an identity column by calling.

b.Property(x => x.Id).UseSqlServerIdentityColumn();

Also worth noting: identity is the default value generation pattern used with primary keys. Using sequences is opt-in.

natemcmaster
  • 25,673
  • 6
  • 78
  • 100
  • 1
    Sequences are an alternative to identity. See http://stackoverflow.com/questions/10062328/sequence-vs-identity. EF supports both, but defaults to identity. – natemcmaster Dec 17 '15 at 22:29
1

The answer provided by natemcmaster is correct. You can define with fluentAPI or you can also use Data Annotation [Key] to define Primary Key.

However there are couple of ways to define identity value in EF Core. You can use identity (default), Sequence and HiLo Pattern with Sequence. Identity is default. In fact you don't have to define it as identity column if your property name ending with Id or <typeName> Id. EF Core by convention configures a property named Id or <typeName>Id as the key of an entity.

And the reason for having extension method name starting from ForSqlServer is that, EF Core supports many database providers. And functionality for these providers are slightly different so you are able to specify a different behavior for the same property depending on the provider being used.

Please read these article to know more about using Sequcence with EF Core and HiLo with EF core.

VirendraJ
  • 556
  • 5
  • 14