c# - 使用 ormlite (SQL Server) 和 C# 中的存储过程删除和更新

Question

尝试使用 ormlite 中的存储过程进行更新。我目前有这个，但它似乎没有用。没有错误显示，只是什么都不做。

public void UpdateUsers(DATOS.Users users)
{
    _db.SqlScalar<DATOS.Users>("exec updateUsers set @Username, @password, @id_room, @id_rol", new { Username = users.Username, Password = users.password, Id_room = users.id_room, id_rol = users.id_rol });
}

另外，删除的技巧是什么？

Answer 1

如果存储过程不返回任何内容，请使用 db.ExecuteSql()相反，例如:

db.ExecuteSql("exec updateUsers @Username, @password, @id_room, @id_rol", 
    new { Username = users.Username, 
          Password = users.password, 
          Id_room = users.id_room, 
          id_rol = users.id_rol });

与删除一样:

db.ExecuteSql("exec deleteUsers @Username, @password, @id_room, @id_rol", 
    new { Username = users.Username, 
          Password = users.password, 
          Id_room = users.id_room, 
          id_rol = users.id_rol });