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