How would I add a parameter to entity framework raw sql command

Question

How would I add a parameter to entity framework raw sql command

c# entity-framework

Question

How would I add a parameter to following Entity Framework raw SQL command? For example, what if I wanted to make the Id a parameter?

        using (var context = new NorthwindDBEntities())
        {
            context.Database.ExecuteSqlCommand(@"
                UPDATE dbo.Customers 
                SET Name = 'Test' WHERE Id = 1
            ");

        }

Rod

Popular Answer

The following code should work for this scenario:

    using (var context = new NorthwindDBEntities())
    {
        context.Database.ExecuteSqlCommand(@"
            UPDATE dbo.Customers 
            SET Name = 'Test' WHERE Id = {0}
        ", 1);
    }

You can also use SqlParameter and use @id:

    using (var context = new NorthwindDBEntities())
    {
        context.Database.ExecuteSqlCommand(@"
            UPDATE dbo.Customers 
            SET Name = 'Test' WHERE Id = @id
        ", new SqlParameter("id", 1));
    }

Plymouth223

View more on Stack Overflow

Damith · Accepted Answer · 6/13/2016 7:27:00 PM

context.Database.ExecuteSqlCommand(@"UPDATE dbo.Customers 
            SET Name = 'Test' WHERE Id = @Id", new SqlParameter("Id", 1));

in case of multiple parameters

context.Database.ExecuteSqlCommand(@"UPDATE dbo.Customers 
            SET Name = 'Test' WHERE Id = @id and Name =@name", 
               new SqlParameter("Id", id),
               new SqlParameter("name", fname));

How would I add a parameter to entity framework raw sql command

Question

Fastest Entity Framework Extensions

Accepted Answer

Popular Answer

Performance

Expression Evaluator

Related