Crystal Reports and LINQ

Question

Has anyone figured out how to use Crystal Reports with Linq to SQL?

Answer 1

I don't believe you can without converting your Linq2SQL data into a DataSet.

Answer 2

Altough I haven't tried it myself it seems to be possible by using a combination of DataContext.LoadOptions to make it eager to accept relations and GetCommand(IQueryable) to return a SQLCommand object that preserves relations.

See more info on MSDN Forums.

Answer 3

The msdn doc's suggest that you can bind a Crystal Report to an ICollection.

Might I recommend a List(T) ?

Answer 4

Try this link: MSDN

Answer 5

try This i think this is your answer: How to use LINQ to SQL for binding data in CrystalReports 2008