цикл for по дате (dt)
{
цикл for по k (k.type)
                    {       selectchs =
                                    from tCountry in table.country
                                        where (tCountry.countrName == addressCountry || tCountry.countrName == tCountry.countrName || tCountry.countrName == null)
                                    from tCity in table.cities
                                        where (tCity.cityName == addressCity || tCity.cityName == tCity.cityName || tCity.cityName == null)
                                    from tStreets in table.streets
                                        where (tStreets.streetName == addressStreet || tStreets.streetName == tStreets.streetName || tStreets.streetName == null)
                                    from tParent in table.parent
                                        where tParent.countrId == tCountry.countrId &&
                                              tParent.cityId == tCity.cityId &&
                                              tParent.streetId == tStreets.streetId &&
                                              (tParent.parentId.ToString() == parentName || tParent.parentId == tParent.parentId || tParent.parentId == null) &&
                                              (tParent.home == home || tParent.home == tParent.home || tParent.home == null) &&
                                              (tParent.flat == flat || tParent.flat == tParent.flat || tParent.flat == null) &&
                                              (tParent.Name == name || tParent.Name == tParent.Name || tParent.Name == null) &&
                                              (tParent.Phone == phone || tParent.Phone == tParent.Phone || tParent.Phone == null)
                                    from tChild in table.childs
                                        where tParent.parentId == tChild.parentId && 
                                    join sv in table.games on tChild.chId equals sv.chId into stmp 
                                    from ch in stmp.DefaultIfEmpty()
                                        where ch.Date == dt && ch.tpId == k.type
                                    from tGameProp in table.gameProp
                                        where ch.propId == tGameProp.propId
                                    from tColors in table.colors 
                                        where ch.cId == tColors.cId && 
                                        (
                                              tGameProp.charId == (dictionChar.ContainsKey(1) ? 1 : -1) ||
                                              tGameProp.charId == (dictionChar.ContainsKey(2) ? 2 : -1) ||
                                              tGameProp.charId == (dictionChar.ContainsKey(3) ? 3 : -1) ||
                                              tGameProp.charId == (dictionChar.ContainsKey(4) ? 4 : -1)) &&
                                              tGameProp.yearId == (yearId_ == 2 ? 1 : 3) 
                                    select new listchs
                                    {
                                        countrName = tCountry.countrName,
                                        cityName = tCity.cityName,
                                        streetName = tStreets.streetName,
                                        home = tParent.home,
                                        flat = tParent.flat,
                                        child = tChild.chId,
                                        parnt = tParent.Name,
                                        Phone = tParent.Phone,
                                        color = tGameProp.Color,
                                    };
					}
}