Even with its advanced features, Entity Framework Core aims to cover the most commonly needed features provided by database servers. But, knowing that this won’t be enough for some projects, Microsoft has also included support for working directly with the database server, which can be invaluable if your project has specialized requirements or if you are modeling a complex database.
In this chapter, I demonstrate how to use SQL directly to access features that Entity Framework Core doesn’t support directly, including views, stored procedures, and table-valued functions. ...