In documentation of Entity Framework: https://www.entityframeworktutorial.net/querying-entity-graph-in-entity-framework.aspx in section regarding GroupBy we can read that following code: executes internally following SQL: Why there is no GroupBy clause in SQL? If there is no GroupBy clause needed, can’t we just use simple Select with OrderBy and without Joins? Can anyone explain the above query? Answer The bottom line is: because SQL can’t
Tag: entity-framework-6
EF6 Stored Procedure does not accept parameters
I am using EF6 and I need to execute stored procedure. It takes two parameters: mIIN varchar(12), which is input string mXMLOutput varchar(max), which is the result of execution It works fine when I call it from Management Studio. However, when I use the following code: which results in the error Procedure or function ‘GetInfo’ expects parameter ‘@mIIN’, which was