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