Insert Multiple Rows to Database LINQ

Question

I have a foreach loop that iterates through a list of type List<NewItem>, creates a new instance of NewItem, sets its properties, then Add()s the item to the context to be inserted upon the execution of SaveChanges():

foreach (var newItem in newItems)
{
    NewItem item = new NewItem 
    {
        User = newItem.User,
        Itemno = newItem.Itemno
    };

    db.NewItem.Add(item);

}

try
{
    db.SaveChanges();
}
catch (Exception e)
{
    Console.WriteLine(e);
}

I am getting the error:

Unable to update the EntitySet 'NewItem' because it has a DefiningQuery and no element exists in the element to support the current operation.

Why isn't the Add() method actually adding anything to my db context?

SpunkyDonutz · Accepted Answer · 2017-04-12 22:23:22Z

1

If the target database table doesn't have a primary key, add one.

answered Apr 12, 2017 at 22:23

SpunkyDonutz

867 bronze badges

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

Collectives™ on Stack Overflow

Insert Multiple Rows to Database LINQ

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related