Databases in Server Explorer
In Visual Studio .NET, Server Explorer replaces the former Data View window. Use Server Explorer to view and retrieve information from all of the databases installed on a server. You can list database tables, views, stored procedures, and functions in Server Explorer; expand individual tables to list their columns and triggers; and right-click a table to select the Table Designer from its shortcut menu.
Databases appear in two locations in Server Explorer:
- Connections to various types of databases are listed under the Data Connections node. You can explore databases of other types than SQL server, and running on platforms other than Windows. For example, you can create a data connection to an Oracle database running on a UNIX or a Microsoft Windows system.
- To browse a SQL server database running on Windows, open its subnode under the Servers node. You need not create a data connection to browse a SQL server database. If you do create a SQL server data connection for use in code, it will appear under the Data Connections node.
In This Section
- Database Connections and Database References
- Describes similarities and differences between database connections in Server Explorer and database references in Solution Explorer.
- Information on Data Link Properties and OLE DB Providers
- Directs you to useful topics on the data and service providers available to projects via the Data Link Properties dialog box.
- Connecting to Remote Resources with Server Explorer
- Introduces Server Explorer, and directs you to information on how to configure and use this tool window.
- Displaying Data Sources in Server Explorer
- Directs you to topics on creating data connections and displaying links to servers and their databases in Server Explorer.
- User Credentials and Access to Data Sources in Server Explorer
- Explains how the level of access a user has to a server and its databases determines what kinds of information the user can retrieve and manipulate.
- Adding Items from Server Explorer
- Gives procedures for dragging items from Server Explorer to your projects, thus creating data components preconfigured to reference these data sources.
- Accessing Data
- Discusses how to incorporate data access functionality into your applications.
- Introduction to Data Access with ADO.NET
- An introduction to data connections on demand using ADO.NET technology.
- Managing Data with Database Projects
- Provides links to topics on creating and managing database projects in Solution Explorer.
- Visual Database Tools
- Provides links to topics explaining how Visual Database Tools can help you create and manage databases and design data interface components for your applications.