Entity framework - add new record where is only Id

Question

I have table:

CREATE TABLE [dbo].[Items] 
(
     [Id] INT IDENTITY (1, 1) NOT NULL,
     PRIMARY KEY CLUSTERED ([Id] ASC)
);

Id is auto increment and I am creating new record like this:

var Context = new Entities();
var Item = new Items();
Context.SaveChanges();

But in the table there is no new record. What am I doing wrong?

William Xifaras · Accepted Answer · 2015-06-24 17:43:36Z

3

You have to add the item into the entity set.

using (var dbCtx = new Entities())
{
   var myItem = new Items();
   dbCtx.Items.Add(myItem);
   dbCtx.SaveChanges();
}

edited Jun 24, 2015 at 17:43

answered Jun 24, 2015 at 17:22

William Xifaras

5,3622 gold badges22 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Mark Falex Over a year ago

I get this error: "An exception of type 'System.Data.Entity.Infrastructure.DbUpdateException' occurred in EntityFramework.dll but was not handled in user code Additional information: An error occurred while updating the entries. See the inner exception for details."

William Xifaras Over a year ago

You are most likely trying to insert a duplicate. Look at the the following SO answer: stackoverflow.com/questions/20762923/…

William Xifaras Over a year ago

I updated my answer. You need to declare the item correctly. My original response was specifically related to the fact that you weren't adding the item to the entity set.

Mark Falex Over a year ago

Yeah, you are right. Sorry, I know, where is the issue. Thank you.

Collectives™ on Stack Overflow

Entity framework - add new record where is only Id

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related