Answer / naresh

The provider name is oledb and the namespaceis
system.data.oledb

Answer / parveen atreya

The Most app. provider is OracleClient. To use this
provider we have to add this from add reference utilities
in dot net application. The Namespace for this is ....

SQL.DATA.OracleClient


enjoy..........

Answer / naresh

We can use any of the following providers to connect to the
oracle databas

Oledb provider
Odbc provider
OracleClient Provider

and the namespaces for the above provider are

Oledb provider--> System.Data.Oledb
Odbc provider---> System.Data.Odbc
OracleClientProvider--> System.Data.OracleClient

Answer / surendra

oledb Provider -->system.data.oledb;
odbc -->no namespace;
oracle -->system.data.oracleclient;

How would you connect to database using .NET?

0 Answers  

---

What is the use of SqlCommand object?

0 Answers  

---

Define connection string?

0 Answers  

---

What is isolation?

0 Answers  

---

Which object is used to add relationship between two Datatables?

0 Answers  

---

What is the role of clr?

0 Answers  

---

What are the steps you will take to improve performance? Will you use dataset or datareader?

0 Answers  

---

What is maximum pool size in ado.net connection string?

0 Answers  

---

What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?

2 Answers  

---

How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?

0 Answers  

---

Explain how can we load multiple tables in to dataset?

0 Answers  

---

Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?

0 Answers  

---