SubSonic 3 / ActiveRecord - 比较两个记录的简单方法？

发布于 2024-08-01 19:10:47 字数 767 浏览 2 评论 0原文

使用 SubSonic 3 / ActiveRecord，是否有一种简单的方法可以比较两个记录，而无需逐列比较。例如，我想要一个执行类似操作的函数（无需为数据库中的每个表编写自定义比较器）：

public partial class MyTable
{
    public IList<SubSonic.Schema.IColumn> Compare(MyTable m)
    {
        IList<SubSonic.Schema.IColumn> columnsThatDontMatch = new...;
        if (this.Field1 != m.Field1)
        {
            columnsThatDontMatch.add(Field1_Column);
        }
        if (this.Field2 != m.Field2)
        {
            columnsThatDontMatch.add(Field2_Column);
        }
        ...
        return columnsThatDontMatch;
    }
}

最后，我真正需要的是一个测试两行之间是否相等的函数，不包括主键列。上面的伪代码是更通用的形式。我相信，一旦获得不匹配的列，我将能够检查是否有任何列是主键字段。

我查看了 Columns 属性，但没有找到任何可以使用的东西。理想情况下，解决方案是我可以将其放入 t4 文件并为数据库中的所有表生成的内容。

原文

With SubSonic 3 / ActiveRecord, is there an easy way to compare two records without having to compare each column by column. For example, I'd like a function that does something like this (without having to write a custom comparer for each table in my database):

public partial class MyTable
{
    public IList<SubSonic.Schema.IColumn> Compare(MyTable m)
    {
        IList<SubSonic.Schema.IColumn> columnsThatDontMatch = new...;
        if (this.Field1 != m.Field1)
        {
            columnsThatDontMatch.add(Field1_Column);
        }
        if (this.Field2 != m.Field2)
        {
            columnsThatDontMatch.add(Field2_Column);
        }
        ...
        return columnsThatDontMatch;
    }
}

In the end, what I really need is a function that tests for equality between two rows, excluding the primary key columns. The pseudo-code above is a more general form of this. I believe that once I get the columns that don't match, I'll be able to check if any of the columns are primary key fields.

I've looked through Columns property without finding anything that I can use. Ideally, the solution would be something I can toss in the t4 file and generate for all my tables in the database.

分享到QQ

分享到微博