.NET: Entity Framework Async Query to Count Number of Rows

The following will count all rows in the Posts table (or whatever table you want or map Posts to). The function is marked as async so it returns a Task and awaits the CountAsync method.

copy

public async Task<int> Count()
{
	var query = from posts in this._DbContext.Posts

				select posts.Id;

	return await query.CountAsync();
}