KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm trying to figure out if there's a way to retrieve the (full) sql statement that gets executed on the database server. I found something already, but it does not exactly what I would like: IQueryable<SomeType> someQuery = ... string command = dataContext.GetCommand(query).CommandText; In my case this gives me a command string something like: SELECT TOP (50) [t0].[ID], .... FROM [dbo].[someTable] AS [t0] WHERE ([t0].[someColumn] IS NOT NULL) AND (([t0].[someColumn]) IN (@p0)) On database there's executed: exec sp_executesql N'SELECT TOP (50) [t0].[ID], ... FROM [dbo].[someTable] AS [t0] WHERE ([t0].[someColumn] IS NOT NULL) AND (([t0].[someColumn]) IN (@p0, @p1))',N'@p0 int,@p1 int',@p0=401,@p1=201 Is there a way to retrieve this 'full' statement (so also the parameter values) from C# code?
Tags (comma-separated)
Save Edits
Cancel