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
Post a Comment