What is the difference between using a DataContext instance in the following two ways?

Question

Hi First post here so pardon me if its a repeat qossion... :) Can someone please tell me what is the difference between creating the datacontext as - MyDatabaseDataContext db=new MyDatabaseDataContext(); ////// ///////// Some code/ 2. using (MyDatabaseDataContext db=new MyDatabaseDataContext()) { /// ////// do something. }

Kirtan Patel · Answer

No Friend Its not Like that in Both cases you can not create instance with the same name but what i m telling is in Second case if object is Disposable then it will dispose it after using (Free Memory) not deleting those object and if Object is Like SqlConnection it will Close the Connection after Using it in using () { } block

sandeep ram · Answer

I think somehow you should allow users to check two replies as selected answers ...thanks to both of you .. I am clear on it now :)

Roei Bar · Answer

the idea of using was created for developers since we are lazy and always forget to free memory this is why u use using its saying 2 things: 1. all objects inside the using block are in the using scope only 2. when the using ends all objects will be disposed from the memory

sandeep ram · Answer

Hi Thanks for the reply :) So in the first case I cannot create another DataContext instance of the same name is it ?

Kirtan Patel · Answer

Friend in First Code The Context Data Will be not disposed after using it while in Second Type of code the dataContext Will be automatically disposed after using it :)