Tutorio.com

Hierarchical Relationships Without Datarelation Object In Ado.net

Popularity: (276)
Tags: object out relationships hierarchical datarelation

Link: Visit It


I have found that the DataRelation object is a little flaky when it comes to combinations of self-referencing tables and multi-table nested relationships particularly with those that run more than 2 levels deep or have their root level row with the same PrimaryKey as its ForeignKey ParentID. Of course if you are using foreign key constraints you can t just set the ParentID to 0.With this in mind I had to resort to writing a custom solution
Tutorio.com. Privacy Policy, Contact