Answer Posted / shivendra pandey

stored procedure is precomplied and not return value by
default but function compile each time and use return
statement simply.
if u r using database then use stored procedure for
pefmance n if u are working with simple pl for some
calculation go for function

What are the several execute methods of ado.net?

590

---

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

572

---

How to create data relations?

628

---

What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

614

---

What are all the classes that are available in System.Data Namespace?

646

---

---

What are the important features of ado.net 2.0?

698

---

Explain how to pass multiple tables in datasets simultaneously?

597

---

What are the pre-requisites for connection pooling?

620

---

Explain the difference between data reader and data adapter?

585

---

What is read only and forward only in ado.net?

594

---

Explain how to call the sql commands asynchronously in ado.net version 2.0?

589

---

What is connected architecture in ado.net?

607

---

What are the namespaces used in ADO.Net to connect to a database?

676

---

What is ole2 format?

578

---

What is ado.net code?

589

---