Answer Posted / harsh kagda

there r various new features added in ado.net like

1.optimized dataSet serialization

2.batch updates — Reduction in database roundtrips
3.Asynchronous Data Access
4.common provider model
5.bulk copy
6.enhancements to the dataset
7.data paging

What two types of data providers does ADO.NET supply? What determines which one you should use?

1000

---

What is fill method in ado.net?

991

---

Explain all the classes those are used for database connections between sql server and asp.net?

1017

---

What is ole db query?

997

---

What is ado.net explain with diagram?

965

---

Explain the difference between data reader and data adapter?

984

---

What are typed and untyped dataset?

1112

---

What is microsoft ole db provider for sql server?

943

---

Define connection string?

1078

---

How would you connect to a database by using .NET?

951

---

How will you fill the gridview by using datatable object at runtime?

1067

---

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

984

---

What is connected architecture in ado.net?

1084

---

What is the use of sqldatareader class?

1007

---

Which keyword is used to accept variable number of parameters?

1132

---