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?