How to execute insert query using Entity Framework

Question

I am trying to execute a insert query using Entity Framework.

I have something like this:

Context.database.ExecuteSqlCommand("Insert into tableName Values({0},{1},{2}", param1, param2, param3)

but this is throwing an error

incorrect syntax near '@p1'

What is this '@p1' ?

why are you writing SQL in entity framework to do an insert? — DLeh
– DLeh, Commented Jul 10, 2015 at 14:05
@DLeh yes I agree, I would use Sql Command only to execute stored procedures — Andzej Maciusovic
– Andzej Maciusovic, Commented Jul 10, 2015 at 14:14
i need to do something as dynamic insertion to tables where destination table might change. And they need entity framework. And they has said to use dynamic insertion queries — Ajay George
– Ajay George, Commented Jul 10, 2015 at 14:15
@p1 is the name of the first parameter in the sql script generated by EF. — LCIII
– LCIII, Commented Jul 27, 2021 at 14:35

Marcos Dimitrio · Accepted Answer · 2016-08-15 20:01:22Z

17

You missing the closing ) at the end of your INSERT.

It should be:

Context.database.ExecuteSqlCommand("Insert into tableName Values({0},{1},{2})", param1, param2, param3)

Alternatively, you could use the SqlParameter class:

Context.Database.ExecuteSqlCommand(
    "Insert into tableName Values(@id, @firstName, @lastName)",
    new SqlParameter("id", id),
    new SqlParameter("firstName", firstName),
    new SqlParameter("lastName", lastName)
);

edited Aug 15, 2016 at 20:01

Marcos Dimitrio

6,9306 gold badges43 silver badges64 bronze badges

answered Jul 10, 2015 at 14:09

Andzej Maciusovic

4,5161 gold badge32 silver badges40 bronze badges

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

Comments

Micke · Accepted Answer · 2015-07-10 14:13:21Z

4

Apart from the obvious question why you are writing SQL, it seems you are missing a closing parenthesis, after the third {2} parameter:

Contex.database.ExecuteSQLCOmmand(@"Insert into tableName Values({0},{1},{2})",param1,param2,param3);

Then it is also a good practise to specify column names, like so:

Contex.database.ExecuteSQLCOmmand(@"Insert into tableName (col1, col2, col3) Values({0},{1},{2})",param1,param2,param3);

answered Jul 10, 2015 at 14:13

Micke

2,3295 gold badges34 silver badges48 bronze badges

Collectives™ on Stack Overflow

How to execute insert query using Entity Framework

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related