Class Hierarchy using LINQ
Hi,i need to bind relational data from sqlserver table into class hierarchy.
providing below example for more clarification.
tbl_Company
Company_ID Com_Name
1 Com1
2 Com2
tbl_Employee
Employee_Id Emp_Name Company_Id
1 Emp1 1
2 Emp2 2
3 Emp2 1
tbl_Invoice
Invoice_Id Invoice_Name Employee_Id
1 Invoice1 1
2 Invoice2 1
3 Invoice3 2
below are just add values into class using loop(Just for reference)
for (int i = 0; i < 10; i++)
{
Company company = new Company("CN " + i.ToString());
Employee emp1 = new Employee("Employee1 " + i.ToString(), i = i++);
Employee emp2 = new Employee("Employee2 " + i.ToString(), i = i++);
Invoice empCou = new Invoice("INV " + i.ToString(), i = i++);
Invoice empCou1 = new Invoice("INV2 " + i.ToString(), i = i++);
emp1.EmployeeCou.Add(empCou);
emp1.EmployeeCou.Add(empCou1);
emp2.EmployeeCou.Add(empCou1);
company.Employees.Add(emp1);
companies.Add(company);
}
how can i achieve the above scenario from sqlserver using LINQ(company class should contain hierarchical data based on foreign key relation)
Thanks
