I add a stored proc to my DBML file accepting two parameters. I try to write some code to return the data but get an error
public IQueryable<spGetCustomerOrders> AllCustomerOrders(int Id, int CategoryID)
{
return myDataContext.spGetCustomerOrders(Id, CategoryID).AsQueryable();
}
This returns the error
The type or namespace name 'spGetCustomerOrders' could not be found (are you missing a using directive or an assembly reference?) .
Im not sure what im doing wrong as all ive done is dragged a SP into the DBML file and then tried adding code so it can be used across my site?
Go to the complete details ...