private NavSubdivision getSubdivision(UserConnection userConnection, string name) { var esq = new EntitySchemaQuery(userConnection.EntitySchemaManager, "NavSubdivision"); esq.UseAdminRights = false; esq.AddAllSchemaColumns(); esq.Filters.Add(esq.CreateFilterWithParameters(FilterComparisonType.Equal, "NavName", name)); var collection = esq.GetEntityCollection(userConnection); NavSubdivision result; if (collection.IsEmpty()) { _logger.Info("Подразделение не " + name + " найдено."); result = new NavSubdivision(userConnection); result.UseAdminRights = false; result.SetDefColumnValues(); result.NavName = name; result.Save(); _logger.Info("Создали новую запись в Бд."); } else { result = (NavSubdivision)collection.First(); } return(result); }