how to insert value to identity column using entity framwork

Outrageous Orangutan answered on July 6, 2022 Popularity 6/10 Helpfulness 4/10

answer how to insert value to identity column using entity framwork

how to insert value to identity column using entity framwork

Comment

using (var dataContext = new DataModelContainer())
using (var transaction = dataContext.Database.BeginTransaction())
{
    var user = new User()
    {
        ID = id,
        Name = "John"
    };

    dataContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[User] ON");

    dataContext.User.Add(user);
    dataContext.SaveChanges();

    dataContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[User] OFF");

    transaction.Commit();
}

Popularity 6/10 Helpfulness 4/10 Language csharp

Source: Grepper

Tags: c# entity identity-column insert using

Link to this answer
Share Copy Link

Contributed on Jul 06 2022

Outrageous Orangutan

0 Answers Avg Quality 2/10

how to insert value to identity column using entity framwork

Contents

More Related Answers

how to insert value to identity column using entity framwork

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.