TypedDataSet practices

[Ian Semmel]

If you have a typed dataset, there is a DataTable defined for each table.

We can Fill these tables and Update them etc.

If we use the GetData() function, we get a new DataTable with the results of the
action.

Now, what I am asking is : what is the best thing (or accepted practice) to do ?
Reuse the DataTable in the DataSet, or get a new table each time ?

[Nicholas Paldino [.NET/C# MVP]]

Ian,

I don't see why you can't use the new table every time. It might cost
you some cycles (since you will have to remove the old typed data table from
the data set, and then add the new one).

I do believe that if you use Fill, it will fill the current table in the
data set, and clear it out, which would seem to be more efficient, IMO.

Hope this helps.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Ian Semmel" <is***********@NOKUNKrocketcomp.com.auwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...

If you have a typed dataset, there is a DataTable defined for each table.

We can Fill these tables and Update them etc.

If we use the GetData() function, we get a new DataTable with the results
of the action.

Now, what I am asking is : what is the best thing (or accepted practice)
to do ? Reuse the DataTable in the DataSet, or get a new table each time ?

[Simon Tamman]

I dunno, thinking about it and depending on the size of the dataset, a clear
might be more performant.
I only base this on the fact that in the debugger strongly typed datasets
can take ages to initialize (especially ones with 15+ tables).
Has anyone ever done any benchmarks on this?

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.comwrote in
message news:eG****************@TK2MSFTNGP04.phx.gbl...

Ian,

I don't see why you can't use the new table every time. It might cost
you some cycles (since you will have to remove the old typed data table

from

the data set, and then add the new one).

I do believe that if you use Fill, it will fill the current table in

the

data set, and clear it out, which would seem to be more efficient, IMO.

Hope this helps.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Ian Semmel" <is***********@NOKUNKrocketcomp.com.auwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...

If you have a typed dataset, there is a DataTable defined for each

table.

We can Fill these tables and Update them etc.

If we use the GetData() function, we get a new DataTable with the

results

of the action.

Now, what I am asking is : what is the best thing (or accepted practice)
to do ? Reuse the DataTable in the DataSet, or get a new table each time

?

>