You can use Table-Valued Function in Entity Framework 5.I think the link will solve your question:
For using Table Value Function in Entity Framework you need to do the following steps:
1. Right-click the project name in Solution Explorer, point to Add, and then click New
Item.
2. Select Data from the left menu and then select ADO.NET Entity Data Model in the
Templates pane.
3. Enter TVFModel.edmx for the file name, and then click Add.
4. In the Choose Model Contents dialog box, select Generate from database, and then
click Next.
5. Click New Connection
Enter (localdb)\v11.0 in the Server name text box
Enter School for the database name
Click OK.
6. In the Choose Your Database Objects dialog box, under the Tables node, select the
Person, StudentGrade, and Course tables.
7. Select the GetStudentGradesForCourse function located under the Stored Procedures
and Functions node Note, that starting with Visual Studio 2012, the Entity Designer
allows you to batch import your Stored Procedures and Functions.
8. Click Finish.
9. The Entity Designer, which provides a design surface for editing your model, is
displayed. All the objects that you selected in the Choose Your Database Objects
dialog box are added to the model.
10. By default, the result shape of each imported stored procedure or function will
automatically become a new complex type in your entity model. But we want to map
the results of the GetStudentGradesForCourse function to the StudentGrade entity:
Right-click the design surface and select Model Browser
In Model Browser, select Function Imports, and then double-click the
GetStudentGradesForCourse function
In the Edit Function Import dialog box, select Entities and choose StudentGrade
You can use the following code to use Table-Value Function in the Application for retrieving data:
using (var context = new SchoolEntities())
{
var CourseID = 4022;
var Grade = 3.5M;
// Return all the best students in the Microeconomics class.
var students = from s in context.GetStudentGradesForCourse(CourseID)
where s.Grade >= Grade
select new
{
s.Person,
s.Course.Title
};
foreach (var result in students)
{
Console.WriteLine(
"Couse: {0}, Student: {1} {2}",
result.Title,
result.Person.FirstName,
result.Person.LastName);
}
}
