In an earlier column, I showed how to call a stored procedure from Entity Framework without having to mess with connection and parameter objects (though you could mess with connection and parameter ...

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.

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.

Entity Framework 6 gives you a variety of ways to call stored procedures that return data and capture the results those procedures return. Here's a look at all of them.