Devart Forums

Code: Select all

            using (var dbc = new DBContext())
            {
                var customers = dbc.CustomerAccounts
                    .LoadWith(ca => ca.QuestionnaireSets
                        .LoadWith(qs => qs.Questionnaires.LoadWith(q => q.QuestionnaireType, FetchMode.Join)
                        , FetchMode.Join), FetchMode.Join)
(*1*)               .Where(ca => !ca.Suspended && ca.QuestionnaireSets.Any(qs => qs.Questionnaires.Any(q => q.QuestionnaireStatusID==3)));

                foreach (var c in customers)
                {
                    Console.WriteLine(c.CustomerAccountName);
                    foreach (var cx in c.QuestionnaireSets) 
                    {
                        Console.WriteLine(" > " + cx.Name);
(*2*)                   foreach (Questionnaire q in cx.Questionnaires)
                        {
                            Console.WriteLine(" > " + q.QuestionnaireID);
                        }
                    }
                }
            }

Code: Select all

            using (var dbc = new DBContext())
            {
                var dbo = new DataLoadOptions();
                dbo.LoadWith<CustomerAccount>(ca => ca.QuestionnaireSets, FetchMode.Join);
(*3*)           dbo.LoadWith<QuestionnaireSet>(qs => qs.Questionnaires, FetchMode.SelectByOne);

                dbc.LoadOptions = dbo;

                var customers = dbc.CustomerAccounts;

                foreach (var c in customers.ToList())
                {
                    Console.WriteLine(c.CustomerAccountName);
                }
            }