Microsoft Reporting with LINQ to SQL

Question

I am developing an asp.net web application in which I am using LINQ to SQL and I want to generate the Microsoft Reports with LINQ to SQL. Microsoft Reports DataSource is Dataset but I want to give IEnumberable or IQueryable as a DataSource because I have no Dataset. Is there any way or better solution to generate report with out a dataset.

Thanks in advance

Regards

Answer 1

I don't believe that reporting really jives well with LINQ to SQL, since it's made to hit databases directly - I think you just have to bite the bullet and write your reports in SQL.