public void IdentityInsert()
{
if (!EnsureVersion(new Version(3, 0, 0, 0)))
{
return;
}
using (var db = GetDbContext <IdentityInsertContext>())
{
db.Database.ExecuteSqlRaw("create table test_insert_identity (id int generated by default as identity (start with 26) primary key, name varchar(20))");
var entity = new IdentityInsertEntity()
{
Name = "foobar"
};
db.Add(entity);
db.SaveChanges();
Assert.AreEqual(27, entity.Id);
}
}
public async Task IdentityInsert()
{
if (!await EnsureVersion(new Version(3, 0, 0, 0)))
{
return;
}
var id = await GetServerVersion() >= new Version(4, 0, 0, 0) ? 26 : 27;
await using (var db = await GetDbContext <IdentityInsertContext>())
{
await db.Database.ExecuteSqlRawAsync("create table test_insert_identity (id int generated by default as identity (start with 26) primary key, name varchar(20))");
var entity = new IdentityInsertEntity()
{
Name = "foobar"
};
await db.AddAsync(entity);
await db.SaveChangesAsync();
Assert.AreEqual(id, entity.Id);
}
}
