The use of Dispose()
I have read the links that instructor put in the description but I did not get all. In few words using Dispose closes your connection right? When data is loaded, Dispose closes your connection when there is no data left? (avoids memory leaks)
Am I right? if not, give me a simplified explanation or any example :(
Steven Parker180,219 Points
You are quite right, but you don't always have to use "Dispose" directly. One good alternative that I know is shown in the courses is a "using" statement.
A resource accessed that way is automatically disposed when the code leaves the scope of the "using" block.