Does ria services have something like sqlclient SqlCommand for executing T-SQL?

Question

How would ria services do this kind of thing?

using (SqlConnection connection = new SqlConnection(connectionString))
{
    string TSQL="update products set price=price*1.03 where category='computer books'";
    SqlCommand command = new SqlCommand(TSQL, connection);
    command.Connection.Open();
    command.ExecuteNonQuery();
}

Thanks, Mark

Answer 1

Hi Mark,

You need get all entites of Product with category computer books and then update price for them and save changes to DB.