Azavea.NijPredictivePolicing.Common.DB.DataClient.GetMagicTable C# (CSharp) Method

GetMagicTable() public static method

'Magically' populates a DataTable object with the contents of your sql query
public static GetMagicTable ( DbConnection conn, IDataClient client, string sql ) : DataTable
conn System.Data.Common.DbConnection
client IDataClient
sql string
return System.Data.DataTable
        public static DataTable GetMagicTable(DbConnection conn, IDataClient client, string sql)
        {
            DataTable dt = new DataTable();

            try
            {
                var cmd = client.GetCommand(sql, conn);
                var dba = client.GetDataAdapter(cmd);

                dba.Fill(dt);

                return dt;
            }
            catch (Exception ex)
            {

                _log.Error("error during select", ex);
            }

            return null;
        }