Return from database not all data

Question

 using (var db = new ConnectToDB())
        {
            var matches = db.Matches;
            var matchesToReturn = new List<SimpleMatch>();
            foreach (var item in matches)
            {
                var match = new SimpleMatch();
                match.Id = item.Id;
                match.Home = item.Home.Name;
                match.Guest = item.Guest.Name;
                match.HomeTeamGoals = item.Result.HomeTeamGoals;
                match.GuestTeamGoals = item.Result.GuestTeamGoals;

                matchesToReturn.Add(match);

            }

            return matchesToReturn;
        }

all item has id and DateMatch, but item.Home, item.Guest, item.Result ==null

img return

Possible duplicate of [Lazy Loading vs Eager Loading](http://stackoverflow.com/questions/31366236/lazy-loading-vs-eager-loading) — Eugene Podskal, Jul 02 '16 at 15:24
fields filled, can't return data from another table what have relationship with table `Matches` — Venedchuk, Jul 02 '16 at 15:43
You need to include relative tables of Matches using [Include](http://stackoverflow.com/questions/27698969/ef-include-with-where-clause) syntax — Dattatraya Kale, Jul 02 '16 at 15:49

score 1 · Accepted Answer · answered Jul 02 '16 at 15:51

1

Ensure to load the related objects. For example like this:

foreach (var item in matches.Include(x => x.Home).Include(x => x.Guest).Include(x => x.Result))
{
    ...
}

answered Jul 02 '16 at 15:51

Udo

449
3
13

Return from database not all data

1 Answers1