Using EF.Functions.Count without arguments (`COUNT(*)`)

[InspiringCode]

Is there any way I could write a query that results in SELECT X, COUNT(*) OVER() TotalCount FROM y?

I tried EF.Functions(1, EF.Functions.Over()) and EF.Functions(new { One = 1 }, EF.Functions.Over()) and a few other variants but they all throw an exception. Would it be possible to provide an overload of Count that takes no query parameters and just produces COUNT(*) in this case?

[virzak]

Yeah, should be able to do that soon. In the meantime you can insert any non nullable column. If all your columns are nullable you can do this;

var query = DbContext.TestRows
.Select(r => EF.Functions.Count<int, TResult>(r.Col1 == null ? 1 : 1, EF.Functions.Over()));

[virzak]

@InspiringCode, this is available starting version 8.0.18-beta