Getting the Table data in EntityFramework

Question

0.00/5 (No votes)

See more:

Hi.. I am using 2 Tables say Person and Country.

Person
Name--Occupation--Countryid
Mark--Sales Man --1003
William--Developer--1001

Country
id--Name
1001--San Fransisco
1002--Las Vegas
1003--New York

Here the Person references Country (country id). Consider the classes are already auto generated through EntityFramework and I have Persons and Countries as class name to the respected tables.

Now I am getting the Persons Data thorough the following

C#

this.ObjectContext.Persons.Where(x=>x.Countryid==1003).ToList<Persons>();

This actually returns PersonsList but PersonsList[0].Country (For example: I am getting the first element of the list here) would be null at this case.

So here I am using Includes with the above code

C#

this.ObjectContext.Persons.Includes("Country").Where(x=>x.Countryid==1003).ToList<Persons>();

Now PersonsList[0].Country will have the data for the Country class which that person row references too.

My question is.. Are there any options where I could get this Country data with out this Includes class. ?

Because under my case if I am using this Include class it tooks 2-3 mins (because of the huge data) to process the query. This is mainly because the query generated by EntityFramework is having one more LeftOuterJoin of Country with Persons.

If I am not using the Include then it take only few seconds to process the query. Because here the LeftOuterJoin is skipped. So is there is anyway so that I can access the data of the Country class with out Include.. ??

I have tried my level best to explain this. If you couldn't get this plz feel free to ask me your doubt..

Thanks..

Posted 27-Mar-14 18:49pm

Prasaad SJ

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sankarsan parida · Answer 1 · 2014-03-27T19:21:00

If you want to join both the table and to get the data as listing type

var listNew=(from a in Countries
             join b in Persons on a.CountryId equals b.CountryId
             select new {
             CountryName=a.Name,
             PersonName=b.PersonName
              }).Tolist();

Something like this