How to execute sql and return to a `MODEL` in ef core?

Question

I am using ef core 5.0 and want to execute a sql to return a list to a List<MyClass>

but the MyClass is not in the dbcontext's DbSet.

mysql is select newgroup,groupid from tmp

tmp is in DbSet,

public MyClass
{
 public int newgroup{get;set;}
 public int groupid{get;set;}
}

Answer 1

Hi 6666666,
You can try to use the FromSqlRaw extension method to begin a LINQ query based on a raw SQL query. FromSqlRaw can only be used on query roots, that is directly on the DbSet<>.
More details please refer to this document.
Best Regards,
Daniel Zhang

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.