I have a LinqDataSource which is configured to pull records from a table. When I bind a RadGrid to the LDS at design time, the columns from the table are visible in VS design view. Due to the security constraints of our environment, I need to bind to the output of stored procedures instead of binding directly to tables. I am able to do this at runtime by setting e.Result to the output of a method in the datacontext. Of course, this means that the columns returned by the stored proc are not shown in the RadGrid in VS design view.
Is it possible to specify a stored proc as the data source for a LinqDataSource and have the columns displayed in the RadGrid at design time?