You need to do following.
DataRelation dr = new DataRelation("BookBookName",
ds.Tables["MBook"].Columns["BookId"],
ds.Tables["Book"].Columns["BookId"]);
DataRelation dr1 = new DataRelation("BookAuthorName",
ds.Tables["MBook"].Columns["AuthorId"],
ds.Tables["AName"].Columns["AuthorId"]);
and so on. So you have finally four datarelation object. Then add all relation object to dataset, like..
ds.Relations.Add(dr);
ds.Relations.Add(dr1);
ds.Relations.Add(dr2);
You can do navigation as follows
foreach (DataRow MBookRow in customerOrders.Tables["NBook"].Rows)
{
Console.WriteLine(MBookRow["MBookId"].ToString());
foreach (DataRow BNameRow in MBookRow.GetChildRows(dr1))
{
Console.WriteLine(BNameRow\["BookId"\].ToString() + " " + BNameRow\["BookName"\].ToString());
}
}
Refer this[^] link for DataSet Vs NHibernate. HTH
Jinal Desai - LIVE Experience is mother of sage....