Try to search your question here, if you can't find : Ask Any Question Now ?

Visual Studio Server Explorer not closing sqlsrvr.exe process

HomeCategory: stackoverflowVisual Studio Server Explorer not closing sqlsrvr.exe process
Avatarjulie asked 4 months ago

I have this ‘issue’ since a long time and I am really wondering if this is just me or if there actually is a way of preventing the following:

In Visual Studio, when using the Server Explorer on a .mdf database, in a Entity Framework Code first approach project whenever I am opening the Database manually to see the data of certain tables (clicking on Show table data), it seems that even when I close the connection like this:

enter image description here

the database connection stays open somehow in the background.
I am getting “… the Database is currently in use …” error if wanting to debug afterwards, after closing the connection, even when restarting the solution.

When I close all sqlservr.exe process(es) in the Task manager that does the trick.

Note that this is a local solution and a local database (.mdf) i am using for testing purposes. Nothing or no one else is using this solution.

I am quite sure this is not the behavior it should have right?
What am I doing wrong or what can I do to not have this behavior if this is not by default?

Thank you in advance for any feedback!

1 Answers
Best Answer
AvatarMannu answered 4 months ago
Your Answer

1 + 2 =

Popular Tags

WP Facebook Auto Publish Powered By :