CRUD on parent/child rows in a typed dataset

[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

 

[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

 

[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

 

[mike]

thanks i will look into that.

 

[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