c# - 不带参数的 DbContext ExecuteSQLCommand

Question

我试图传入一个 SQL 字符串来删除一些记录。我正在使用 DbContext.Database.ExecuteSqlCommand 函数，但是除了 SQL 字符串之外，它还需要一个以下形式的参数列表:params Object[] parameters

因为我不需要发送任何参数，所以我尝试传递 null，但这会生成一个错误，指出 null 不是有效参数。我找不到该方法的重载。如何发送不需要额外参数的 SQL 命令？这是我的代码示例:

db.Database.ExecuteSqlCommand("DELETE FROM SignoffCommentAttachment 
WHERE SignoffCommentAttachment.SignoffCommentID 
IN (SELECT [SignoffCommentID] FROM [SignoffComments] 
WHERE SignoffID = " + signOffID.ToString() + ")", null);

Answer 1

parameters是一个params参数，所以你可以给它传0给很多对象。这应该有效

db.Database.ExecuteSqlCommand("DELETE FROM SignoffCommentAttachment WHERE SignoffCommentAttachment.SignoffCommentID IN (SELECT [SignoffCommentID] FROM [SignoffComments] WHERE SignoffID = " + signOffID.ToString() + ")");

不过，您确实应该参数化 signOffID。有点像

db.Database.ExecuteSqlCommand("DELETE FROM SignoffCommentAttachment WHERE SignoffCommentAttachment.SignoffCommentID IN (SELECT [SignoffCommentID] FROM [SignoffComments] WHERE SignoffID = {0})", signOffID);