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

sandeep ram

17y5.2k.NET

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.
}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kirtan Patel17y ago
Accepted 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
0
sandeep ram17y ago
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 :)
0
Roei Bar17y ago
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
0
sandeep ram17y ago
Hi,

Thanks for the reply :)

So in the first case, I cannot create another DataContext instance of the same name is it ?
0
Kirtan Patel17y ago
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 :)
0