ADO.NET Tutorial for Beginners | What is ADO.NET | ADO.NET Online Training
This ADO.NET tutorial for beginners will teach you ADO.NET fundamentals from scratch. This complete ADO.NET course will help you master all the concepts you need to learn in ADO.NET.
To learn more about .NET tutorials:
►Click here to subscribe - / @techytutorials9427
In this video we will learn about
1. What is ADO.NET? & use of ADO.NET
ADO.NET is a database technology of .NET framework which is used to communicate between front end application and backend database
2. Namespaces resides under ADO.NET
ADO.NET provides various classes to communicate with different databases. These classes are divided into following namespaces
1. System.Data
2. System.Data.Oledb
3. System.Data.Odbc
4. System.Data.SqlClient
5. System.Data.OracleClient
3. Use of these Namespaces
1. System.Data
Collection of classes which are used for holding and managing the data on client machine. The classes are DataSet DataTable, DataColumn, DataRow, DataView, DataRelation etc.
2. System.Data.Oledb
Object linking and embedding database which is collection of classes used for communication with any data source.
3. System.Data.Odbc
Open database connectivity which is collection of classes used for communication with any data source
Difference between ODBC and OLEDB
Odbc
It’s a traditional (old) way to communicate with any data source.
Odbc is used to connect with relational database or sql based database
What is Relational database?
Ex. Oracle, Sqlserver, MS-excel
Oledb
It’s newer version of Odbc to connect with any database
Oledb is used to connect with relational and non-relational databases which are based on sql or non-sql
Ex. Oracle, Sqlserver, MS-Excel and Email, MS-word, XML
What is relational database?
The database which stores data in the form of rows and columns or tables called as relational database. Can specify relation between them (Tabular form)
What is non-relational database?
The database which stores data in the form of text, xml like MS-word, email etc. (Non Tabular form)
4. System.Data.SqlClient
This is collection of classes which used to communicate with only SqlServer data source
5. System.Data.OracleClient
This is collection of classes which used to communicate with only Oracle data source
== LET'S CONNECT! ==
►Instagram - www.instagram.com/techytutorial/