I have a stored procedure that I am using through LINQ to SQL as a data source for a gridview. Rather than editing my stored procedure is there a way to use Linq to search the result set?
Dim DC As New DistributionDataContext
GridView1.DataSource = (DC.usp_GetInvestorData(GridView1.PageIndex, GridView1.PageSize, "InvestorName", Session("sort")))
GridView1.DataBind()