how to write linq query to get collection of an object

Question

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 T · Answer

Hi Gaurav, I have mentioned in where condition like branch_2 so both will show dept_2_1 and dept_2_2 try like 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(); Before please check what is identify column name particular user is branch_2_1 ?

Nepethya Rana · Answer

I think it can be done with projection. I am not sure

Nepethya Rana · Answer

There is department dept_2_2 is also to be filtered. Thank you .

Raja T · Answer

Hello Gaurav, try like 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(); more details check out below links http://www.dotnetlearners.com/linq/linq-to-sql-writing-select-query.aspx http://www.codeproject.com/Articles/26657/Simple-LINQ-to-SQL-in-C http://codesamplez.com/database/linq-to-sql-c-sharp-tutorial