How to debug stored procedures from a C# debug session?

Question

In a C# VisualStudio project the C# code calls a stored procedure which is referenced in the .dbml file (or the procedure is called via a SQL command from C#).

Is it possible to set a break point in the stored procedure code and get a break there whenever the stored procedure is called from a C# debug session (like it is possible by right clicking on the stored procedure in the SQL Server Object Explorer an choose "Debug Procedure")?

are you facing any problem in debugging it from SQL Server? what is making you to debug it from Visual Studio. — NMathur
– NMathur, Commented Dec 21, 2016 at 11:57
@NMathur - I like the comfort to do everything from one application if it is possible... but this is not the problem. — Monotomy
– Monotomy, Commented Dec 21, 2016 at 12:04
I only know one method .. execute the procedure . pass values and then debug .... but its good to trying new ways .. not sure if it is possible . but good luck .. — NMathur
– NMathur, Commented Dec 21, 2016 at 12:11

Mack · Accepted Answer · 2016-12-21 12:35:32Z

4

To allow you step through a T-SQL stored procedure on SQL Server while debugging in .NET app you need to:

Read and follow the guide "How to debug stored procedures in Visual Studio .NET (Option 2)"

Here are the pertinent steps from this article...

In Solution Explorer, right-click the project (not the solution) and open the Property pages. Click Configuration Properties in the tree and then click to select the SQL Server Debugging check box on the Debugging page to enable stored procedure debugging.
Set a breakpoint on the line of code that executes the stored procedure.
In Server Explorer, locate and open the stored procedure. Right-click the stored procedure and then click Edit Stored Procedure.
Set a breakpoint in the stored procedure on the SELECT statement, which is the only line of executable code.
Run the project.
Perform the action that triggers the code that calls the stored procedure.
Press F11. Code execution steps from the ExecuteReader method into the stored procedure window.

N.B. I'm not an expert in this as I prefer to use SSMS.

answered Dec 21, 2016 at 12:35

Mack

2,5521 gold badge26 silver badges44 bronze badges

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

3 Comments

Monotomy Over a year ago

That works! Here is just one strange problem: I've to start one manual stored procedure debug session per VisualStudio session and then I can set the break point in every procedure everywhere. (Point 4 does nothing here - also it is not necessary to set a break point in the C# code (Point 2)).

Maury Markowitz Over a year ago

"Set a breakpoint in the stored procedure on the SELECT statement, which is the only line of executable code" - is there any way to do this if the SP is not part of the project, but already exists in the SQLS DB?

Mack Over a year ago

@MauryMarkowitz try this article for more information - codeproject.com/Articles/1079275/…. I still don't use this myself.

Collectives™ on Stack Overflow

How to debug stored procedures from a C# debug session?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related