Microsoft Certified Professional Developer/Exam 70-528/Web-Based Client Development/Manage connections and transactions of databases

Configure a connection to a database graphically by using the Connection Wizard.  Walkthrough: Connecting to Data in a Database 

Configure a connection by using Server Explorer.  MSDN - Server Explorer\Database Explorer 

Configure a connection to a database by using the connection class.  MSDN - SqlConnection Class 

Connect to a database by using specific database connection objects.  MSDN - Creating ADO.NET Connection Objects 

Enumerate through instances of Microsoft SQL Server by using the DbProviderFactories.GetFactoryClasses method. <ul> <li>MSDN - DbProviderFactories.GetFactoryClasses Method</li> </ul>

Open a connection by using the Open method of a connection object. <ul> <li>MSDN - SqlConnection.Open Method</li> </ul>

Close a connection by using the connection object. <ul> <li>MSDN - SqlConnection.Close Method</li> </ul>

Secure a connection to protect access to your data source. <ul> <li>MSDN - Building Secure Data Access</li> <li>MSDN - Securing Connection Strings</li> </ul>

Create a connection designed for reuse in a connection pool. <ul> <li>MSDN - Using Connection Pooling with SQL Server</li> </ul>

Control connection pooling by configuring ConnectionString values based on database type. <ul> <li>MSDN - Connection Pooling for the .NET Framework Data Provider for SQL Server</li> </ul>

Use connection events to detect database information. <ul> <li>MSDN - Working with Connection Events</li> </ul>

Handle connection exceptions when connecting to a database. <ul> <li>MSDN - Improving ADO.NET Performance</li> </ul>

Perform transactions by using the ADO.NET Transaction object. <ul> <li>MSDN - Performing Transactions</li> </ul>