/// <summary>
 /// Загружаем "грязные" данные для дальнейшей их обработки
 /// </summary>
 public List<DirtyApartments> GetDirtyApartmentForProcessing()
 {
     using (AlcionaEntities context = new AlcionaEntities())
     {
         return context.DirtyApartments.ToList();
     }
 }
        private AlcionaDataBaseConnection()
        {
            EntityConnection connection = new EntityConnection();
            string connectionString = ConfigurationManager.ConnectionStrings["AlcionaEntities"].ConnectionString;
            connection.ConnectionString = connectionString;
            connection.Open();
            _context = new AlcionaEntities(connection, false);
            ((IObjectContextAdapter)_context).ObjectContext.CommandTimeout = 3600;

        }
 private ApartmentRepository()
 {
     _context = AlcionaDataBaseConnection.Instance.Context;
 }