DOT NET Tutorial

Lecture Details

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, DAORDO
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