How can I save a list of enitty into the database using Entity Framework Code First?
I have problem saving the list of entity.
Below is the code I have written:
List<Account> accounts = ActivateAccount();
// Save merchant account & bank information into database
using (var context = new MyContext())
{
try
{
context.Accounts.Attach(accounts);
context.SaveChanges();
}
catch (Exception ex)
{
}
}
Thank you.
See the below link. Difference between Attach and AddToObject
Entity Framework 4 - AddObject vs Attach
Please clarify are you updating disconnected records or adding records. Below is the code to add records in DB.
using (var context = new MyContext())
{
try
{
foreach(var row in accounts){
context.AddToAccounts(row);
}
context.SaveChanges();
}catch (Exception ex){
//Log any exception here.
}
}
List<Account> accounts = ActivateAccount();
// Save merchant account & bank information into database
using (var context = new MyContext())
{
try
{
context.Accounts.Add(accounts);
context.SaveChanges();
}
catch (Exception ex)
{
}
}
Try replacing Attach method with Add
I found several ways to do it in this post https://stackoverflow.com/a/12853252/7287324
Hope it solves your problem.
