DataBase Concept in ASP.NET

DATABASE CONNECTIVITY IN ASP.NET:-

File Storage Problems:-

1) No Security In Data.
2) Large Amount of datastorage is not possible.
3) Maniplations and retrival will not be easier.
4) Relation between data is not possible,this relates to data redundancy.

The solution for the above problems is DBMS.

-A collection Interrelated and Integrated data is called DATABASE, The software provided to manage DB is called DBMS.

these are two types;
1) Local Databases-> DBMS
2) Remote Databases-> RDBMS

Here are some differance between the both
DBMS:
1)In dbms no relationship concept
2)It supports Single User only
3)It treats Data as Files internally
4)It supports 3 rules of E.F.CODD out off 12 rules
5)It requires low Software and Hardware Requirements.
6)FoxPro, IMS are Examples

RDBMS:
1)It is used to establish the relationship concept between
two database objects, i.e, tables
2)It supports multiple users
3)It treats data as Tables internally
4)It supports minimum 6 rules of E.F.CODD
5)It requires High software and hardware requirements.
6)SQL-Server, Oracle are examples

The Query Language that provides set of commands to communicate with database is called SQL(Structured Query Language).

Sql is Providing with set of sub languages

1) DDL[Data Definition Language]:-

create stmt
alter stmt
drop stmt

2) DML[Data Maniplation Language]:-

Insert Stmt
Delete Stmt
Update Stmt

3) DRL[Data Retrival Language] :-

Select Stmt

4) TCL[Transaction Control Lanuguage] :-

Commit
Rollback

* The interface that is provided for enduser to communicate with DB is called FRONTEND
* The server used for data storage is called BACKEND

Developer requires set of classes to communicate with DATABASE,Before .net 3 Librariens are provided.

1)DAO[Data Acess Object]- Local DB Connectivity
2)RDO[Remote Data Object]- Remote database communication.
3)ADO[ActiveX Data Object]- Any Type of database communication.

ADO is Extended with IL code is called ADO.NET.

ADO.NET:
ADO.NET is a Collection Of Assemblies provided under .net to communcate with DataBase.

System.Data.Dll [Core Lib of ADO.NET]
System.Data.Oracleclient.Dll[for oracle]
System.Data.Sqlclient.Dll[for SQLServer]

* The current version of ADO.Net is 3.5,It come with a language Integral Query called LINQ