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?
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
Explain how can we load multiple tables in to dataset?
Does executenonquery return a value?
Does dapper use ado.net?
What are the objects of ado.net?
Which is faster ado.net or linq?
What is an example of ordinal data?
What is ado and rdo?
Which database is the ado.net sql connection object designed for?
What are the difference between readonly vs. Const?
What is difference between Dataview and Datatable?
What are the namespaces used in ADO.Net to connect to a database?
Can we connect two dataadapters to same data source using single connection at same time?
Is it possible to edit data in Repeater control?
How can you identify whether or not any changes are made to the DataSet object since it was last loaded?
Can we load multiple tables in a dataset?