/// <summary> /// /// </summary> /// <param name="command"></param> /// <returns></returns> public virtual DataSet ExecuteDataSet(IDbCommand command) { PrepareCommand(command); IDbDataAdapter ad = SqlProvider.CreateDataAdapter(); ad.SelectCommand = command; var ds = new DataSet(); ad.Fill(ds); return(ds); }
/// <summary> /// /// </summary> /// <param name="command"></param> /// <returns></returns> public virtual DataTable ExecuteDataTable(IDbCommand command) { PrepareCommand(command); IDbDataAdapter ad = SqlProvider.CreateDataAdapter(); ad.SelectCommand = command; var ad2 = ad as DbDataAdapter; var dt = new DataTable(); ad2.Fill(dt); return(dt); }
public virtual DataRow ExecuteFirstDataRow(IDbCommand command) { DataRow dataRow = null; PrepareCommand(command); IDbDataAdapter ad = SqlProvider.CreateDataAdapter(); ad.SelectCommand = command; var ad2 = ad as DbDataAdapter; var dt = new DataTable(); ad2.Fill(0, 1, dt); if (dt.Rows.Count > 0) { dataRow = dt.Rows[0]; } return(dataRow); }