{"id":80,"date":"2008-11-11T16:31:47","date_gmt":"2008-11-11T20:31:47","guid":{"rendered":"http:\/\/hoolihan.net\/blog-tim\/?p=80"},"modified":"2008-11-11T16:31:47","modified_gmt":"2008-11-11T20:31:47","slug":"linq-to-sql","status":"publish","type":"post","link":"http:\/\/hoolihan.net\/blog-tim\/2008\/11\/11\/linq-to-sql\/","title":{"rendered":"Linq to SQL"},"content":{"rendered":"<p><em>Background:<\/em> Linq to Sql is a lightweight data access protocol for the .Net framework.\u00a0 It supports filtering and other lambda features in code, allowing the programmer to treat their data source as if it were a collection of objects that support flexible features.\u00a0 In this way, it can be thought of as an ORM mapper, though some might dispute that.\u00a0 Disclaimer: That is my own oversimplified definition.<\/p>\n<p>I like what I see out of Linq to Sql.\u00a0 It shows a lot of potential, and the transference of knowledge that should happen when using other forms of Linq (xml, objects) is a nice benefit.\u00a0 However, there are a lot of questions raised in the community like the following:<\/p>\n<p><a href=\"http:\/\/odetocode.com\/Blogs\/scott\/archive\/2008\/11\/10\/12311.aspx\">http:\/\/odetocode.com\/Blogs\/scott\/archive\/2008\/11\/10\/12311.aspx<\/a><\/p>\n<p>I&#8217;ve been in several debates over this.\u00a0 My concern isn&#8217;t that Linq to Sql is bad, but there are serious maintainability issues around code that uses dead Microsoft features.\u00a0 In the open source world, as long as community members want to use a feature, it will be around.\u00a0 Trying to get help from a black-listed feature from vendors, consultants, and community members in the Microsoft world isn&#8217;t so easy.\u00a0 You certainly aren&#8217;t going to see Microsoft spend time and money adding interop hooks for features that have fallen out of favor.\u00a0 And how many of your junior programmers five years from now are going to be familiar with a feature from .Net 3.0\/3.5 that is shunned in the version du jour.\u00a0<\/p>\n<p>Everytime I think about using such a feature, I think of the excited J# developers of the early 2000&#8217;s.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Background: Linq to Sql is a lightweight data access protocol for the .Net framework.\u00a0 It supports filtering and other lambda features in code, allowing the programmer to treat their data source as if it were a collection of objects that support flexible features.\u00a0 In this way, it can be thought of as an ORM mapper, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,55,34,18],"tags":[],"class_list":["post-80","post","type-post","status-publish","format-standard","hentry","category-aspnet","category-data","category-microsoft","category-programming"],"_links":{"self":[{"href":"http:\/\/hoolihan.net\/blog-tim\/wp-json\/wp\/v2\/posts\/80","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/hoolihan.net\/blog-tim\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/hoolihan.net\/blog-tim\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/hoolihan.net\/blog-tim\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/hoolihan.net\/blog-tim\/wp-json\/wp\/v2\/comments?post=80"}],"version-history":[{"count":0,"href":"http:\/\/hoolihan.net\/blog-tim\/wp-json\/wp\/v2\/posts\/80\/revisions"}],"wp:attachment":[{"href":"http:\/\/hoolihan.net\/blog-tim\/wp-json\/wp\/v2\/media?parent=80"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/hoolihan.net\/blog-tim\/wp-json\/wp\/v2\/categories?post=80"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/hoolihan.net\/blog-tim\/wp-json\/wp\/v2\/tags?post=80"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}