Using Visual Studio 2015 CE to Debug stored procedures called from .NET code?

Question

I am unable to debug a stored procedure called from .NET code using Visual Studio 2015 community edition. After much trial an error I've managed to find a sample project that works (But with Visual Studio 2013).

Here is a link to this project.

I've written more details about this problem here.

I am trying to understand if Visual Studio 2015 community edition is able to debug stored procedures called from .NET code. (I can debug stored procedures from the SQL Object Explorer directly) and if so what I can do to get this to work.

This question is similar to this question and this question.

Answer 1

According to this it's probably not possible:

https://social.msdn.microsoft.com/Forums/vstudio/en-US/dc36cda2-c947-4902-b339-c3f5de02b222/is-it-possible-to-debug-stored-procedures-using-visual-studio-community-2015?forum=transactsql

Answer 2

After further discussion a bug has been opened regarding this issue:

https://connect.microsoft.com/VisualStudio/feedback/details/3117615

It seems to be related to Visual Studio 2015 CE Update 3. I have not been able to confirm but if you have only the Original Visual Studio 2015 CE installed without any updates that it should work.

Here is a link to the discussion:

https://social.msdn.microsoft.com/Forums/vstudio/en-US/5c26c8c6-6d35-4c46-ae67-a2e7b3cdce28/using-visual-studio-2015-ce-to-debug-stored-procedures-called-from-net-code?forum=vsdebug#f839fdd0-0316-44f3-82ab-adf2b0ebcb78