Answers for "linq query to fetch parent child data from same table in c#"

C#

0

linq query to fetch parent child data from same table in c#

var v = from p in db.tableName
        select new
        {
          ParentID = p.SerialNo,
          child = from c in db.tableName
                  where c.Parent == p.SerialNo select
                  new
                  {
                    ChildID = c.SerialNo,
                    ParentID = c.Parent
                  }
        };

Posted by: Guest on February-05-2021

Code answers related to "linq query to fetch parent child data from same table in c#"

Code answers related to "C#"

C# Answers by Framework

Unity

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#