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();
}
}
