List<CFLaborPayModel> LaborPayList=(from e in aCDC.SP_CFLaborPayment(dt,"")
aCDC.SP_CFLaborPayment(dt, "RCL6")
dt is a datetime variable.
and RCL6 is a string variable
I am trying to call stored procedure from my MVC 2 application.
but I am getting the following error.
could not find an implementation of the query pattern for source type 'int'. 'select' not found
but In my procedure I am returining data.
But I am getting int as return value.
Thanks in advance.
here is my code
ALPL_PORTALEntities _entities = new ALPL_PORTALEntities();
DateTime dt = Convert.ToDateTime(10 / 06 / 2013);
AlplClassesDataContext aCDC = new AlplClassesDataContext();
List<cflaborpaymodel> LaborPayList=(from e in aCDC.SP_CFLaborPayment(dt,"")
aCDC.SP_CFLaborPayment(dt, "RCL6")
select new CFLaborPayModel
{
GodownID = e.GodownId,
Contractor = e.contractor,
ActivityDate = e.Activity_Date,
Material = e.Material,
}).ToList();
return LaborPayList;
}