public TFSEntity FirstOrDefault(string where) { using (var dataContext = new FSDataContext <TFSEntity>(_provider)) { return(dataContext.GetFetchNext(where) .FirstOrDefault()); } }
public async Task <TFSEntity> FirstOrDefaultAsync(string where) { using (var dataContext = new FSDataContext <TFSEntity>(_provider)) { return(await Task.FromResult(dataContext.GetFetchNext(where) .FirstOrDefault())); } }
public virtual Task <IEnumerable <TFSEntity> > GetAsync( string where = "", string orderBy = "", int?offset = null, int?limit = null, int?loadSize = null) { using (var dataContext = new FSDataContext <TFSEntity>(_provider)) { var query = dataContext.GetFetchNext(where, orderBy, offset, limit); if (loadSize.HasValue) { query = query.TakeWhile((t, index) => index < loadSize); } return(Task.FromResult(query.ToList().AsEnumerable())); } }
public virtual IEnumerable <TFSEntity> Get( string where = "", string orderBy = "", int?offset = null, int?limit = null, int?loadSize = null) { using (var dataContext = new FSDataContext <TFSEntity>(_provider)) { var query = dataContext.GetFetchNext(where, orderBy, offset, limit); if (loadSize.HasValue) { query = query.TakeWhile((t, index) => index <= loadSize); } foreach (var o in query) { yield return(o); } } }