Execute LINQ generated SQL in SSMS

Question

I use the LINQ DataContext's Log property to send the generatated SQL to the debug window. (There is a post by Kris Vandermotten about that). That works fine, except that the ouputted SQL parameters are some SQL comments, and so I can't run the query in Management Studio. Here's an example:

SELECT * FROM table WHERE id IN (@p0,@p1,@p2)
-- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [5]
-- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [1]
-- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [13189086]

So, is there any tool that transforms this text into a valid SQL?

Is your desired result just the SQL statement with all the parameter placeholders substituted with their values? Or did you still want the DECLARE statements included, similar to the LINQPad output in my response? — Ahmad Mageed
– Ahmad Mageed, Commented Nov 21, 2010 at 16:32
It wolud be nice to have parameters DECLAREd, but it's reasonable with the parameters substituted. The goal is to have a query ehich can be Executed. — jaraics
– jaraics, Commented Nov 22, 2010 at 7:21

Ahmad Mageed · Accepted Answer · 2010-11-18 15:25:51Z

2

You can grab LINQPad (free!) and run your LINQ to SQL directly. Then click on the "SQL" tab in LINQPad to see the generated SQL. It will DECLARE all the parameters for you and you could copy/paste that into SSMS (or click "Analyze SQL" from the SQL tab to launch it in SSMS). You can also run it directly from LINQPad.

Screenshot:

LINQPad

edited Nov 18, 2010 at 15:25

answered Nov 18, 2010 at 15:16

Ahmad Mageed

96.9k20 gold badges170 silver badges177 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

jaraics Over a year ago

Thanks, it's a good entry, but not the answer i'm looking for.

Collectives™ on Stack Overflow

Execute LINQ generated SQL in SSMS

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related