EF : Get table to List with out using stored procedure.
This is my code for grab data from table to List using stored procedure. My question is how I will grab data to List without using stored procedure ?
using ( CWPRTestEntities ctx=new CWPRTestEntities())
{
var qry = from okc_SelectCyclicalWorkOrdersGenerated_Result p in ctx.okc_SelectCyclicalWorkOrdersGenerated() select p;
List<okc_SelectCyclicalWorkOrdersGenerated_Result> myworkorders = qry.ToList();
foreach (okc_SelectCyclicalWorkOrdersGenerated_Result myworkerder in myworkorders)
{
//TO Do
}