entity framework - save records even if we have errors in some of them -


i copy data database database has got different structure mine - create objects, add them dbset , call savechanges() method. if 1 record invalid method savechanges() throws error , no records inserted in database. save correct records instead - how can in entity framework?

databasecontext db = new databasecontext();  gifts gift1 = new gifts(); gift1.name = "test1"; gift1.price = 5; db.gifts.add(gift1);  // here error - because name can't null: gifts gift2 = new gifts(); gift2.name = null; gift2.price = 5; db.gifts.add(gift2);  gifts gift3 = new gifts(); gift3.name = "test3"; gift3.price = 5; db.gifts.add(gift3);  // .....  databasecontext.savechanges(); 

just enclose code in try catch blocks , save each entity saperately:

databasecontext db = new databasecontext();  try{     gifts gift1 = new gifts();     gift1.name = "test1";     gift1.price = 5;     db.gifts.add(gift1);      databasecontext.savechanges(); } catch{}  // here error - because name can't null: try{     gifts gift2 = new gifts();     gift2.name = null;     gift2.price = 5;     db.gifts.add(gift2);      databasecontext.savechanges(); } catch{}  try{        gifts gift3 = new gifts();     gift3.name = "test3";     gift3.price = 5;     db.gifts.add(gift3);      databasecontext.savechanges(); } catch{} 

Comments

Popular posts from this blog

shopping cart - Page redirect not working PHP -

php - How to modify a menu to show sub-menus -

python - Installing PyDev in eclipse is failed -