Difference between Server Object Explorer and Server Explorer

1

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

That doubt arose after I followed that tutorial from Microsoft where they make an application to a fictitious university. I have done the whole process, and in the middle of the tutorial, they say that if I do not use a connection string , Entity will create a default >. No sooner said than done. I ran the application without cs and ran. I edited, deleted records without problem without even creating a cs . The question I wanted to understand is that after giving run , I can only see the database in the Object Explorer and not the Server Explorer . Why do these two tools exist together? Would not it only take one? Anyone who can clarify these doubts, I would be very grateful!

    
asked by anonymous 31.03.2017 / 20:54

1 answer

0

I believe the Server Explorer you are referring to is 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 for other things like Azure and SharePoint.

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

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

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

One cool thing to do now is to try out all you can do with both components, compare the differences and see which one pleases you the most. But personally, if it's to work with SQL, I'd rather use another tool. The SQl Server Management Studio gives you much more control over your databases.

    
31.03.2017 / 21:08