如何一般地检查实体/关系 [英] how to check for entities/relationships generically

问题描述

我有以下A /> B之类的实体/关系； B-> C，B-> D，B-> E，...

I have entities/relationships like following A -> B; B -> C, B -> D, B -> E, ...

当用户想要删除实体A时，我检查是否有其子B实体具有C实体和D实体等的任何记录，并提供详细的错误消息。

When a user wants to delete entity A, I check whether any of its children B entities have any records for C entities, and D entities, etc and provide a detailed error message.

但是，要求是我们最终可能会添加更多的实体类型，例如如B-> FutureEntity。有没有办法通用地检查所有这些方法，或者至少确保将来在添加了这样一个实体的情况下，我修改删除功能以解决这些实体？

However, the requirement is that we might end up adding more entity types such as B -> FutureEntity. Is there a way to either generically check for all of these, or atleast make sure that in the future if such an entity gets added, I modify the deletion functionality to account for such entities?

推荐答案

您可以通过在'BaseEntity'中添加以下功能来实现此目的：

You can achieve this by adding the following functions to the 'BaseEntity':

public abstract class BaseEntity
{

    [Key]
    public int Id { get; set; }

    public abstract bool IsChildOfBee();
    public abstract string GetDisplayName();
}

添加子实体时，请覆盖以下方法：

When you add a child entity override those methods:

public class EntityCee :BaseEntity
{
    public string Name { get; set; }


    public override string GetDisplayName()
    {
        return "Entity Cee";
    }

    public override bool IsChildOfBee()
    {
        return true;
    }
}

在删除实体B之前，请检查关联的实体：

Before you delete entity B, check the associated entities:

var errors = new List<string>();

var entityBeeToDelete = _exampleRepository.GetEntityBee(1);

var associatedEntities = _exampleRepository.GetAssociatedEntities(entityBeeToDelete);

foreach(var e in associatedEntities)
{
    errors.Add($"{entityBeeToDelete.GetDisplayName()} has some {e} records associated with it. Please delete those before deleting {entityBeeToDelete.GetDisplayName()}");
}

以下是检查关联子项的功能：

Here is the function that checks for associated children:

public List<string> GetAssociatedEntities(EntityBee bee)
{
    var types = new List<string>();

    foreach (var entityType in this.Model.GetEntityTypes())
    {
        var clr = entityType.ClrType;

        var tableName = entityType.Relational().TableName;

        BaseEntity instance = (BaseEntity)Activator.CreateInstance(clr);

        var isChildOfBee = instance.IsChildOfBee();

        if(isChildOfBee)
        {
            var query = $"select top(1) * from EntityBees where Id IN (select EntityBeeId from {tableName} where EntityBeeId = {bee.Id})";

            var eB = this.EntityBees.FromSql(query).FirstOrDefault();

            if(eB != null)
            {
                types.Add(instance.GetDisplayName());
            }

        }

    }
    return types;
}

这篇关于如何一般地检查实体/关系的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！