Interested to Buy Any Domain ? << Click Here >> for more details...
What we do with the object of ado.net dataset after using
it?Can we dispose it or can we set it nothing?Is it must or
not?
- 4 Answers
- 7900 Views
- SVI, I also Faced
- E-Mail Answers
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..
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Define Execute Scalar?
What is sql command in ado net?
Why is ADO.NET serialization slower than ADO ?
What is the difference between dataset and datatable?
Which property is used to check whether a DataReader is closed or opened?
What are the core objects of ADO.NET?
Which object is used to add relationship between two Datatables?
Which is faster entity framework or ado.net?
How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
What is difference between datareader and dataadapter?
Describe the command object and its method.
What is DataReader Object?
Explain the basic use of "dataview" and explain its methods.
How to find the given query is optimised one or not?
What is difference between datatable and dataset?
