Is there a way to get a fully executable string of the SQL that is about to be run by a Linq2Sql expression?

views:

answers:

Is there a way to get a fully executable string of the SQL that is about to be run by a Linq2Sql expression?

I know you can get the SQL, but it's paramterized without the parameters being visible. Can you get the "full" string, so to speak?

+2 A:

Scott Guthrie created an add on, that works in the debugger.

get it here

Matthew Vines 2009-05-28 21:21:54

Ha as I was writing the qestion hazy memories of that tool started coming back - couldn't remember when and where - shoulda guessed Gu!

joshcomley 2009-05-28 21:28:27

I get a lot of use out of it. Sometimes I just don't recognize what my issue is in linq, but it is painfully obvious once I can run the actual SQL expression.

Matthew Vines 2009-05-28 21:34:58

Doesn't work on x64 systems.

Chris Lively 2009-05-28 21:49:59

@Chris - it does work on x64 systems now

joshcomley 2009-05-29 09:58:24

Although it does have negligible issues with localised dates

joshcomley 2009-05-29 10:00:38

ansaurus

tags:

views:

answers:

Is there a way to get a fully executable string of the SQL that is about to be run by a Linq2Sql expression?

related questions