Modern Data Access with Entity Framework Core: Database Programming Techniques for .NET, .NET Core, UWP, and Xamarin with C#

© Holger Schwichtenberg 2018

Holger SchwichtenbergModern Data Access with Entity Framework Core https://doi.org/10.1007/978-1-4842-3552-2_15

15. Reading and Modifying Data with SQL, Stored Procedures, and Table-Valued Functions

Holger Schwichtenberg¹ 

(1)

Essen, Germany

 

If LINQ and the Entity Framework Core API are not sufficient in terms of functionality or performance, you can send any SQL commands directly to the database, including invoking stored procedures and using table-value functions (TVFs).

LINQ and the Entity Framework Core API (Add(), Remove(), SaveChanges(), and so on) are abstractions of SQL. Entity Framework Core (or the respective database provider) converts LINQ and API calls to SQL. The abstraction that Entity Framework Core offers ...