Sunday, April 3, 2011

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...
developercode
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.

Labels: , , , , ,

4 Comments:

At May 2, 2011 at 6:56 PM , Anonymous Anonymous said...

Nice Post

 
At May 2, 2011 at 6:58 PM , Anonymous Anonymous said...

Nice Post

 
At June 18, 2011 at 10:17 AM , Anonymous Anonymous said...

Thanks for sharing dude....

 
At August 20, 2011 at 3:39 PM , Anonymous Anonymous said...

Thanks

 

Post a Comment

Subscribe to Post Comments [Atom]

<< Home