如何将PostgreSql与EntityFramework 6.0.2集成？ [英] How to integrate PostgreSql with EntityFramework 6.0.2?

问题描述

我收到以下错误

实体框架提供程序的Instance成员键入
'Npgsql.NpgsqlServices， Npgsql，Version = 2.0.14.2，Culture = neutral，
PublicKeyToken = 5d8b90d52f46fda7'没有返回
从'System.Data.Entity.Core.Common.DbProviderServices'继承的对象。
实体框架提供者必须从此类继承，
'Instance'成员必须返回提供者的单例实例。
这可能是因为提供者不支持Entity Framework 6
或更高版本;请参阅 http://go.microsoft.com/fwlink/?LinkId=260882&hl=zh_CN 更多
信息。

The 'Instance' member of the Entity Framework provider type 'Npgsql.NpgsqlServices, Npgsql, Version=2.0.14.2, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7' did not return an object that inherits from 'System.Data.Entity.Core.Common.DbProviderServices'. Entity Framework providers must inherit from this class and the 'Instance' member must return the singleton instance of the provider. This may be because the provider does not support Entity Framework 6 or later; see http://go.microsoft.com/fwlink/?LinkId=260882 for more information.

任何人都可以帮助我

这里是我的App.Config文件

here is my App.Config File

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <connectionStrings>
    <add name="CacsLocal" connectionString="Server=localhost;Database=Kappa;User Id=postgres; Password=xyz;" providerName="Npgsql" />
    <add name="   CacsCentral" connectionString="Server=localhost;Database=KPT1;User Id=postgres; Password=insane1234;" providerName="Npgsql" />
  </connectionStrings>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
    <providers>     
      <provider invariantName="Npgsql" type="Npgsql.NpgsqlServices, Npgsql" />
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer"></provider>
    </providers>
  </entityFramework>
  <system.data>
    <DbProviderFactories>
      <add name="Npgsql Data Provider" invariant="Npgsql" description="Data Provider for PostgreSQL" type="Npgsql.NpgsqlFactory, Npgsql" />
    </DbProviderFactories>
  </system.data>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
  </startup>
</configuration>

我有Npgsql2版本2.0.14.2
实体框架6.0.2

I have Npgsql2 version 2.0.14.2 Entity Framework 6.0.2

所有包都通过包管理器通过以下命令安装

All the packages are installed through Package Manager by following command

Install-Package Npgsql -Pre
Install-Package EntityFramework -Pre

谢谢

推荐答案

查看此问题：实体框架6与Npgsql

它有指针让它工作。我希望它有帮助。

It has the pointers to get it working. I hope it helps.

这篇关于如何将PostgreSql与EntityFramework 6.0.2集成？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！