c# - 如何同时插入两个表？

Question

    StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO Threads(");//How can i modify that statement
sb.Append(" SELECT @Repuation, @WiningComment");
sb.Append(" FROM Users AS u");
sb.Append(" INNER JOIN Threads AS t ON t.UsersID=u.UsersID");
sb.Append(" WHERE t.ThreadsID=@ThreadID");

我有用户表和线程表。我想将@Reputation 插入到用户表中，将@winingComment 插入到threads 表中!!我该如何实现？

Answer 1

我建议你在 TRANSACTION 中做 2 个单独的 INSERT

BEGIN TRANSACTION
INSERT [...]
INSERT [...]
COMMIT TRANSACTION

从技术上讲，交易保证了您请求的原子性。