ALTER PROCEDURE [dbo].[GetMealOrders] ( @clientid int, @PageNumber int, @PageSize int ) AS BEGIN DECLARE @DeliveryTypes varchar(2000) SET @DeliveryTypes = '' SELECT ...
Linq over SQL does a pretty good job of optimising the data returned, and what tends to happen with SPs (having a few SPs that return the world because they're called in a few slightly different ways ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results