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

From Wikibooks, open books for an open world
Jump to: navigation, search

Configure a connection to a database graphically by using the Connection Wizard.
Configure a connection by using Server Explorer.
Configure a connection to a database by using the connection class.
Connect to a database by using specific database connection objects.
Enumerate through instances of Microsoft SQL Server by using the DbProviderFactories.GetFactoryClasses method.
Open a connection by using the Open method of a connection object.
Close a connection by using the connection object.
Secure a connection to protect access to your data source.
Create a connection designed for reuse in a connection pool.
Control connection pooling by configuring ConnectionString values based on database type.
Use connection events to detect database information.
Handle connection exceptions when connecting to a database.
Perform transactions by using the ADO.NET Transaction object.