Entity Framework Core - Knowledge Base (KB)

SQL server view return different results in Entity Framework

I have a sql view in SQl server:...SELECT dbo.job.idJob, SUM(dbo.tracking.iQty) AS TotalOrdered, dbo.tracking.idProduct FROM dbo.tracking INNER JOIN dbo.job ON dbo.tracking.idJob = dbo.job.idJob GROUP BY dbo.trac...

Create DbQuery out of View table

I am trying to create a DbQuery of ExtendedStudent, from SQL View which was constructed form 2 diffrent tables (see code SQL below)....I have looked at the following posts:...Entity Framework Core Query Types... And ...EF Core 2.1 Query Types... Both have...