I use a number of different tools to support my development and research activities.  Typically, I just state the tools that I use to complete a given tasks. 

My process for development starts by using a whiteboard and Visio to design the system (UI, workflow, db).  I bring up SSMS to “work” my tables and data – run a few use cases on the structure/data.  Once I understand and have firmed up the db, I fire up VS to start development. 

I’m just getting into LINQ and LINQ to Entities.  I was introduced to a tool from a colleague called: LINQPad.  The tool has made me reevaluate my process.  Why?  LINQPad allows me to integrate my SSMS and VS task, much earlier in the process. 

For example, I’m working on my sensor deployment research project – tables defined with sample data in the db.  With LINQPad, I can start with SQL and LINQ statements in the same tool; with auto-completion!  Forget the C# scratchpad console project – quickly test your LINQ statements in LINQPad and get the additional benefit of the results window (like SSMS).  You can add connections to databases directly and add connections to your Entity Frameworks.

Visibility – LINQPad allows me to “work” my solutions more efficiently and gives me a tool to see what LINQ code is executing (great for debugging and maintenance tasks).  Give it at try.  The tool is free – for auto-completion you need to purchase – just $19.00 - Promotion, Ends November 30.

LINQPad = SSMS + VS

Thank You for listening.