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 ...

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.