GROUP BY WEEK EF Core 2.1

How to group by week in Entity Framework Core?

It is possible to make use of the datepart SQL function by wrapping it with the DbFunctionAttribute. Tricky part is to tell ef core not to handle the datepart type parameter as a string. Example:...DbContext:...public int? DatePart(string datePartArg, DateTime? date) => throw new Exception(); public void OnModelCreating(DbModelBuilder modelBuilder...

Group By week - Entity Framework Core

EF Core 2.0 doesn't implement GROUP BY. ...You can use FromSql to ...execute a raw SQL query... and map it to an entity, or you can create a VIEW and map it to an entity as if it were a table, eg :...class BlogPostCount { public int BlogID{get;set;} public int Count {get;set;} } var query = "SELECT BlogID,Count(*) as Count from B...

EF Core 2.1 evaluates locally when subquery and aggregate after Grouping

The first rule to follow is to avoid ...Where... and predicate version of ...Count... on ...GroupBy... result and use the conditional ...Sum... where possible. EF6 was able to translate such constructs, but with very inefficient SQL....So in general you need to rewrite the query like this:...data .GroupBy(i => new { i.Status, i.InvoiceType }) ...

.NET Core 2.1 and EF Framework 2.1

Despite the short-sited nature of .NET Core applications being hosted by IIS as a proxy front end, it appears that the AppPool running the IIS Proxy requires access to the same database server that the SQL Account used for the database requires... YUCK! ...Thanks to Edward (who posted a comment), it led me to this post:...https://weblog.west-wind.c...

EF Core 2.1 GROUP BY and select first item in each group

In EF Core 2.1 GroupBy LINQ operator only support translating to the SQL GROUP BY clause in most common cases. Aggregation function like sum, max ......linq-groupby-translation...You can until full support group by in EF Core use ...Dapper

.Net Core 2.1 EF Core Null Reference Exception when searching database with Where linq query

Turns out my Engine table had CompanyId instead of Company. All I had to do was change it to:...var context = _context.Engine .Include(e => e.EngineType) .Where(e => e.CompanyId == user.CompanyId);

Best way to coordinate atomic transactions between different business services in .NET Core / EF Core 2.1?

If your transaction extend across service boundaries that is so called ...Transactional integration antipattern.... ...One way to coupe with that issue is to use external orchestration service (for example ...Camunda...). It's responsibility would be to handle business flow and do some compensation actions on failure. It wouldn't be totally "transa...

Entity Framework Core 2.1 group by not working properly

I learnt that EF Core not supporting database level Group By and take element. But, by EF Core 2.1, came support for group by then sum,min,max,average at databse level.(You can see from this link ...https://docs.microsoft.com/en-us/ef/core/what-is-new/ef-core-2.1#linq-groupby-translation... from commented by @jpgrassi) ...So, I changed my query cod...

How to Use EF Core 2.2.4 Data Library With Asp.Net Core 2.1 Project

The version of EF Core is tightly coupled with the version of ASP.NET Core you're using. Basically: EF Core 2.2.x only works on ASP.NET Core 2.2.x. You'll need to update the ...TargetFramework... to ...netcoreapp2.2... to make it work....Also, the recommended way to reference ASP.NET Core (in .NET Core 2.x projects) is to not include a specific ver...

EF Core 2.1 Linq Query to EF Core 3.0

ok, i figured it out....here is my new code that works.... query = query.Where(x => x.Items.Where(o => o.BinItem != null && o.BinItem.Bin != null && o.BinItem.Bin.Zone != null ...