ReflectionTypeLoadException in Simple.Data using PostgreSql

See more:

ASP.NET

PostgreSQL

reflection

Hi All,
I am trying to open PostgreSQL connection but getting ReflectionTypeLoadException while opening connection.

Please help me out to solve this problem by providing code or let me know how to remove this exception.

Code i am using so far is below:

<configuration>
  <appsettings>
    <add key="superuserDatabase" value="postgres" />
  </appsettings>

  <system.data>
    <dbproviderfactories>
      <clear />
      <add name="Npgsql Data Provider">
           invariant="Npgsql"
           description=".Net Framework Data Provider for Postgresql Server"
           type="Npgsql.NpgsqlFactory, Npgsql" />
    </add></dbproviderfactories>
  </system.data>

  <connectionstrings>
    <add name="Simple.Data.Properties.Settings.DefaultConnectionString">
          connectionString="host=localhost;port=5432;database=SimpleData;user id=postgres;password=P@ssw0rdsa;pooling=false"
          providerName="Npgsql" />
    <add name="Test">
          connectionString="host=localhost;port=5432;database=SimpleData;user id=postgres;password=P@ssw0rdsa;pooling=false"
          providerName="Npgsql" />
  </add></add></connectionstrings>
</configuration>

I am getting following exception when trying to open connection in POSTGRESQL
var namedDb = Database.OpenNamedConnection("Test").Demo.All();

ReflectionTypeLoadException


Thanks & Regards,
Vishal Patel