想要在事务中的后续插入中使用从插入返回的身份

发布于 2024-10-26 16:38:03 字数 824 浏览 2 评论 0原文

我使用 Rob Conery 的 Massive 进行数据库访问。我想将事务包装在几个插入中，但第二个插入使用从第一个插入返回的标识。对于我来说，如何在交易中做到这一点并不明显。一些帮助将不胜感激。

var commandList = new List<DbCommand>
    {
        contactTbl.CreateInsertCommand(new
            {
                newContact.Name,
                newContact.Contact,
                newContact.Phone,
                newContact.ForceChargeThreshold,
                newContact.MeterReadingMethodId,
                LastModifiedBy = userId,
                LastModifiedDate = modifiedDate,
            }),
        branchContactTbl.CreateInsertCommand(new
            {
                newContact.BranchId,
                ContactId = ????, <-- how to set Id as identity from previous command
            }),
    };

原文

I'm using Rob Conery's Massive for database access. I want to wrap a transaction around a couple of inserts but the second insert uses the identity returned from the first insert. It's not obvious to me how to do this in a transaction. Some assistance would be appreciated.

var commandList = new List<DbCommand>
    {
        contactTbl.CreateInsertCommand(new
            {
                newContact.Name,
                newContact.Contact,
                newContact.Phone,
                newContact.ForceChargeThreshold,
                newContact.MeterReadingMethodId,
                LastModifiedBy = userId,
                LastModifiedDate = modifiedDate,
            }),
        branchContactTbl.CreateInsertCommand(new
            {
                newContact.BranchId,
                ContactId = ????, <-- how to set Id as identity from previous command
            }),
    };

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

不弃不离 2024-11-02 16:38:03

在这两个插入之间进行查询，Massive 中的此方法可能很有用：

public object Scalar(string sql, params object[] args) {
    object result = null;
    using (var conn = OpenConnection()) {
        result = CreateCommand(sql, conn, args).ExecuteScalar();
    }
    return result;
}

您的 sql 将 = "selectscope_identity()"

UPDATE 2013/02/26

再次查看 Massive 代码，没有可靠的方法检索最后插入的 ID 的方法。

上面的代码仅在创建“selectscope_identity()”的连接被池化时才有效。（必须与插入的连接相同）。

Massive table.Insert(..) 方法返回包含 ID 字段的 Dynamic，该字段填充为“SELECT @@IDENTITY”。它从全局范围获取最后插入的 ID，这是一个明显的错误（在多线程场景中很明显）。

Make a query between those two inserts, this method from Massive may be useful:

public object Scalar(string sql, params object[] args) {
    object result = null;
    using (var conn = OpenConnection()) {
        result = CreateCommand(sql, conn, args).ExecuteScalar();
    }
    return result;
}

Your sql will be = "select scope_identity()"

UPDATE 2013/02/26

Looking again at the Massive code there is no reliable way to retrieve last inserted ID.

Code above will work only when connection that makes "select scope_identity()" is pooled. (It must be the same connection that made insert).

Massive table.Insert(..) method returns Dynamic that contains ID field, which is filled with "SELECT @@IDENTITY". It gets last inserted ID from global scope, which is obvious bug (apparent in multithreading scenarios).

回复收藏 0 原文