Sql update statement with named parameters

Question

public void UpdateRegistration(User userModel)
    {
        using (IDbConnection connection = BaseRepository.OpenConnection())
        {
            string query = "UPDATE [dbo].[TBUser] " +
                "(CreatedBy, CreatedDate, ModifiedBy, ModifiedDate) VALUES " +
                "(@CreatedBy, @CreatedDate, @ModifiedBy, @ModifiedDate) WHERE " +
                "UserId = @UserId;";
            connection.Execute(query, userModel);
        }
    }

I get the following exception while it runs

<Message>An error has occurred.</Message>
<ExceptionMessage>Incorrect syntax near '('.</ExceptionMessage>
<ExceptionType>System.Data.SqlClient.SqlException</ExceptionType>

userModel has all of the properties associated with it.

podiluska · Accepted Answer · 2014-03-05 13:42:12Z

3

The syntax is

UPDATE [table]
SET [field] = Value
WHERE ....

See http://technet.microsoft.com/en-us/library/ms177523.aspx

So your query should be

UPDATE [dbo].[TBUser] 
SET CreatedBy = @CreatedBy, 
    CreatedDate = @CreatedDate,
    ModifiedBy = @ModifiedBy,
    ModifiedDate = @ModifiedDate
WHERE UserId = @UserId;

answered Mar 5, 2014 at 13:42

podiluska

51.6k7 gold badges102 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sql update statement with named parameters

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related