Answer Posted / vivek

Command object is only one to execute queries in the
backend.
Ex:
SqlConnection cn=new SqlConnection();
SqlCommand cmd=new SqlCommand("SELECT * FROM EMP",cn);
cmd.ExecuteNonQuery();
cmd.ExecuteReader();
cmd.ExecuteScalar();
Cmd.ExecuteXmlReader();
command object has only these 4 methods to execute queries
in the backend.

Why do we serialize data?

940

---

Data reader read and forward only, how is it possible to get 2 tables of data at a time?

916

---

What are the essential features of ado.net?

949

---

What are the major difference between classic ADO and ADO.NET?

1008

---

What is the difference between an ADO.NET Dataset and an ADO Recordset?

1041

---

How to Read, Add, Update and Delete record in Entity Framework ?

1037

---

What is microsoft ado.net?

1142

---

What is the provider being used to access oracle database?

993

---

What is the executescalar method?

1096

---

Explain the difference between an ado.net dataset and an ado recordset?

1057

---

Describe datareader object of ado.net with example.

935

---

Which name space is used to get assembly details?

985

---

What is the difference between ado.net and entity framework?

1047

---

Define the data provider classes that is supported by ado.net?

978

---

What is sql connection in ado.net?

946

---