I am Trying to execute this
SessionAuto.ExecuteNonQuery("UPDATE LinhasPedidosPOS SET Quantidade = @qt WHERE ID = @id", new { Qt = qtd, linha.ID });
ID is a Guid Value
I get this error
Must declare the scalar variable "@qt".
if i use RepoDb to execute the same thing it works fine.
using SqlConnection db = AppHelper.CriarDbConnection;
db.ExecuteNonQuery("UPDATE LinhasPedidosPOS SET Quantidade = @qt WHERE ID = @id", new { Qt = qtd, linha.ID });
What can be the problem with this?
Thanks.
I am Trying to execute this
SessionAuto.ExecuteNonQuery("UPDATE LinhasPedidosPOS SET Quantidade = @qt WHERE ID = @id", new { Qt = qtd, linha.ID });
ID is a Guid Value
I get this error
Must declare the scalar variable "@qt".
if i use RepoDb to execute the same thing it works fine.
using SqlConnection db = AppHelper.CriarDbConnection;
db.ExecuteNonQuery("UPDATE LinhasPedidosPOS SET Quantidade = @qt WHERE ID = @id", new { Qt = qtd, linha.ID });
What can be the problem with this?
Thanks.