ICriteria - nrice/SalesLogix GitHub Wiki

Traverse to child relationship

            RepositoryHelper<IPlanObjective> poH = EntityFactory.GetRepositoryHelper<IPlanObjective>();
            ICriteria c = poH.CreateCriteria();
            ICriteria c2 = c.CreateCriteria("PlanInitiatives");
            c2.Add(poH.EF.Eq("UserId", ddlTerritory.SelectedItem.Value));

            IList<IPlanObjective> lpo = c2.List<IPlanObjective>();

Alias

                                            RepositoryHelper<IBPReportData> rh = EntityFactory.GetRepositoryHelper<IBPReportData>();
                                            ICriteria c = rh.CreateCriteria();
                                            ICriteria ca = c.CreateAlias("BPReport", "bpreport");
                                            ca.Add(rh.EF.Eq("bpreport.CompanyCode", bprfilter.Company));
                                            if (!string.IsNullOrEmpty(bprfilter.Divisionname))
                                            {
                                                            ca.Add(rh.EF.Eq("bpreport.DivisionName",bprfilter.Divisionname));
                                            }
                                            if (!string.IsNullOrEmpty(bprfilter.Regionname))
                                            {
                                                            c.Add(rh.EF.Eq("RegionName",bprfilter.Regionname));
                                            }
                                            if (!string.IsNullOrEmpty(bprfilter.Territorynumber))
                                            {
                                                            c.Add(rh.EF.Eq("TerritoryNumber",bprfilter.Territorynumber));
                                            }
                                            if (!string.IsNullOrEmpty(bprfilter.Masterbrokercode))
                                            {
                                                            c.Add(rh.EF.Eq("MasterBrokerCode",bprfilter.Masterbrokercode));
                                            }
                                            if (!string.IsNullOrEmpty(bprfilter.Brokercode))
                                            {
                                                            c.Add(rh.EF.Eq("BrokerCode",bprfilter.Brokercode));
                                            }
                                            result = c.List<IBPReportData>();