Hello,
I have created a WCF service using stored procedure.
[WebGet]
public List<View_JobAssign> AssignJobs(string employeeId, string assignDate, string jobs, string userId)
{
try
{
TrackerEntities entities = new TrackerEntities();
return entities.AssignJobs(Convert.ToDateTime(assignDate), Convert.ToInt32(employeeId), jobs, Convert.ToInt32(userId)).ToList();
}
catch (Exception ex)
{
throw new DataServiceException(ex.Message + ex.InnerException);
}
}
The data which I pass to above service is
employeeId = 1, assignDate = "2017-02-22", Jobs="1,2,3", userid = 1
and it works like charm.
But the problem is when I try to pass Jobs = '1,2,....10000' i.e upto 10000 which makes a long string then I get HTTP request Failed Error.
How do I pass data to stored procedure created service with long data?
is there any alternative?
What I have tried:
I tried to use reflection provider with Entity Framework but it doesn't work.