Insert using Dapper on asp.net core

Question

using (IDbConnection dbConnection = openConnection)
{
    string uQuery = "INSERT INTO User (Email, UserName, Password)"
                    + " VALUES(@Email, @UserName, @Password)";
    dbConnection.Open();
    dbConnection.Execute(uQuery, User);
}

I'm getting a sql exception: Incorrect syntax near the keyword 'User'. on the db.Connection.Execute statement. I get the same error even if I omit the User parameter of the statement. Am I doing the insert wrong?

hakany · Accepted Answer · 2017-03-16 06:46:34Z

5

User is a reserved work in SQL server. Wrap User between brackets as [User] to solve.

Reference Reserved Keywords in SQL Server: https://msdn.microsoft.com/en-us/library/ms189822.aspx

Hope this helps.

edited Mar 16, 2017 at 6:46

answered Mar 16, 2017 at 6:35

hakany

7,2742 gold badges22 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

Insert using Dapper on asp.net core

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related