{"id":947,"date":"2005-05-16T05:25:00","date_gmt":"2005-05-16T05:25:00","guid":{"rendered":"\/blogs\/bobb\/post\/DataDirect-providersand-some-ADONET-20-beta2-changes.aspx"},"modified":"2005-05-16T05:25:00","modified_gmt":"2005-05-16T05:25:00","slug":"datadirect-providers-and-some-ado-net-2-0-beta2-changes","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/bobb\/datadirect-providers-and-some-ado-net-2-0-beta2-changes\/","title":{"rendered":"DataDirect providers&#8230;and some ADO.NET 2.0 beta2 changes"},"content":{"rendered":"<p>\nRealized that I haven&#39;t blogged in a while. I been &#8230;uh&#8230;working on stuff and traveling a lot lately. Big surprise, right? This week I&#39;ll be on vacation. Traveling. Now I understand what the term &ldquo;busman&#39;s holiday&ldquo; means.\n<\/p>\n<p>\nLast weekend I had dinner with Rob Steward of DataDirect Technologies at his house.&nbsp;The ribs were great (thanks Rob)&nbsp;and while they were cooking I asked him if there would be support of rich schema metadata, base classes, and the neat stuff I wrote about I my ADO.NET 2.0 series of articles in DataDirect&#39;s line of ADO.NET data providers. He said that there would be, of course. They want to show up in that neat new Visual Studio 2005 connection dialog (that lists the ADO.NET data providers rather than OLE DB providers) too. And make a good showing in Server Explorer.\n<\/p>\n<p>\nThen I asked about whether their classes derived from System.Data.ProviderBase&#39;s. This isn&#39;t the base classes in System.Data.Common (they support those), but the base classes to assist provider writers. Surprise! Those classes are now protected sealed in .NET 2.0 beta2. Oh. Guess not, then.\n<\/p>\n<p>\nBut they will support all the same things you&#39;d&nbsp;have gotten&nbsp;from these classes for free: ConnectionStringBuilder, Connection Pooling (they always did support this), etc. So you&#39;ll be good to go.\n<\/p>\n<p>\nAlso, in looking through DbProviderFactory and friends, the SupportedClasses property is removed. That was the one that told you which classes (like Connection, Command, etc) the provider actually implemented. Gone from machine.config entries too. Wonder why&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Realized that I haven&#39;t blogged in a while. I been &#8230;uh&#8230;working on stuff and traveling a lot lately. Big surprise, right? This week I&#39;ll be on vacation. Traveling. Now I understand what the term &ldquo;busman&#39;s holiday&ldquo; means. Last weekend I had dinner with Rob Steward of DataDirect Technologies at his house.&nbsp;The ribs were great (thanks [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-947","post","type-post","status-publish","format-standard","hentry","category-data-access"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>DataDirect providers...and some ADO.NET 2.0 beta2 changes - Bob Beauchemin<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/bobb\/datadirect-providers-and-some-ado-net-2-0-beta2-changes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DataDirect providers...and some ADO.NET 2.0 beta2 changes - Bob Beauchemin\" \/>\n<meta property=\"og:description\" content=\"Realized that I haven&#039;t blogged in a while. I been &#8230;uh&#8230;working on stuff and traveling a lot lately. Big surprise, right? This week I&#039;ll be on vacation. Traveling. Now I understand what the term &ldquo;busman&#039;s holiday&ldquo; means. Last weekend I had dinner with Rob Steward of DataDirect Technologies at his house.&nbsp;The ribs were great (thanks [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/bobb\/datadirect-providers-and-some-ado-net-2-0-beta2-changes\/\" \/>\n<meta property=\"og:site_name\" content=\"Bob Beauchemin\" \/>\n<meta property=\"article:published_time\" content=\"2005-05-16T05:25:00+00:00\" \/>\n<meta name=\"author\" content=\"Bob Beauchemin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bob Beauchemin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/datadirect-providers-and-some-ado-net-2-0-beta2-changes\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/datadirect-providers-and-some-ado-net-2-0-beta2-changes\/\",\"name\":\"DataDirect providers...and some ADO.NET 2.0 beta2 changes - Bob Beauchemin\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website\"},\"datePublished\":\"2005-05-16T05:25:00+00:00\",\"dateModified\":\"2005-05-16T05:25:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/datadirect-providers-and-some-ado-net-2-0-beta2-changes\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/bobb\/datadirect-providers-and-some-ado-net-2-0-beta2-changes\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/datadirect-providers-and-some-ado-net-2-0-beta2-changes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Access\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/category\/data-access\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"DataDirect providers&#8230;and some ADO.NET 2.0 beta2 changes\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/\",\"name\":\"Bob Beauchemin\",\"description\":\"SQL Server Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e\",\"name\":\"Bob Beauchemin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g\",\"caption\":\"Bob Beauchemin\"},\"sameAs\":[\"http:\/www.sqlskills.com\/blogs\/bobb\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/author\/bobb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DataDirect providers...and some ADO.NET 2.0 beta2 changes - Bob Beauchemin","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/bobb\/datadirect-providers-and-some-ado-net-2-0-beta2-changes\/","og_locale":"en_US","og_type":"article","og_title":"DataDirect providers...and some ADO.NET 2.0 beta2 changes - Bob Beauchemin","og_description":"Realized that I haven&#39;t blogged in a while. I been &#8230;uh&#8230;working on stuff and traveling a lot lately. Big surprise, right? This week I&#39;ll be on vacation. Traveling. Now I understand what the term &ldquo;busman&#39;s holiday&ldquo; means. Last weekend I had dinner with Rob Steward of DataDirect Technologies at his house.&nbsp;The ribs were great (thanks [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/datadirect-providers-and-some-ado-net-2-0-beta2-changes\/","og_site_name":"Bob Beauchemin","article_published_time":"2005-05-16T05:25:00+00:00","author":"Bob Beauchemin","twitter_misc":{"Written by":"Bob Beauchemin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/datadirect-providers-and-some-ado-net-2-0-beta2-changes\/","url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/datadirect-providers-and-some-ado-net-2-0-beta2-changes\/","name":"DataDirect providers...and some ADO.NET 2.0 beta2 changes - Bob Beauchemin","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website"},"datePublished":"2005-05-16T05:25:00+00:00","dateModified":"2005-05-16T05:25:00+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/datadirect-providers-and-some-ado-net-2-0-beta2-changes\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/bobb\/datadirect-providers-and-some-ado-net-2-0-beta2-changes\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/datadirect-providers-and-some-ado-net-2-0-beta2-changes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/bobb\/"},{"@type":"ListItem","position":2,"name":"Data Access","item":"https:\/\/www.sqlskills.com\/blogs\/bobb\/category\/data-access\/"},{"@type":"ListItem","position":3,"name":"DataDirect providers&#8230;and some ADO.NET 2.0 beta2 changes"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/","name":"Bob Beauchemin","description":"SQL Server Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/bobb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e","name":"Bob Beauchemin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g","caption":"Bob Beauchemin"},"sameAs":["http:\/www.sqlskills.com\/blogs\/bobb\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/author\/bobb\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts\/947","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/comments?post=947"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts\/947\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/media?parent=947"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/categories?post=947"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/tags?post=947"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}