Visit http://www.BestDotNetTraining.com for complete tutorial. In this video we will learn on how to work with database. Here we will learn how to use Managed Provider for SQL Server and will also discuss all the important objects like SqlConnection, SqlCommand and SqlDataReader. Session 1: a) Introduction to SQL. b) Evolution of ADO.NET after Native Drivers, ODBC Drivers, DAO/RDO and ADO. c) About Managed Providers d) Important Objects in Managed Provider Session 2: a) Creating Database using VS.NET b) Establishing Connection with Database c) Connection String Formats Session 3: a) Executing simple Insert, Update and Delete Statements b) Executing Select Statement and using SqlDataReader c) MultipleActiveResultSets(MARS) Session 4: a) Prepared Statements b) Stored Procedures Session 5: a) Managing Transactions b) Asynchronous Execution of Sql Statements c) To write provider independent code
