Devart Forums

Code: Select all

            MyOracleDataContext  db = new MyOracleDataContext();

            db.Log = Console.Out;

            DataLoadOptions opts = new DataLoadOptions();
            opts.LoadWith(p => p.ParentTable);
            //opts.LoadWith(p => p.ChildTable);

            db.LoadOptions = opts;

            var q = from p in db.ChildTable
                    where p.ParentTable.Name.Contains("SomeKeyword")
                    select p;

            foreach (ChildTable app in q)
            {
                Console.WriteLine(app.ParentTable.Name + " : " + app.Name);
            }