fill controller from SQL Function in Entity Framework ?

Question

i have create an sql function in my database that take to Date params and get data from 5 tables.
after that add it to project as entity framework from database and the code generated is:

[DbFunction("Dr_EmploEntities", "SelectEmployee")]         public virtual IQueryable SelectEmployee(Nullable frm_date, Nullable to_date)         {             var frm_dateParameter = frm_date.HasValue ?                 new ObjectParameter("frm_date", frm_date) :                 new ObjectParameter("frm_date", typeof(DateTime));              var to_dateParameter = to_date.HasValue ?                 new ObjectParameter("to_date", to_date) :                 new ObjectParameter("to_date", typeof(DateTime));              return ((IObjectContextAdapter)this).ObjectContext.CreateQuery("[Dr_EmploEntities].[SelectEmployee](@frm_date, @to_date)", frm_dateParameter, to_dateParameter);         }          public DbSet SelectEmployee_Result { get; set; }

as you see i have now "SelectEmployee_Result" that don't take any params, and "SelectEmployee" that take two date params.

after that i have create an controller for "SelectEmployee_Result" class.
after that i run my project Index View that working with "SelectEmployee_Result" class give me err:

"The type 'SelectEmployee_Result' is mapped as a complex type. The Set method, DbSet objects, and DbEntityEntry objects can only be used with entity types, not complex types."

and i make breakpoint and see that "SelectEmployee_Result" has no data so i change the Index Code in controller and fill "SelectEmployee" with two date params
and when run got same err msg too.

so how can i fill "SelectEmployee_Result" from the beginning with data between two dates to let me use it in all views ?

all what i need here is view data i got i edit before saving it in database Like using DataTable but i need to do that from Entity with sql function

and what is difference between "SelectEmployee" that is my function name and that is need two params and "SelectEmployee_Result"?

Ahmed Amen · Answer

Hi i try it as: 1. create controller for SelectDayOff_Result with name SelectDayOff_ResultController. 2. add code in index action result as: var model = db.SelectDayOff(new DateTime(2014 12 01) new DateTime(2015 12 31)); return View(db.SelectDayOff_Result.ToList()); 3. when run still get the same err: Additional information: The type 'SelectDayOff_Result' is mapped as a complex type. The Set method DbSet objects and DbEntityEntry objects can only be used with entity types not complex types.

Anant Kulkarni · Answer

The  SelectEmployee_Result class is the result of the operation  SelectEmployee. So when you execute  SelectEmployee function the data from your SQL Server will automatically mapped to instance of  SelectEmployee_Result class. So you will get a strongly typed representation of SQL Server data. Hope this clears your doubt.