Would the DataSet be released by the Garbage Collector?

[Steven Blair]

Would this DataSet be cleaned up?

void Main()
{
DataSet ds = null;

//Imagine this returns some tables
ReturnData(out ds);

//Grab a handle to the first row in the Configuration Table.
DataRow dr = ds.Tables["Configuration"].Rows[0];

//Create a new class and give the refence to the DataRow
TestClass t = new TestClass(dr);
}

Since a refence to part of the original DataSet exists, would this
prevent the DataSet being colelcted by the Garbage collector?

I know I could extract the fields from the Row, into another container,
but the DataRow really is the object I need to use.

Thanks for the help in advance.

Steven


*** Sent via Developersdex http://www.developersdex.com ***

[Stefan Hoffmann]

hi Steven,

Steven Blair wrote:

Would this DataSet be cleaned up?

Yes, if ReturnData() is side-effect free. All your other
objects/references are local to your Main() methode.
mfG
--stefan <--

[Steven Blair]

What I mean though, if TestClass kicked of Threads and control was no
returned to the main (the application is a service).

Would the DataSet be collected at at some point during the lifetime of
the service, or would the DataSet remain in memory because my TestClass
still has a reference back to the DataSet.

*** Sent via Developersdex http://www.developersdex.com ***

[Dave Sexton]

Hi,

Well, DataRow itself has a reference to it's DataTable, which has a
reference to it's DataSet. So even though the local variables are out of
scope, the GC can't collect the DataSet since "live" objects still reference
it.

--
Dave Sexton
http://davesexton.com/blog
http://www.codeplex.com/DocProject (Sandcastle in VS IDE)

"Stefan Hoffmann" <st*************@explido.dewrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...

hi Steven,

Steven Blair wrote:

>Would this DataSet be cleaned up?

Yes, if ReturnData() is side-effect free. All your other
objects/references are local to your Main() methode.
mfG
--stefan <--

[Dave Sexton]

Hi,

Keeping a reference to the DataRow will prevent the GC from collecting the
DataSet since it's still "in use".

--
Dave Sexton
http://davesexton.com/blog
http://www.codeplex.com/DocProject (Sandcastle in VS IDE)

"Steven Blair" <st**********@btinternet.comwrote in message
news:eI**************@TK2MSFTNGP02.phx.gbl...

What I mean though, if TestClass kicked of Threads and control was no
returned to the main (the application is a service).

Would the DataSet be collected at at some point during the lifetime of
the service, or would the DataSet remain in memory because my TestClass
still has a reference back to the DataSet.

*** Sent via Developersdex http://www.developersdex.com ***

[Steven Blair]

Dave,

Thanks, that what I thought.
I might have to take a copy of the DataRow or hold the information in a
different way.

*** Sent via Developersdex http://www.developersdex.com ***