There is a great tool which is the “Management Studio” equivalent for LINQ. It allows you to build your queries just like you would for SQL, without the need for you to do a lot of setup work trying to test in development code.
There’s support for LINQ to SQL, LINQ to Objects and LINQ to Xml, so it has it all.
For me, the best part is that when you’re building your query, you get that instant feedback on your results. Better still, you can view the results of your query in SQL! For old Sql hats like myself, this is quite comforting 
Advertisement
