title: CTE recursive query with linq mvc
body: <p>My table for Category is something like : <code>categoryId,cat_name,parentId</code> </p>
  
  <p>i want to fetch all child categories from root(category) to the bottom of tree in hierarchical form as parent-child relation with linq and also im using mvc3 EF model structure ...</p>
  
  <p>please suggest some solution for this ...</p>
  
  <p>thanks in advance, Milan</p>