{"id":84,"date":"2010-09-14T10:38:30","date_gmt":"2010-09-14T08:38:30","guid":{"rendered":"http:\/\/www.gerst-it.com\/blog\/?p=84"},"modified":"2010-12-30T11:51:26","modified_gmt":"2010-12-30T09:51:26","slug":"entity-framework-anbingung-postgresql","status":"publish","type":"post","link":"https:\/\/blog.gerst-it.com\/?p=84","title":{"rendered":"Entity Framework Anbingung PostgreSql"},"content":{"rendered":"<p><strong>1.<\/strong> Aktuellen Treiber von <a href=\"http:\/\/pgfoundry.org\/frs\/?group_id=1000140&amp;release_id=1686\">http:\/\/pgfoundry.org\/frs\/?group_id=1000140&amp;release_id=1686<\/a>\u00a0herunterladen (Framework 4.0)<\/p>\n<p><strong>2.<\/strong> NpgSql.dll und mono.security.dll\u00a0mit Gac registrieren, wichtig Visual Studio Command Prompt als Administrator ausf\u00fchren<br \/>\n<code><em>gacutil -i \"Pfad\\Zur\\Datei\\Npgsql2.0.10-bin-ms.net4.0\\Npgsql.dll\"<\/em><br \/>\n<em>gacutil \u00a0-i\u00a0\u00a0\"Pfad\\Zur\\Datei\\Npgsql2.0.10-bin-ms.net4.0\\mono.security.dll\"<\/em><\/code><\/p>\n<p><strong>3.<\/strong> Update der Machine.config (<em>C:\\Windows\\Microsoft.NET\\Framework64\\v4.0.30319\\Config<\/em>) in der Section <em>&lt;DbProviderFactories&gt;<\/em><\/p>\n<p><code><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\">&lt;<\/span><\/span><\/span><\/span><\/span><\/span><span style=\"font-family: Consolas; color: #a31515; font-size: x-small;\"><span style=\"font-family: Consolas; color: #a31515; font-size: x-small;\"><span style=\"font-family: Consolas; color: #a31515; font-size: x-small;\">add<\/span><\/span><\/span><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"> <\/span><\/span><\/span><span style=\"font-family: Consolas; color: #ff0000; font-size: x-small;\"><span style=\"font-family: Consolas; color: #ff0000; font-size: x-small;\"><span style=\"font-family: Consolas; color: #ff0000; font-size: x-small;\">name<\/span><\/span><\/span><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\">=<\/span><\/span><\/span><span style=\"font-family: Consolas; font-size: x-small;\"><span style=\"font-family: Consolas; font-size: x-small;\">\"<\/span><\/span><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\">PostgreSQL Data Provider<\/span><\/span><\/span><span style=\"font-family: Consolas; font-size: x-small;\"><span style=\"font-family: Consolas; font-size: x-small;\">\"<\/span><\/span><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"> <\/span><\/span><\/span><span style=\"font-family: Consolas; color: #ff0000; font-size: x-small;\"><span style=\"font-family: Consolas; color: #ff0000; font-size: x-small;\"><span style=\"font-family: Consolas; color: #ff0000; font-size: x-small;\">invariant<\/span><\/span><\/span><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\">=<\/span><\/span><\/span><span style=\"font-family: Consolas; font-size: x-small;\"><span style=\"font-family: Consolas; font-size: x-small;\">\"<\/span><\/span><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\">Npgsql<\/span><\/span><\/span><span style=\"font-family: Consolas; font-size: x-small;\"><span style=\"font-family: Consolas; font-size: x-small;\">\"<\/span><\/span><span style=\"font-family: Consolas; color: #ff0000; font-size: x-small;\"><span style=\"font-family: Consolas; color: #ff0000; font-size: x-small;\"><span style=\"font-family: Consolas; color: #ff0000; font-size: x-small;\">description<\/span><\/span><\/span><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\">=<\/span><\/span><\/span><span style=\"font-family: Consolas; font-size: x-small;\"><span style=\"font-family: Consolas; font-size: x-small;\">\"<\/span><\/span><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\">.Net Framework Data Provider for PostgreSQL<\/span><\/span><\/span><span style=\"font-family: Consolas; font-size: x-small;\"><span style=\"font-family: Consolas; font-size: x-small;\">\"<\/span><\/span><span style=\"font-family: Consolas; color: #ff0000; font-size: x-small;\"><span style=\"font-family: Consolas; color: #ff0000; font-size: x-small;\"><span style=\"font-family: Consolas; color: #ff0000; font-size: x-small;\">type<\/span><\/span><\/span><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\">=<\/span><\/span><\/span><span style=\"font-family: Consolas; font-size: x-small;\"><span style=\"font-family: Consolas; font-size: x-small;\">\"<\/span><\/span><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\">Npgsql.NpgsqlFactory, Npgsql, Version=2.0.10.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7<\/span><\/span><\/span><span style=\"font-family: Consolas; font-size: x-small;\"><span style=\"font-family: Consolas; font-size: x-small;\">\"<\/span><\/span><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"><span style=\"font-family: Consolas; color: #0000ff; font-size: x-small;\"> \/&gt;<\/span><\/span><\/span><\/code><\/p>\n<p><strong>4.<\/strong> Zur Zeit gibt es keine Design Time Unterst\u00fczung, mittels des Tool edmgen kann das DataModel erzeugt werden.<br \/>\n<code><em>edmgen \/mode:FullGeneration \/project:Test \/c:\"Server=localhost; User Id=dbuser; Password=password; Database=database\" \/provider:Npgsql<\/em><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Aktuellen Treiber von http:\/\/pgfoundry.org\/frs\/?group_id=1000140&amp;release_id=1686\u00a0herunterladen (Framework 4.0) 2. NpgSql.dll und mono.security.dll\u00a0mit Gac registrieren, wichtig Visual Studio Command Prompt als Administrator ausf\u00fchren gacutil -i &#8222;Pfad\\Zur\\Datei\\Npgsql2.0.10-bin-ms.net4.0\\Npgsql.dll&#8220; gacutil \u00a0-i\u00a0\u00a0&#8222;Pfad\\Zur\\Datei\\Npgsql2.0.10-bin-ms.net4.0\\mono.security.dll&#8220; 3. Update der Machine.config (C:\\Windows\\Microsoft.NET\\Framework64\\v4.0.30319\\Config) in der Section &lt;DbProviderFactories&gt; &lt;add name=&#8220;PostgreSQL Data Provider&#8220; invariant=&#8220;Npgsql&#8220;description=&#8220;.Net Framework Data Provider for PostgreSQL&#8220;type=&#8220;Npgsql.NpgsqlFactory, Npgsql, Version=2.0.10.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7&#8243; \/&gt; 4. Zur Zeit gibt es [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-84","post","type-post","status-publish","format-standard","hentry","category-net"],"_links":{"self":[{"href":"https:\/\/blog.gerst-it.com\/index.php?rest_route=\/wp\/v2\/posts\/84","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.gerst-it.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.gerst-it.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.gerst-it.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.gerst-it.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=84"}],"version-history":[{"count":4,"href":"https:\/\/blog.gerst-it.com\/index.php?rest_route=\/wp\/v2\/posts\/84\/revisions"}],"predecessor-version":[{"id":87,"href":"https:\/\/blog.gerst-it.com\/index.php?rest_route=\/wp\/v2\/posts\/84\/revisions\/87"}],"wp:attachment":[{"href":"https:\/\/blog.gerst-it.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=84"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.gerst-it.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=84"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.gerst-it.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=84"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}