Loading

Select data from changed entity

Marco baldi

5y716Learn iOS Programming

Hi,

I have this situation :

foreach(var item in list)

{

var result = dbContext.Customers.ToArrays();

......

.......

//Here i insert new customer into database but not saved

dbContext.Customers.add(new Customer);

{

The problem is for result variable, the first loop works, but the second return Time Out because the Customer Entity is changed, hot to risolve this problem ?

Thanks.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R5y ago
Hey Marco,
Refer this link,
https://www.c-sharpcorner.com/blogs/add-list-of-item-to-database-using-entity-framework1
+1
Sachin Singh5y ago
you can not add and loop through on the same entity list untill you save changes to database
foreach(var item in  dbContext.Customers.ToList())
{
   // to do
}

dbContext.Customers.Add(new Customer(){name="",Gender="",});
dbcontext.SaveChanges();


foreach(var item in  dbContext.Customers.ToList())
{
   // here you will get all records including recently added one
}
+1