public static async Task <T> FirstOrDefaultNoLockAsync <T>(this IOrderedQueryable <T> query, Expression <Func <T, bool> > predicate) { using ( var scope = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions() { IsolationLevel = IsolationLevel.ReadUncommitted }, TransactionScopeAsyncFlowOption.Enabled)) { var toReturn = await query.FirstOrDefaultAsync(predicate); scope.Complete(); return(toReturn); } }
public static async Task <CarModel> FindModelByIdAsync(this IOrderedQueryable <CarModel> models, int id) { CarModel carModel = await models.FirstOrDefaultAsync(cm => cm.Id == id); return(carModel); }
public static async Task <Car> FindCarByIdAsync(this IOrderedQueryable <Car> cars, int id) { return(await cars.FirstOrDefaultAsync(c => c.Id == id)); }
internal static async Task <CarColor> FindColorByIdAsync(this IOrderedQueryable <CarColor> colors, int id) { return(await colors.FirstOrDefaultAsync(c => c.Id == id)); }
public static async Task <CarBrand> FindBrandByIdAsync(this IOrderedQueryable <CarBrand> brands, int id) { return(await brands.FirstOrDefaultAsync(b => b.Id == id)); }
public async Task <T> SingleAsync(IOrderedQueryable <T> queryable) => await queryable.FirstOrDefaultAsync();