public static DataTable GetDataTableFromQuery( string query, string connstr = "") { if (connstr == "") { connstr = ConnectionStrings["cnipdb"].ConnectionString; } GlobalTypeMapper.UseNetTopologySuite(); using (NpgsqlConnection con = new NpgsqlConnection(connstr)) using (NpgsqlDataAdapter da = new NpgsqlDataAdapter(query, con)) { DataSet ds = new DataSet(); da.Fill(ds); return(ds.Tables[0]); } }
public static void ExecuteNonQuery(string query, string connstr = "") { if (connstr == "") { connstr = ConnectionStrings["cnipdb"].ConnectionString; } GlobalTypeMapper.UseNetTopologySuite(); using (NpgsqlConnection con = new NpgsqlConnection(connstr)) using (NpgsqlCommand cmd = new NpgsqlCommand(query, con)) { con.Open(); cmd.CommandTimeout = 0; cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); con.Close(); } }