11th Lecture

11th Lecture

IBM- DB2

SEQUEL- Structured English Query Language.First Database System.

MDF -Primary Data File.

LDF- Log data file.

NDF - Secondary Data File.

ADO .Net - ActiveX Data Object.

ADO .Net is micri=osoft's data access technology. It is an Object Model. Using this we can access data from different data models.

DATA Sources

DATABASE (Relational\Non-Relational\Multi-Dimensional)

EXCEL File

XML Files

Text Files

ADO .Net has two components

Data Set-

Data Providers- A data provider is a collection of classes used to acces data from particular type of datbase\datasource.

System.Data.Sqlclient is a data provider that provides access to SQL Server Database. It has class to connect database and manipulate data.

to work with SQL we have to use a namesace System.Data.Sqlclient;

to make connection- SqlConnection;