8

A member of my team recently moved to LinqPad as his primary query tool (still will use SQL Studio at times) for the simple purpose of forcing himself to make using LINQ more natural to use. I thought this was a pretty good idea and am considering asking the rest of my team to make this switch. Does anyone have any thoughts / ideas on taking this approach?

Early questions I had...

  1. I feel being able to write good ANSI SQL is critical for a LOB developer. Since LINQ is a Microsoft thing, is the skills they will learn in LINQ worth the sacrifice in fully developing their ANSI SQL techniques, particularly if (when) they move on to other jobs/duties later in life. Developer development (inside and outside of company) is extremely important to me.

  2. Are there any features in SQL Studio that will be sorely missed in LinqPad?

  3. Does LinqPad have long term life? In other words, does everyone feel that LinqPad is a product that will continue to grow as .NET and SQL grows?

Cody C
  • 4,757
  • 3
  • 29
  • 36
  • 6
    I'm certainly committed to developing LINQPad. There's already a Framework 4.0 build, and plenty of new features are scheduled in the coming months. Joe (LINQPad author) – Joe Albahari Aug 06 '09 at 05:31
  • Great to hear. It's nice hearing commitment from the developers themselves. Keep up the good work. So far I've been pretty impressed. – Cody C Aug 06 '09 at 18:49
  • Using LINQPad in conjunction with SQL Server Management Studio is the better idea. Exclusive use of just one for the sake of learning LINQ is overkill. – Jagd Apr 01 '11 at 17:12

2 Answers2

6

Are there any features in SQL Studio that will be sorely missed in LinqPad?

Does LinqPad Show Estimated Execution Plan ?

Amy B
  • 108,202
  • 21
  • 135
  • 185
  • 6
    If you click the SQL tab in LINQPad, there's a button to open the SQL translation directly in SQL Management Studio. From there, it's usually just one click to get the execution plan. – Joe Albahari Aug 06 '09 at 05:32
  • That's a handy button. It practically renders his second question moot. – Amy B Aug 06 '09 at 13:31
  • 5
    @DavidB: I just released LINQPad plugin which shows query plan and missing indexes inside LINQPad: http://www.aboutmycode.com/miscellaneous/introducing-linqpad-queryplanvisualizer/ – Giorgi Mar 16 '16 at 18:13
3

As a way of drilling LINQ into yourself LINQPad is great, and if as a developer you're planning on staying within the Microsoft ecology, then that's probably a good thing.

Yes, there are a number of things you can't do in LINQ that you might need another tool for, whether that's SQL Management Studio or Visual Studio, however as you can drop down to SQL in the language some of these are mitigated if you can remember the SQL for it:

  1. Create new tables
  2. Modify existing tables
  3. Create SQL Agent Jobs
  4. Import/Export data

Obviously these are mostly "management" activities.

While LINQPad won't give you the execution plan, it will give you the SQL that is going to be run.

Zhaph - Ben Duguid
  • 26,785
  • 5
  • 80
  • 117
  • 1
    Actually, you can create new tables in LINQPad just fine. There's actually an included sample that sets up the part of the Northwind schema. There's also an export to Excel, which isn't the same as export to SQL, but you still can export. – J Wynia May 27 '10 at 15:56
  • @j-wynia - yes, which uses SQL, not LINQ, which is what I said - "however as you can drop down to SQL in the Language some of these are mitigated if you can remember the SQL" ;) But I know I don't do enough DBA work to remember off the top of my head the SQL for creating an index on a table, or setting up backups, etc, that are very easy to do in SMS, and I still can't import data that way. Have too admit I'd not noticed the Export to Excel feature, that's quite handy though. – Zhaph - Ben Duguid May 27 '10 at 19:09