Use LINQ to SQL results inside SQL Server stored procedure
- by ifwdev
Note: I'm not trying to call a SQL Server stored proc using a L2SQL datacontext.
I use LINQPad for some fairly complex "reporting" that takes L2SQL output saved to an Array and is processed further.
For example, it's usually much easier to do multiple levels of grouping with LINQ to Objects instead of trying to optimize a T-SQL query to run in a reasonable amount of time.
What would be the easiest way to take the end result of one of these "applications" and use that in a SQL Server 2008 stored proc?
The idea is to use the data for a Reporting Services Report, rather than copying and pasting into Excel (manual labor). The reports need to be accessible on the report server (not using the Report Server control in an application).
I could output CSV and read that somehow via command line exec, but that seems like a hack. Thanks for your help.