/// <summary>
/// Execute DataTable
/// </summary>
/// <param name="conn"></param>
/// <param name="cmdText"></param>
/// <returns></returns>
public static DataTable ExecuteDataTable(this NpgsqlConnection conn, string cmdText)
{
conn.CheckNull(nameof(conn));
return(conn.ExecuteDataTable(cmdText, null, CommandType.Text, null));
}
/// <summary>
/// Execute DataTable
/// </summary>
/// <param name="conn"></param>
/// <param name="cmdText"></param>
/// <param name="commandType"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public static DataTable ExecuteDataTable(this NpgsqlConnection conn, string cmdText, CommandType commandType, NpgsqlTransaction transaction)
{
conn.CheckNull(nameof(conn));
return(conn.ExecuteDataTable(cmdText, null, commandType, transaction));
}
/// <summary>
/// Execute DataTable
/// </summary>
/// <param name="conn"></param>
/// <param name="cmdText"></param>
/// <param name="parameters"></param>
/// <param name="commandType"></param>
/// <returns></returns>
public static DataTable ExecuteDataTable(this NpgsqlConnection conn, string cmdText, NpgsqlParameter[] parameters, CommandType commandType)
{
conn.CheckNull(nameof(conn));
return(conn.ExecuteDataTable(cmdText, parameters, commandType, null));
}