linq statements verify

Question

When using the visual studio.net 2010 ide, I have not found a way to debug linq statements. This would also include linq to sql statements. Can you tell me how to debug linq statements?What window(s) should I use to see all the values? are there special editors like 'xml editors', 'notepad' and/or other tools I can use to see the values in fields that the linq query is being executed at?

For exmple if i get an error that says 'invalid cast' operation. How can I tell what column(field) is being referred to?

Answer 1

We can put fields on report dynamically. For it we have to put formula-fields on report on design time.
We can put fields value from database in formula-fields in our c# coding.

For example AttendenceReport is crystal report having formula-field "status".

 AttendenceReport objAttendenceReport=new AttendenceReport();
//{AttendenceTable.Status} values coming from //database                               objAttendenceReport.DataDefinition.FormulaFields["Status"].Text = "{AttendenceTable.Status}";