Answer Posted / om namo bagavathe vasudevaya n

when ever we create an object for a class or any sever
contol etc with in the application and if we forgot to
dispose that object.Then garbage collector runs a Demon
Process(Demon process:A theard that automatically runs when
ever process is called) that is used to collect all the
objects that are not used for so long time.
but when ever we create any DataBase objects or file objects
they are not belong to the application so the IIS sever
doesnot perfom garbage collection for those DataBase or file
objects.So we have to explicity close those database objects
so for that we have to use Dispose mothod for closeing
Database objects and file objects etc..

What is the difference between executequery and executenonquery?

915

---

What is the difference between Response.Expires and Reponse.ExpiresAbsolute?

1029

---

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

1040

---

What is command class in ado.net?

1028

---

If a table contains 20000 records. In a page at each time 100 records to be displayed.

891

---

What is a string variable?

917

---

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

993

---

How to read data with the sqldatareader ?

983

---

What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?

1338

---

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

1067

---

What are the different methods available under the sqlcommand class to access the data?

1047

---

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

1012

---

What is disconnected scenario in entity framework?

1117

---

What is the difference between SqlCommand and SqlCommandBuilder?

1077

---

Can we connect two dataadapters to same data source using single connection at same time?

986

---