Archive for February 5th, 2011
Finalize vs Dispose
Following the difference between Dispose and Finalize method, 1>CLR uses the Dispose and Finalize methods for performing garbage collection of runtime objects of .Net applications. 2>CLR has a Garbage Collector(GC) which periodically checks for unused and unreferenced objects in Heap.It call Finalize() method to free the memory used by such objects. 3>Dispose is another method [...]
Read Full Post | Make a Comment ( None so far )ExecteReader,ExecuteNonQuery,ExecuteScalar
ExecteReader:Use for accessing data.It provide a forward only ,read only,Connected record set. ExecuteNonQuery:Use for Data manipuation such as insert,update,delete. ExecuteScalar:used to retreive single value 1row ,1col its example when you want to retrieve agregate functions .
Read Full Post | Make a Comment ( None so far )
