Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using (MyDataContext wdc = new MyDataContext())
- {
- Article article = wdc.Article.First(p => p.ID == id);
- article.ItemsInStock = itemsinstock;
- wdc.SubmitChanges();
- }
- wdc.ExecuteCommand("UPDATE Article SET ItemsInStock = @1 WHERE ID = @2", itemsinstock,id);
- UPDATE ... SET ... WHERE ID = @2
- UPDATE ... SET ... WHERE ID = @2 AND ItemsInStock = @1 AND SomeOtherColumn = @3 AND...
- context.Articles.Attach(article /* article with updated values */, new Article { ID = articleID, ItemsInStock = -1 } /* pretend that this is the original article */);
- context.SubmitChanges();
Add Comment
Please, Sign In to add comment