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

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.