使用Npgsql串連Postgres

1.裝好Postgres

2.開啟遠端存取

配置postgresql.conf檔案

listen_addresses = '*' 

配置pg_hba.conf檔案

host    all         all         0.0.0.0/0          trust

3.下載npgsql 引用2個dll

4.code

 

  string strConn = ConfigurationManager.ConnectionStrings["npgsql"].ConnectionString;            var conn = new NpgsqlConnection(strConn);            string sql = "select * from test";            var dt = new DataTable();            var cmd = new NpgsqlDataAdapter(sql, conn);            cmd.Fill(dt);            foreach (DataRow row in dt.Rows)            {                Console.WriteLine(row["xxxx"].ToString());            }            conn.Close();            Console.Read();