CRUD on parent/child rows in a typed dataset

21 May 2006 5:55 PM

mike

i am new to ADO.NET!

i have created a typed dataset with parent and child types. is there a
straightforward way to load parent records and have child records load
automatically rather than manually loading tables using Fill method
with citeria arguments?

when disconnected application performs CRUD operations on this dataset.

when connecting back i want dataset to update back to the database in a
single operation.

what i have just described is a ADO.NET but i dont see any clear
examples on CRUD on relational data. is this possible? examples, links
.... anything will be useful.

please help and thanks in advance.

- mike

22 May 2006 6:51 AM

Cor Ligthert [MVP]

Mike,

AFAIK, No they are not, I hope as you that they will exist in the next
version.
(As is reported).

Cor

Show quote

"mike" <donotreplymeonthisem***@gmail.com> schreef in bericht
news:1148234132.249581.161000@i39g2000cwa.googlegroups.com...
>i am new to ADO.NET!
>
> i have created a typed dataset with parent and child types. is there a
> straightforward way to load parent records and have child records load
> automatically rather than manually loading tables using Fill method
> with citeria arguments?
>
> when disconnected application performs CRUD operations on this dataset.
>
> when connecting back i want dataset to update back to the database in a
> single operation.
>
> what i have just described is a ADO.NET but i dont see any clear
> examples on CRUD on relational data. is this possible? examples, links
> ... anything will be useful.
>
> please help and thanks in advance.
>
> - mike
>

29 May 2006 3:34 PM

mike

cor,

therefore i will have to wrap this inside a transactions to make sure
parent and child get add/updated/deleted. any recommendations?

thanks for the info.

-mike

26 May 2006 2:45 PM

jmbledsoe

I don't want to sound like a marketing guy this is the exact same
problem that I had. It was such a PITA, that I built a tool to do this
for me, and now my company is selling it (free to try, and under $100
to buy). It's called the DataSet Toolkit, and it has a class called
the MultiTableDataAdapter which does exactly the thing you want. Let
me know what you think.

http://www.hydrussoftware.com

John B.
http://johnsbraindump.blogspot.com

29 May 2006 3:30 PM

mike

thanks i will look into that.