mugsey
asked on
recursive query in linq to sql
I have a database table that lists product categories and sub categories as follows
Products table.............
*producttable*
id
productname
categoryid
then just have a productcategory table like this.....
categoryID categoryParentID categoryName
1 0 first
2 0 second
3 1 sub category1 from first
4 1 sub category2 from first
5 2 sub category from second
I want to query these two tables using linq.
Products table.............
*producttable*
id
productname
categoryid
then just have a productcategory table like this.....
categoryID categoryParentID categoryName
1 0 first
2 0 second
3 1 sub category1 from first
4 1 sub category2 from first
5 2 sub category from second
I want to query these two tables using linq.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your reply - I will try your suggestion when I get home tonight.
Thanks