How to update a record using Subsonic 3

 

How to update a record using Subsonic 3 and SQL.

catalog.data.catalogDB WDB = new catalog.data.catalogDB();

string query = "UPDATE TableName SET FieldName= @Parameter WHERE FieldName = "+Value

QueryCommand q = new QueryCommand(query, WDB.DataProvider);

q.Parameters.Add("@Parameter", Value, DbType.DataBaseType);

 

WDB.DataProvider.ExecuteScalar(q);