FromSqlRaw won't work in Application about northwindtraders HOT 2 CLOSED

Hi @SuliemanMansouri
First of all - read this article https://stackoverflow.com/questions/35631903/raw-sql-query-without-dbset-entity-framework-core
How to use RawSQL in EF Core. It depends on the used EF Core version.

Official docs for the latest Ef Core version.
https://docs.microsoft.com/en-us/dotnet/api/microsoft.entityframeworkcore.relationalqueryableextensions.fromsql?view=efcore-3.1

What EF Core version do you use? And could you please show the code?

About LINQ or RawSQL - both work fine with 10 rows. You need more data to see the actual execution plan.

Why do we need the Interfaces inside the Application project?

It is a very good question!
I believe better to move interfaces to separate project and architecture layer.
And add a project which "implements" these interfaces.
And "use" these interfaces from the Application layer (and project).
It is Dependency Inversion principle in practice :)

from northwindtraders.

Hi, @AndreiTsvettsikh
I was adamant on using Raw SQL using Context.Database, the way I used to do it in EF6. That's what happens when trying to code after 3:00 am in the morning.
Using FromSQL on entities DBSets works fine with keyless entities.
Thanks @AndreiTsvettsikh for pointing which EF Core version I am using.

from northwindtraders.