Manage connections and transactions
Microsoft .NET Framework, ASP.NET, Visual C# (CSharp, C Sharp, C-Sharp) Developer Training, Visual Studio
| Exam 70-526 Preparation Guide: Manage connections and transactions. |
Configure a connection to a database by using the Connection Wizard.
Configure a connection to a database 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.
Open an ADO.NET connection to a database.
Close an ADO.NET connection to a database by using the Close method of the Connection object.
Protect access to data source connection details.
Create a connection designed for reuse in a connection pool.
Control a connection pool by configuring ConnectionString values based on database type.
Use the Connection events to detect database information.
Handle exceptions when connecting to a database.
Perform transactions by using the Transaction object.