public async Task Entities_LongCountAsync_Predicate_Args()
{
const string search = "a";
//Arrange
var blog1 = new Blog {
Name = "blog a", BlogId = 1000, Created = DateTime.Now
};
var blog2 = new Blog {
Name = "blog b", BlogId = 3000, Created = DateTime.Now
};
_context.Blogs.Add(blog1);
_context.Blogs.Add(blog2);
_context.SaveChanges();
Expression <Func <Blog, bool> > predicate = b => b.Name.Contains(search);
#if EFCORE
var expected = await EntityFrameworkQueryableExtensions.LongCountAsync(_context.Blogs, predicate);
#else
var expected = await QueryableExtensions.LongCountAsync(_context.Blogs, predicate);
#endif
//Act
long result = await(_context.Blogs as IQueryable).LongCountAsync("Name.Contains(@0)", search);
//Assert
Assert.Equal(expected, result);
}
public Task <long> LongCountAsync <TSource>(IQueryable <TSource> source, Expression <Func <TSource, bool> > predicate, CancellationToken cancellationToken = default(CancellationToken))
{
return(EntityFrameworkQueryableExtensions.LongCountAsync(source, predicate, cancellationToken));
}
public async Task Extension_methods_validate_arguments()
{
// ReSharper disable AssignNullToNotNullAttribute
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.FirstAsync <int>(null));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.FirstAsync <int>(null, s => true));
await ArgumentNullTest("predicate", () => Source().FirstAsync(null));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.FirstOrDefaultAsync <int>(null));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.FirstOrDefaultAsync <int>(null, s => true));
await ArgumentNullTest("predicate", () => Source().FirstOrDefaultAsync(null));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.SingleAsync <int>(null));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.SingleAsync <int>(null, s => true));
await ArgumentNullTest("predicate", () => Source().SingleAsync(null));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.SingleOrDefaultAsync <int>(null));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.SingleOrDefaultAsync <int>(null, s => true));
await ArgumentNullTest("predicate", () => Source().SingleOrDefaultAsync(null));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.ContainsAsync(null, 1));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.ContainsAsync(null, 1, new CancellationToken()));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.AnyAsync <int>(null));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.AnyAsync <int>(null, s => true));
await ArgumentNullTest("predicate", () => Source().AnyAsync(null));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.AllAsync <int>(null, s => true));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.AllAsync <int>(null, s => true, new CancellationToken()));
await ArgumentNullTest("predicate", () => Source().AllAsync(null));
await ArgumentNullTest("predicate", () => Source().AllAsync(null, new CancellationToken()));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.CountAsync <int>(null));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.CountAsync <int>(null, s => true));
await ArgumentNullTest("predicate", () => Source().CountAsync(null));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.LongCountAsync <int>(null));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.LongCountAsync <int>(null, new CancellationToken()));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.LongCountAsync <int>(null, s => true));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.LongCountAsync <int>(null, s => true, new CancellationToken()));
await ArgumentNullTest("predicate", () => Source().LongCountAsync(null));
await ArgumentNullTest("predicate", () => Source().LongCountAsync(null, new CancellationToken()));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.MinAsync <int>(null));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.MinAsync <int>(null, new CancellationToken()));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.MinAsync <int, bool>(null, s => true));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.MinAsync <int, bool>(null, s => true, new CancellationToken()));
await ArgumentNullTest("selector", () => Source().MinAsync <int, bool>(null));
await ArgumentNullTest("selector", () => Source().MinAsync <int, bool>(null, new CancellationToken()));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.MaxAsync <int>(null));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.MaxAsync <int>(null, new CancellationToken()));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.MaxAsync <int, bool>(null, s => true));
await ArgumentNullTest("source", () => EntityFrameworkQueryableExtensions.MaxAsync <int, bool>(null, s => true, new CancellationToken()));
await ArgumentNullTest("selector", () => Source().MaxAsync <int, bool>(null));
await ArgumentNullTest("selector", () => Source().MaxAsync <int, bool>(null, new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <int>)null).SumAsync());
await ArgumentNullTest("source", () => ((IQueryable <int?>)null).SumAsync());
await ArgumentNullTest("source", () => ((IQueryable <long>)null).SumAsync());
await ArgumentNullTest("source", () => ((IQueryable <long?>)null).SumAsync());
await ArgumentNullTest("source", () => ((IQueryable <float>)null).SumAsync());
await ArgumentNullTest("source", () => ((IQueryable <float?>)null).SumAsync());
await ArgumentNullTest("source", () => ((IQueryable <double>)null).SumAsync());
await ArgumentNullTest("source", () => ((IQueryable <double?>)null).SumAsync());
await ArgumentNullTest("source", () => ((IQueryable <decimal>)null).SumAsync());
await ArgumentNullTest("source", () => ((IQueryable <decimal?>)null).SumAsync());
await ArgumentNullTest("source", () => ((IQueryable <int>)null).SumAsync(i => 0));
await ArgumentNullTest("source", () => ((IQueryable <int>)null).SumAsync(i => 0, new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <int?>)null).SumAsync(i => 0));
await ArgumentNullTest("source", () => ((IQueryable <int?>)null).SumAsync(i => 0, new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <long>)null).SumAsync(i => 0));
await ArgumentNullTest("source", () => ((IQueryable <long>)null).SumAsync(i => 0, new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <long?>)null).SumAsync(i => 0));
await ArgumentNullTest("source", () => ((IQueryable <long?>)null).SumAsync(i => 0, new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <float>)null).SumAsync(i => 0));
await ArgumentNullTest("source", () => ((IQueryable <float>)null).SumAsync(i => 0, new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <float?>)null).SumAsync(i => 0));
await ArgumentNullTest("source", () => ((IQueryable <float?>)null).SumAsync(i => 0, new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <double>)null).SumAsync(i => 0));
await ArgumentNullTest("source", () => ((IQueryable <double>)null).SumAsync(i => 0, new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <double?>)null).SumAsync(i => 0));
await ArgumentNullTest("source", () => ((IQueryable <double?>)null).SumAsync(i => 0, new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <decimal>)null).SumAsync(i => 0));
await ArgumentNullTest("source", () => ((IQueryable <decimal>)null).SumAsync(i => 0, new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <decimal?>)null).SumAsync(i => 0));
await ArgumentNullTest("source", () => ((IQueryable <decimal?>)null).SumAsync(i => 0, new CancellationToken()));
await ArgumentNullTest("selector", () => Source <int>().SumAsync((Expression <Func <int, int> >)null));
await ArgumentNullTest("selector", () => Source <int?>().SumAsync((Expression <Func <int?, int> >)null));
await ArgumentNullTest("selector", () => Source <long>().SumAsync((Expression <Func <long, int> >)null));
await ArgumentNullTest("selector", () => Source <long?>().SumAsync((Expression <Func <long?, int> >)null));
await ArgumentNullTest("selector", () => Source <float>().SumAsync((Expression <Func <float, int> >)null));
await ArgumentNullTest("selector", () => Source <float?>().SumAsync((Expression <Func <float?, int> >)null));
await ArgumentNullTest("selector", () => Source <double>().SumAsync((Expression <Func <double, int> >)null));
await ArgumentNullTest("selector", () => Source <double?>().SumAsync((Expression <Func <double?, int> >)null));
await ArgumentNullTest("selector", () => Source <decimal>().SumAsync((Expression <Func <decimal, int> >)null));
await ArgumentNullTest("selector", () => Source <decimal?>().SumAsync((Expression <Func <decimal?, int> >)null));
await ArgumentNullTest("source", () => ((IQueryable <int>)null).AverageAsync());
await ArgumentNullTest("source", () => ((IQueryable <int>)null).AverageAsync(new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <int?>)null).AverageAsync());
await ArgumentNullTest("source", () => ((IQueryable <int?>)null).AverageAsync(new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <long>)null).AverageAsync());
await ArgumentNullTest("source", () => ((IQueryable <long>)null).AverageAsync(new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <long?>)null).AverageAsync());
await ArgumentNullTest("source", () => ((IQueryable <long?>)null).AverageAsync(new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <float>)null).AverageAsync());
await ArgumentNullTest("source", () => ((IQueryable <float>)null).AverageAsync(new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <float?>)null).AverageAsync());
await ArgumentNullTest("source", () => ((IQueryable <float?>)null).AverageAsync(new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <double>)null).AverageAsync());
await ArgumentNullTest("source", () => ((IQueryable <double>)null).AverageAsync(new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <double?>)null).AverageAsync());
await ArgumentNullTest("source", () => ((IQueryable <double?>)null).AverageAsync(new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <decimal>)null).AverageAsync());
await ArgumentNullTest("source", () => ((IQueryable <decimal>)null).AverageAsync(new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <decimal?>)null).AverageAsync());
await ArgumentNullTest("source", () => ((IQueryable <decimal?>)null).AverageAsync(new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <int>)null).AverageAsync(i => 0));
await ArgumentNullTest("source", () => ((IQueryable <int>)null).AverageAsync(i => 0, new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <int?>)null).AverageAsync(i => 0));
await ArgumentNullTest("source", () => ((IQueryable <int?>)null).AverageAsync(i => 0, new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <long>)null).AverageAsync(i => 0));
await ArgumentNullTest("source", () => ((IQueryable <long>)null).AverageAsync(i => 0, new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <long?>)null).AverageAsync(i => 0));
await ArgumentNullTest("source", () => ((IQueryable <long?>)null).AverageAsync(i => 0, new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <float>)null).AverageAsync(i => 0));
await ArgumentNullTest("source", () => ((IQueryable <float>)null).AverageAsync(i => 0, new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <float?>)null).AverageAsync(i => 0));
await ArgumentNullTest("source", () => ((IQueryable <float?>)null).AverageAsync(i => 0, new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <double>)null).AverageAsync(i => 0));
await ArgumentNullTest("source", () => ((IQueryable <double>)null).AverageAsync(i => 0, new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <double?>)null).AverageAsync(i => 0));
await ArgumentNullTest("source", () => ((IQueryable <double?>)null).AverageAsync(i => 0, new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <decimal>)null).AverageAsync(i => 0));
await ArgumentNullTest("source", () => ((IQueryable <decimal>)null).AverageAsync(i => 0, new CancellationToken()));
await ArgumentNullTest("source", () => ((IQueryable <decimal?>)null).AverageAsync(i => 0));
await ArgumentNullTest("source", () => ((IQueryable <decimal?>)null).AverageAsync(i => 0, new CancellationToken()));
await ArgumentNullTest("selector", () => Source <int>().AverageAsync((Expression <Func <int, int> >)null));
await ArgumentNullTest("selector", () => Source <int>().AverageAsync((Expression <Func <int, int> >)null, new CancellationToken()));
await ArgumentNullTest("selector", () => Source <int?>().AverageAsync((Expression <Func <int?, int> >)null));
await ArgumentNullTest("selector", () => Source <int?>().AverageAsync((Expression <Func <int?, int> >)null, new CancellationToken()));
await ArgumentNullTest("selector", () => Source <long>().AverageAsync((Expression <Func <long, int> >)null));
await ArgumentNullTest("selector", () => Source <long>().AverageAsync((Expression <Func <long, int> >)null, new CancellationToken()));
await ArgumentNullTest("selector", () => Source <long?>().AverageAsync((Expression <Func <long?, int> >)null));
await ArgumentNullTest("selector", () => Source <long?>().AverageAsync((Expression <Func <long?, int> >)null, new CancellationToken()));
await ArgumentNullTest("selector", () => Source <float>().AverageAsync((Expression <Func <float, int> >)null));
await ArgumentNullTest("selector", () => Source <float>().AverageAsync((Expression <Func <float, int> >)null, new CancellationToken()));
await ArgumentNullTest("selector", () => Source <float?>().AverageAsync((Expression <Func <float?, int> >)null));
await ArgumentNullTest("selector", () => Source <float?>().AverageAsync((Expression <Func <float?, int> >)null, new CancellationToken()));
await ArgumentNullTest("selector", () => Source <double>().AverageAsync((Expression <Func <double, int> >)null));
await ArgumentNullTest("selector", () => Source <double>().AverageAsync((Expression <Func <double, int> >)null, new CancellationToken()));
await ArgumentNullTest("selector", () => Source <double?>().AverageAsync((Expression <Func <double?, int> >)null));
await ArgumentNullTest("selector", () => Source <double?>().AverageAsync((Expression <Func <double?, int> >)null, new CancellationToken()));
await ArgumentNullTest("selector", () => Source <decimal>().AverageAsync((Expression <Func <decimal, int> >)null));
await ArgumentNullTest("selector", () => Source <decimal>().AverageAsync((Expression <Func <decimal, int> >)null, new CancellationToken()));
await ArgumentNullTest("selector", () => Source <decimal?>().AverageAsync((Expression <Func <decimal?, int> >)null));
await ArgumentNullTest("selector", () => Source <decimal?>().AverageAsync((Expression <Func <decimal?, int> >)null, new CancellationToken()));
// ReSharper restore AssignNullToNotNullAttribute
}
/// <inheritdoc cref="EntityFrameworkQueryableExtensions.LongCountAsync{TSource}(IQueryable{TSource}, Expression{Func{TSource, bool}}, CancellationToken)"/>
public static Task <long> LongCountAsyncEF <TSource>(
this IQueryable <TSource> source,
Expression <Func <TSource, bool> > predicate,
CancellationToken cancellationToken = default)
=> EntityFrameworkQueryableExtensions.LongCountAsync(source, predicate, cancellationToken);
public Task <long> LongCountAsync <TSource>(
IQueryable <TSource> source,
CancellationToken cancellationToken = default) =>
EntityFrameworkQueryableExtensions.LongCountAsync(source, cancellationToken);
/// <inheritdoc cref="EntityFrameworkQueryableExtensions.LongCountAsync{TSource}(IQueryable{TSource}, Expression{Func{TSource, bool}}, CancellationToken)"/>
public Task <long> LongCountAsync <TSource>(
IQueryable <TSource> source,
Expression <Func <TSource, bool> > predicate,
CancellationToken token)
=> EntityFrameworkQueryableExtensions.LongCountAsync(source, predicate, token);
public Task <long> LongCountAsync <T>(IQueryable <T> query)
{
return(EntityFrameworkQueryableExtensions.LongCountAsync(query));
}
public Task <long> LongCountAsync <T>(IQueryable <T> query, Expression <Func <T, bool> > predicate)
{
return(EntityFrameworkQueryableExtensions.LongCountAsync(query, predicate));
}
public async Task <long> LongCountAsync()
{
var shardingCounts = await GetGenericMergeEngine(async queryable => await EntityFrameworkQueryableExtensions.LongCountAsync((IQueryable <T>)queryable));
return(shardingCounts.Sum());
}
public static Task <long> LongCountAsyncEF <TSource>(
this IQueryable <TSource> source,
CancellationToken token = default)
=> EntityFrameworkQueryableExtensions.LongCountAsync(source, token);