public string UpdateUserProfile(
IEnumerable<SettingsPropertyValue> properties, string userName, out object[] values)
{
var builder = new StringBuilder("Update ").Append(this.userTableName).Append(" Set ");
var sets = new List<string>();
var propertyValues = new List<object>();
var i = 1;
propertyValues.Add(userName);
foreach (SettingsPropertyValue property in properties)
{
sets.Add(string.Format("{0} = @{1}", property.Name, i));
propertyValues.Add(property.PropertyValue);
i++;
}
values = propertyValues.ToArray();
builder.Append(string.Join(",", sets));
builder.Append(" Where ").Append(this.userNameColumn).Append(" = @0");
return builder.ToString();
}