Click here to Skip to main content
15,897,704 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
XML
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;
}
Posted
Updated 26-Aug-13 19:02pm
v3
Comments
Zoltán Zörgő 26-Aug-13 12:33pm    
I think it is rather an EntityFramework related question, and has nothing to do with MVC...
Jameel VM 26-Aug-13 14:37pm    
Where is the code?

 
Share this answer
 
mkjgnjkk kmjmllpo jkkjnjmmmkl;,
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900