How to convert Linq to SQLCommand

Question

I have SQLCommand below but instead of writing SQL text inside method I would like to write entire SQL command in Linq to prevent Entities mismatch if POCO models are changed.

Database.ExecuteSqlCommand("UPDATE [Order] SET [Credits] = @Credits WHERE [Id] = @Id",
                        new SqlParameter("Credits", remainingCredits),
                        new SqlParameter("Id", order.Id));

@E.Vaughan actually it fails the first step of ["How to Ask"](http://stackoverflow.com/questions/how-to-ask) as it shows no attempt at researching the answer — Johanna Larsson, Nov 26 '13 at 08:51

score 0 · Answer 1 · edited Nov 26 '13 at 08:47

0

using(var context= new DbContext())
{
    var order = context.Orders.Where(x=>x.Id==Id).SingleOrDefault();
    if(!order)
        order.Credits = remainingCredits

    context.SaveChanges();
}

In order to be more specific, I should know the version of entity framework you use. However the general idea is the above.

edited Nov 26 '13 at 08:47

Stefan

17,448
11
60
79

answered Nov 26 '13 at 08:37

Christos

53,228
8
76
108

How to convert Linq to SQLCommand

1 Answers1