Difference between Server Object Explorer and Server Explorer

Asked

Viewed 125 times

1

I would like to ask you a question. A question that I could not answer anywhere. I wanted to know the difference between the Object Explorer and the Server Explorer.

This doubt arose after I followed that tutorial from Microsoft where they make an application for a fictitious university. I did the whole process and, in the middle of the tutorial, they say that if I don’t use a Connection string, the Entity is responsible for creating a default. Said and done. I executed the application without Cs and spun. I edited, deleted records with no problem without even creating one Cs. The question I wanted to understand is the fact that, after giving the run, I can only visualize the database on Object Explorer and not in the Server Explorer. Why do these two tools exist together? Wouldn’t it take just one? Anyone who can clarify these doubts, I would be very grateful!

c#

1 answer

0

I believe that the Server Explorer to which you refer is the SQL Server Object Explorer, right?

Server Explorer is a component of Visual Studio that lists servers in general, not just databases. It can list servers of other things like Azure and Sharepoint.

SQL Server Object Explorer is another component that allows you to access servers specifically from Microsoft’s SQL Server databases. He is more specific and specialized.

Both list only servers you have added in any way. You can add your server to Server Explorer, for example... Right-click on "Data Connections", then click on "Add Connection...". Visual Studio will open a screen on which you can choose the type of Preview and then a screen to enter address and credentials.

I’ve never used SQL Server Object Explorer, but I suppose it’s not much different.

A cool thing to do now is to experience everything you can do with both components, compare differences and see which one suits you best. But personally, if it is to work with SQL, I prefer to use another tool. The Sql Server Management Studio gives you much more control over your databases.

Browser other questions tagged c#

You are not signed in. Login or sign up in order to post.