using System;

public class Program

{

    public static void Main()

    {

        Console.WriteLine("Hello World");

    }

    private List<HouseEntity> GetCompanyManagedHouses(Guid companyId, short period)

    {

        var houses = Db.Houses

            .Include(x => x.Basement)

            .Include(x => x.Foundation)

            .Include(h => h.AdditionalInfo)

            .Where(h => h.CompanyId == companyId

                   && !h.DeleteUtcDateTime.HasValue

                   && h.AdditionalInfo.OrderByDescending(p => p.Period).Any(x => !x.IsContractTerminated));

        var entities = new List<HouseEntity>();

        foreach (var house in houses)

        {

            house.AdditionalInfo = house.AdditionalInfo.Where(c => c.Period == period).ToList();

            if (house.AdditionalInfo.Any())

                entities.Add(house);

        }

    }

}