internal static string CommaSeparatedUpdateFromParameters(SyncTable table, string fromPrefix = "")
{
var stringBuilder = new StringBuilder();
string strFromPrefix = (string.IsNullOrEmpty(fromPrefix) ? string.Empty : string.Concat(fromPrefix, "."));
string strSeparator = "";
foreach (var mutableColumn in table.GetMutableColumns())
{
var quotedColumn = ParserName.Parse(mutableColumn, "`");
stringBuilder.AppendLine($"{strSeparator} {strFromPrefix}{quotedColumn.Quoted().ToString()} = {MySqlBuilderProcedure.MYSQL_PREFIX_PARAMETER}{quotedColumn.Unquoted().Normalized().ToString()}");
strSeparator = ", ";
}
return(stringBuilder.ToString());
}
public static string CommaSeparatedUpdateFromParameters(SyncTable table, string fromPrefix = "")
{
StringBuilder stringBuilder = new StringBuilder();
string strFromPrefix = (string.IsNullOrEmpty(fromPrefix) ? string.Empty : string.Concat(fromPrefix, "."));
string strSeparator = "";
foreach (var mutableColumn in table.GetMutableColumns(false))
{
var quotedColumn = ParserName.Parse(mutableColumn).Quoted().ToString();
var unquotedColumn = ParserName.Parse(mutableColumn).Unquoted().Normalized().ToString();
stringBuilder.AppendLine($"{strSeparator} {strFromPrefix}{quotedColumn} = @{unquotedColumn}");
strSeparator = ", ";
}
return(stringBuilder.ToString());
}