What is ADO.NET

Hi friends,i would like to explain some basic concepts about ADO.NET for beginners
what is a Database
A Database of interrelated data is called as Database
Database are divided into 3 types

What is ADO..?


ADO means ActiveX Data Objects


ADO.NET is an object  library (collection of classes ) which is used to communicate with databases


ADO.NET helps to develop client server architecture


ADO.NET supports two types of connections
a)managed connection
b)Unmanaged connection

Unmanaged connections works over OLEDB provides (object linking and embedding databases)


OLEDB provides are pre-developed Dll files which are COM components


As COM is platform Dependant ,hence connections over OLEDB are called as UnManaged


connections


managed connections works with help of tabular data stream


managed connections are faster.

Namespaces for ADO.NET programming


ADO.NET related namespaces are divided in to 5 groups


Common namespaces


a)System.Data


b)System.Data.common


c)System.Data.SqlTypes


UnManaged namespaces :


d)System.data.OLEDB(supports all databases)


Managed namespaces :


e)System.Data.SqlClient(for sqlserver)


f)System.Data.OracleClient(for Oracle)


ODBC namespace :


g)System.Data.ODBC(supports all Databases)


LINQ Related


h)System.Data.LINQ


That's it...

About the Author

Sayyad is a Software Engineer, Blogger and Founder of Developers Code from India.His articles mainly focus on .Net (Web and Windows based applications), Mobile Technologies (Android,IPhone,BlackBerry) and SEO.

Reach Him :

Google+

Facebook

Twitter

Pinterest