---
title: "What namespace used in ado.net?"  
description: "What namespace used in ado.net?"  
author: "Pushpendra Singh"  
published: 2010-12-07  
updated: 2020-09-24  
canonical: https://www.mindstick.com/interview/280/what-namespace-used-in-ado-dot-net  
category: "ado.net"  
tags: ["ado.net"]  
reading_time: 2 minutes  

---

# What namespace used in ado.net?

1.System.Data\
It contains the common classes for connecting, fetching data from database. Classes are like as DataTable, DataSet, DataView etc.\
\
2.System.Data.SqlClient\
It contains classes for connecting, fetching data from Sql Server database. Classes are like as SqlDataAdapter,SqlDataReader etc.\
\
3.System.Data.OracleClient\
It contains classes for connecting, fetching data from Oracle database. Classes are like as OracleDataAdapter,OracleDataReader etc.\
\
4.System.Data.OleDb\
It contains classes for connecting, fetching data from any database(like msaccess, db2, oracle, sqlserver, mysql). Classes are like as OleDbDataAdapter,OleDbDataReader etc.\
\
5.System.Data.Odbc\
It contains classes for connecting, fetching data from any database(like msaccess, db2, oracle, sqlserver, mysql). Classes are like as OdbcDataAdapter,OdbcDataReader etc.

## Answers

### Answer by hanmandlu vasani

1.System.Data\
It contains the common classes for connecting, fetching data from database. Classes are like as DataTable, DataSet, DataView etc.\
\
2.System.Data.SqlClient\
It contains classes for connecting, fetching data from Sql Server database. Classes are like as SqlDataAdapter,SqlDataReader etc.\
\
3.System.Data.OracleClient\
It contains classes for connecting, fetching data from Oracle database. Classes are like as OracleDataAdapter,OracleDataReader etc.\
\
4.System.Data.OleDb\
It contains classes for connecting, fetching data from any database(like msaccess, db2, oracle, sqlserver, mysql). Classes are like as OleDbDataAdapter,OleDbDataReader etc.\
\
5.System.Data.Odbc\
It contains classes for connecting, fetching data from any database(like msaccess, db2, oracle, sqlserver, mysql). Classes are like as OdbcDataAdapter,OdbcDataReader etc.


---

Original Source: https://www.mindstick.com/interview/280/what-namespace-used-in-ado-dot-net

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.