{"id":42,"date":"2015-05-05T22:57:05","date_gmt":"2015-05-05T22:57:05","guid":{"rendered":"https:\/\/jmrowe.com\/blog\/?p=42"},"modified":"2015-05-05T23:06:44","modified_gmt":"2015-05-05T23:06:44","slug":"c-entity-framework-snippets","status":"publish","type":"post","link":"https:\/\/jmrowe.com\/blog\/c-entity-framework-snippets\/","title":{"rendered":"C# Entity Framework snippets"},"content":{"rendered":"<p><a href=\"https:\/\/jmrowe.com\/blog\/development\/c\/c-entity-framework-snippets\/attachment\/entity-framework-cheatsheet\" rel=\"attachment wp-att-45\">entity-framework-cheatsheet<\/a><\/p>\n<p>&nbsp;<\/p>\n<pre class=\"lang:c# decode:true \" title=\"Entity Snippets\">using (MyEntities context = new MyEntities())\r\n{\r\n    \/\/ Query a collection\r\n    IQueryable&lt;MyThing&gt; thingsQuery = from thing in context.Things\r\n                                      where thing.Name == \"Foo\"\r\n                                      select product;\r\n    foreach (var t in thingsQuery)\r\n    {\r\n        DoSomethingWith(t);\r\n    }\r\n\r\n    \/\/ Delete an object\r\n    context.DeleteObject(thingsQuery.First());\r\n\r\n    \/\/ Query for a single object, and process related objects\r\n    var thing = context.Things.Include(\"Subthings\").Where(o =&gt; o.ThingID.Equals(\"foo\")).FirstOrDefault();\r\n    if (thing != null)\r\n    {\r\n        foreach (var subthing in thing.Subthings)\r\n            DoSomethingWithSubthing(subthing);\r\n    }\r\n\r\n    \/\/ Save changes\r\n    try\r\n    {\r\n        int count = context.SaveChanges();\r\n    }\r\n    catch (OptimisticConcurrencyException)\r\n    {\r\n        context.Refresh(RefreshMode.ClientWins, things);\r\n        context.SaveChanges();\r\n    }\r\n    catch (UpdateException)\r\n    {\r\n        \/\/ ...\r\n    }\r\n    catch (InvalidOperationException)\r\n    {\r\n        \/\/ ...\r\n    }\r\n}\r\n\r\n\/\/Source: http:\/\/undefinedvalue.com\/2012\/07\/11\/entity-framework-cheatsheet<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>entity-framework-cheatsheet &nbsp; using (MyEntities context = new MyEntities()) { \/\/ Query a collection IQueryable&lt;MyThing&gt; thingsQuery = from thing in context.Things where thing.Name == &#8220;Foo&#8221; select product; foreach (var t in thingsQuery) { DoSomethingWith(t); } \/\/ Delete an object context.DeleteObject(thingsQuery.First()); \/\/ Query for a single object, and process related objects var thing = context.Things.Include(&#8220;Subthings&#8221;).Where(o =&gt; o.ThingID.Equals(&#8220;foo&#8221;)).FirstOrDefault(); [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-42","post","type-post","status-publish","format-standard","hentry","category-c"],"_links":{"self":[{"href":"https:\/\/jmrowe.com\/blog\/wp-json\/wp\/v2\/posts\/42","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jmrowe.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jmrowe.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jmrowe.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jmrowe.com\/blog\/wp-json\/wp\/v2\/comments?post=42"}],"version-history":[{"count":3,"href":"https:\/\/jmrowe.com\/blog\/wp-json\/wp\/v2\/posts\/42\/revisions"}],"predecessor-version":[{"id":46,"href":"https:\/\/jmrowe.com\/blog\/wp-json\/wp\/v2\/posts\/42\/revisions\/46"}],"wp:attachment":[{"href":"https:\/\/jmrowe.com\/blog\/wp-json\/wp\/v2\/media?parent=42"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jmrowe.com\/blog\/wp-json\/wp\/v2\/categories?post=42"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jmrowe.com\/blog\/wp-json\/wp\/v2\/tags?post=42"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}