public static List <T> ExecuteQuery <T>(DatabaseEngine db, StoreCommand storeCommand)
{
DbCommand dbCmd = ConvertStoreCommandToDbCommand(db, storeCommand);
List <T> list = new List <T>();
using (IDataReader dr = db.ExecuteReader(dbCmd))
{
db.Load(typeof(T), list, dr);
}
return(list);
}
public IList ToList()
{
IList list = (IList)Activator.CreateInstance(typeof(List <>).MakeGenericType(TableMapping.ObjectType));
DatabaseEngine db = DatabaseEngineFactory.GetDatabaseEngine();
if (this.PageIndex == -1)
{
db.Load(this, list);
}
else
{
db.LoadPage(this, list);
}
return(list);
}
public object FirstOrDefault()
{
List <object> list = new List <object>();
DatabaseEngine db = DatabaseEngineFactory.GetDatabaseEngine();
int bakTakeCount = this.TakeCount;
try
{
this.TakeCount = 1;
db.Load(this, list);
}
finally
{
this.TakeCount = bakTakeCount;
}
return(list.FirstOrDefault());
}