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

hi,

I am not sure but in this case LINQPad may help you to debug Linq query.
http://www.linqpad.net/

Also refer below link it might help you.
http://weblogs.asp.net/scottgu/archive/2007/07/31/linq-to-sql-debug-visualizer.aspx
http://blogs.msdn.com/b/ericwhite/archive/2008/11/07/debugging-linq-queries.aspx

hope this will help you.