{"id":796,"date":"2007-04-22T03:07:00","date_gmt":"2007-04-22T03:07:00","guid":{"rendered":"\/blogs\/bobb\/post\/EDM-Wizard-Not-Working-Use-EDMGen.aspx"},"modified":"2013-01-04T00:00:02","modified_gmt":"2013-01-04T08:00:02","slug":"edm-wizard-not-working-use-edmgen","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/bobb\/edm-wizard-not-working-use-edmgen\/","title":{"rendered":"EDM Wizard Not Working? Use EDMGen"},"content":{"rendered":"<p>\nThe day after Orcas Beta1 appeared for public download reports appeared on the <a href=\"http:\/\/social.msdn.microsoft.com\/forums\/en-US\/adodotnetentityframework\/threads\/\">ADO.NET Technology Preview forum<\/a> that the EDM Wizard (that is, &quot;Add New Item\/ADO.NET Entity Data Model) wasn&#39;t working. And, sure enough, if you choose &quot;Generate From Database&quot; and carefully choose which tables to use, you get a model with no entities. If you choose an empty model, you&nbsp;get &quot;Specified argument out of range of valid values&quot;, and get&nbsp;the three mapping files, but no language file. What to do?\n<\/p>\n<p>\nOne way around this is to use the files generated from the March CTP wizard. Because the XML schemas for the mapping files haven&#39;t changed since March CTP, these work fine. In fact, all of the EDM code that worked with March CTP continues to work unchanged. That&#39;s what I used in the SQLCE and EDM blog entry posting.\n<\/p>\n<p>\nIf you can&#39;t keep an old March CTP around just to generate EDM Data Models, you can use the EDMGen.exe command line utility in the C:\\WINDOWS\\Microsoft.NET\\Framework\\v3.5.20404 directory. This utility appears to work and generates useable code. It also&nbsp;generates a richer model than the wizard did (with AssociationSets and Associations) but it takes a little more work to put together a project. I&#39;ll post a really simple one if there&#39;s interest.&nbsp;And EDMGen doesn&#39;t generate the same output as the wizard used to (for example, columns of type NTEXT are ignored in the model) and uses different default naming conventions. So at least there are a few workarounds for now.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The day after Orcas Beta1 appeared for public download reports appeared on the ADO.NET Technology Preview forum that the EDM Wizard (that is, &quot;Add New Item\/ADO.NET Entity Data Model) wasn&#39;t working. And, sure enough, if you choose &quot;Generate From Database&quot; and carefully choose which tables to use, you get a model with no entities. If [&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-796","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>EDM Wizard Not Working? Use EDMGen - 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\/edm-wizard-not-working-use-edmgen\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"EDM Wizard Not Working? Use EDMGen - Bob Beauchemin\" \/>\n<meta property=\"og:description\" content=\"The day after Orcas Beta1 appeared for public download reports appeared on the ADO.NET Technology Preview forum that the EDM Wizard (that is, &quot;Add New Item\/ADO.NET Entity Data Model) wasn&#039;t working. And, sure enough, if you choose &quot;Generate From Database&quot; and carefully choose which tables to use, you get a model with no entities. If [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/bobb\/edm-wizard-not-working-use-edmgen\/\" \/>\n<meta property=\"og:site_name\" content=\"Bob Beauchemin\" \/>\n<meta property=\"article:published_time\" content=\"2007-04-22T03:07:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-01-04T08:00:02+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\/edm-wizard-not-working-use-edmgen\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/edm-wizard-not-working-use-edmgen\/\",\"name\":\"EDM Wizard Not Working? Use EDMGen - Bob Beauchemin\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website\"},\"datePublished\":\"2007-04-22T03:07:00+00:00\",\"dateModified\":\"2013-01-04T08:00:02+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/edm-wizard-not-working-use-edmgen\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/bobb\/edm-wizard-not-working-use-edmgen\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/edm-wizard-not-working-use-edmgen\/#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\":\"EDM Wizard Not Working? Use EDMGen\"}]},{\"@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":"EDM Wizard Not Working? Use EDMGen - 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\/edm-wizard-not-working-use-edmgen\/","og_locale":"en_US","og_type":"article","og_title":"EDM Wizard Not Working? Use EDMGen - Bob Beauchemin","og_description":"The day after Orcas Beta1 appeared for public download reports appeared on the ADO.NET Technology Preview forum that the EDM Wizard (that is, &quot;Add New Item\/ADO.NET Entity Data Model) wasn&#39;t working. And, sure enough, if you choose &quot;Generate From Database&quot; and carefully choose which tables to use, you get a model with no entities. If [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/edm-wizard-not-working-use-edmgen\/","og_site_name":"Bob Beauchemin","article_published_time":"2007-04-22T03:07:00+00:00","article_modified_time":"2013-01-04T08:00:02+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\/edm-wizard-not-working-use-edmgen\/","url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/edm-wizard-not-working-use-edmgen\/","name":"EDM Wizard Not Working? Use EDMGen - Bob Beauchemin","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website"},"datePublished":"2007-04-22T03:07:00+00:00","dateModified":"2013-01-04T08:00:02+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/edm-wizard-not-working-use-edmgen\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/bobb\/edm-wizard-not-working-use-edmgen\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/edm-wizard-not-working-use-edmgen\/#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":"EDM Wizard Not Working? Use EDMGen"}]},{"@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\/796","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=796"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts\/796\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/media?parent=796"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/categories?post=796"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/tags?post=796"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}