This is my Scenario :
Office which has two branches
branch_1, branch_2
branch_1 has dept_1_1 and dept_1_2
branch_2 has dept_2_1 and dept_2_2
each deprtment has employees.
But I need to query through Office to find name of all the employees in dept_2_2
I would be thankful to help me out to write linq queries.
Raja TPosted Feb 22, 2016, 6:14 AM
MyDBDataContext sqlObj = new MyDBDataContext();
var employees = from Office in sqlObj.tblEmployees
where emps.branch=branch_2_2
orderby emps.EmployeeName
select new
{
emps.EmployeeID,
emps.EmployeeName,
emps.Salary
};
gvemployees.DataSource = employees;
gvemployees.DataBind();
Nepethya RanaPosted Feb 22, 2016, 1:50 AM
Nepethya RanaPosted Feb 21, 2016, 11:15 PM
Raja TPosted Feb 21, 2016, 11:03 PM
MyDBDataContext sqlObj = new MyDBDataContext();
var employees = from Office in sqlObj.tblEmployees
where emps.branch=branch_2
orderby emps.EmployeeName
select new
{
emps.EmployeeID,
emps.EmployeeName,
emps.Salary
};
gvemployees.DataSource = employees;
gvemployees.DataBind();