Conexao Csharp com postgree

04/08/2022

Ol�, � a primeira vez que estou precisando conectar uma aplica�ao C#.net usando postgree.
Est� ocorrendo um erro no webconfig que nao consegui resolver.
Ja fiz algumas altera�oes que peguei na internet mas n funcionou.

Se alguem ja passou por isso e conseguiu resolver, pode me ajudar?

 

            string serverdb = "xx.xx.xx.xxx";
            string userdb = "meuUser";
            string passdb = "xxx@2022";
            string dbdb = "db_machine";
            string _connectionString = "Server=" + serverdb + ";Port=5432;UserID=" + userdb + ";password=" + passdb + ";Database=" + dbdb + ";";

            NpgsqlConnection conn = new NpgsqlConnection(_connectionString);

            try
            {
                conn.Open();
                string SQL = "SELECT * FROM MACHINE";
                NpgsqlDataAdapter da = new NpgsqlDataAdapter(SQL, conn);
                DataSet ds = new DataSet();
                da.Fill(ds, "machine_name");
                GridDados.DataSource = ds.Tables;
                GridDados.DataBind();
            }
            finally
            {
                conn.Close();
            }

Erro:

System.IO.FileNotFoundException: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=4.0.4.1, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.'

Jefferson

Curtir t�pico + 0

Responder

Posts

04/08/2022

Jefferson

 

            string serverdb = "xx.xx.xx.xxx";
            string userdb = "meuUser";
            string passdb = "xxx@2022";
            string dbdb = "db_machine";
            string _connectionString = "Server=" + serverdb + ";Port=5432;UserID=" + userdb + ";password=" + passdb + ";Database=" + dbdb + ";";

            NpgsqlConnection conn = new NpgsqlConnection(_connectionString);

            try
            {
                conn.Open();
                string SQL = "SELECT * FROM MACHINE";
                NpgsqlDataAdapter da = new NpgsqlDataAdapter(SQL, conn);
                DataSet ds = new DataSet();
                da.Fill(ds, "machine_name");
                GridDados.DataSource = ds.Tables;
                GridDados.DataBind();
            }
            finally
            {
                conn.Close();
            }

Galera, acabei de resolver:

instalei no pacote NuGet:
System.Runtime.CompilerServices.Unsafe

Responder

Gostei + 0