Bom dia,
Estou executando uma aplicação simples em C# com o framework 2.0 e
Npgsql2.0.12.0-bin-ms.net2.0.zip<http://pgfoundry.org/frs/download.php/3353/Npgsql2.0.12.0-bin-ms.net2.0.zip>
está
retornando erro de NpgsqlTypes.NpgsqlTypesHelper porem quando instalo o
framework 3.5 e erro não ocorre. Alguém tem alguma dica?
Obrigado.
Message: The type initializer for 'NpgsqlTypes.NpgsqlTypesHelper' threw an
exception. StackTrace: at
NpgsqlTypes.NpgsqlTypesHelper.CreateAndLoadInitialTypesMapping(NpgsqlConnector
conn)
at Npgsql.NpgsqlConnector.Open()
at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection
Connection)
at
Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection
Connection)
at Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection
Connection)
at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection
Connection)
at Npgsql.NpgsqlConnection.Open()
at GeralzaoDosTestes.Form1.button1_Click(Object sender, EventArgs e)
private void button1_Click(object sender, EventArgs e)
{
string conStr = "Server=192.168.0.240;Port=5432; User
Id=david;Password=12345;Database=teste;";
var conexao = new NpgsqlConnection {ConnectionString = conStr};
try
{
conexao.Open();
var comando = new NpgsqlCommand {Connection = conexao};
string sql = "SELECT * FROM configuracao";
comando.CommandText = sql;
var dr = (DbDataReader)comando.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
MessageBox.Show(dr["nome"].ToString());
}
}
dr.Close();
}
catch (NpgsqlException ex)
{
MessageBox.Show(String.Format("Message: {0} StackTrace: {1}
Source: {2} SQL: {3}", ex.Message, ex.StackTrace, ex.Source, ex.ErrorSql));
}
catch(Exception ex)
{
MessageBox.Show(String.Format("Message: {0} StackTrace: {1}
", ex.Message, ex.StackTrace));
}
finally
{
conexao.Close();
conexao.Dispose();
}
}
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
