ADO.NET Tutorial for Beginners using C#

ADO.Net Tutorial using C#

In this tutorial we will discuss about Basics of Ado.Net, Authentication and types of Connectivity in Ado.Net using C#.

Ado.Net is stands for ActiveX Data Objects which is a part of .net framework. Ado.Net is a collection of classes i.e. used for database connectivity.
Ado.Net contains set of classes i.e. used to handle data access by database connectivity.
Data Providers: Generally, Provider is a program used to convert front-end code in form of Back-end code and vice-versa.
  •          Data Provider for SQL Server :- System.Data.SqlClient.
  •          Data Provider for OLEDB :- System.Data.OleDb.
  •          Data Provider for ODBC :- System.Data.Odbc.

Authentication: There are two type of Authentication in as follows:
  1.        Windows Authentication.
  2.        Sql Server Authentication (as we use Sql server).

There are two types of connectivity provided by These are given below:
  1.  Ado.Net in Connected Mode.
  2. Ado.Net in Disconnected Mode.
Thanks for reading my news about ADO.NET Tutorial for Beginners using C# at my blog chiara-mycandlelight if you want too share this article, please put the resource, and if you think this article is very usefully dont forget to bookmark this site with CTRL + D on your keyboard to web browser.

New and Hot Article's :

Note: only a member of this blog may post a comment.