如何在.NET应用程序执行存储过程时调试它？

I have a stored procedure, I can put breakpoints in it then execute it manually to debug it. However, this does not suffice. I would like to be able to debug it when a .NET(C#) application invokes it, in other words debug it during runtime of .NET application. I have a stored procedure, I can put breakpoint