How to fetch multiple record through entityframework

Question

I have three tables

Employee (ID numeric, Name varchar)
Login (ID numeric, UserName varchar, Password varchar)
EmployeeLogin (ID numeric, EmployeeID, LoginID)

Relation is one employee can have multiple login. How will I get all the Login Name of a particular Employee.

I am able to fetch single record using the code given below but how will I get multiple records

using (var context = new AllEntities())
{
      var query = from c in context.Employees
                     where c.ID == 9
                     select c;
}

granaker · Accepted Answer · 2012-01-12 10:20:48Z

4

The EmployeeLogin table seems redundant if you only have a one-to-many relationship between Employee and Login. You could just place a column EmployeeId in the Login table. The setup you have right now supports many-to-many between Employee and Login.

If you change your model according to my suggestion you could then get all Logins for a EmployeeId like this:

            var query = from c in context.Logins
                        where c.EmployeeID == 9
                        select c;

If you keep your current model you could get all logins for an employee id like this:

            var query = from l in context.Logins
                        join el in context.EmployeeLogins
                        on l.LoginId equals el.LoginId
                        where el.EmployeeID == 9
                        select l;

answered Jan 12, 2012 at 10:20

granaker

1,3288 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

tdykstra · Accepted Answer · 2012-01-12 16:05:03Z

1

You should have all of the Logins in a navigation property on the Employee entity. See this tutorial:

http://www.asp.net/web-forms/tutorials/getting-started-with-ef/the-entity-framework-and-aspnet-getting-started-part-1

You can let the Entity Framework get the related data automatically or you can do it manually; for descriptions of lazy vs. eager loading see these tutorials:

http://www.asp.net/web-forms/tutorials/getting-started-with-ef/the-entity-framework-and-aspnet-getting-started-part-2

http://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/reading-related-data-with-the-entity-framework-in-an-asp-net-mvc-application

answered Jan 12, 2012 at 16:05

tdykstra

6,1202 gold badges26 silver badges20 bronze badges

Collectives™ on Stack Overflow

How to fetch multiple record through entityframework

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related