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
Why ca not we use multiple inheritance and garbage collector paralelly in .net?
What is the default Timeout for SqlCommand.CommandTimeout property?
What are the different ado.net namespaces are available in .net?
How to bind the controls(best practice) comboboxes to the data in the dataset?
Explain ado.net features?
Some important instruction regarding ADO.NET connection string ?
Give an example of a .net application which connects to microsoft access database using ado.net classes.
Is ado.net an orm?
What is ado.net in vb net?
What is connection string?
What is different between sqlcommand object and command behavior object?
Which object needs to be closed?
What is difference between executequery and executeupdate?
What are the 3 major types of connection objects in ado.net?
What is the use of SqlCommandBuilder?