Even in a Code First environment, you can call a stored procedure from a DbContext object. But it's a lot easier if you use the visual designer. I frequently get asked if Entity Framework (EF) in a ...

Note that it doesn't have to be one or the other; EF can import and use stored procedures for both select and insert/update/delete operations just fine.

I frequently get asked if Entity Framework (EF) in a Code First environment supports calling stored procedures. The short answer is: "In EF6 -- which works everywhere -- the answer is Yes." As I ...

Table-valued functions are an especially good match for ORMs. TVFs are far more flexible than normal stored procedures or views, but without dynamic SQL generation one cannot full advantage of them.