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.

• MSDN - DbProviderFactories.GetFactoryClasses Method

Open a connection by using the Open method of a connection object.

• MSDN - SqlConnection.Open Method

Close a connection by using the connection object.

• MSDN - SqlConnection.Close Method

Secure a connection to protect access to your data source.

• MSDN - Building Secure Data Access
• MSDN - Securing Connection Strings

Create a connection designed for reuse in a connection pool.

• MSDN - Using Connection Pooling with SQL Server

Control connection pooling by configuring ConnectionString values based on database type.

• MSDN - Connection Pooling for the .NET Framework Data Provider for SQL Server

Use connection events to detect database information.

• MSDN - Working with Connection Events

Handle connection exceptions when connecting to a database.

• MSDN - Improving ADO.NET Performance

Perform transactions by using the ADO.NET Transaction object.

• MSDN - Performing Transactions