tags:

views:

23

answers:

1

I want to update multiple rows in my SQL database using subsonic but I can't figure out how to do it. What's the easiest way of doing it?

It would be something like this in sql : UPDATE table SET rowItem = 4 WHERE row_item = 3

A: 
 new (DataBaseName)DB().Update<ClassName>()
                        .Set(x => x.rowItem == 4)
                        .Where(x => x.row_item == 3).Execute();
Rady