public virtual string GetInsertScript([NotNull] HistoryRow row)
{
Check.NotNull(row, nameof(row));
return(new StringBuilder().Append("INSERT INTO ")
.Append(SqlGenerationHelper.DelimitIdentifier(TableName, TableSchema))
.Append(" (")
.Append(SqlGenerationHelper.DelimitIdentifier(MigrationIdColumnName))
.Append(", ")
.Append(SqlGenerationHelper.DelimitIdentifier(ProductVersionColumnName))
.AppendLine(")")
.Append("VALUES ('")
.Append(SqlGenerationHelper.EscapeLiteral(row.MigrationId))
.Append("', '")
.Append(SqlGenerationHelper.EscapeLiteral(row.ProductVersion))
.AppendLine("');")
.ToString());
}
/// <summary>
/// Generates a SQL script to insert a row into the history table.
/// </summary>
/// <param name="row">The row to insert, represented as a <see cref="HistoryRow" /> entity.</param>
/// <returns>The generated SQL.</returns>
public virtual string GetInsertScript(HistoryRow row)
{
var stringTypeMapping = Dependencies.TypeMappingSource.GetMapping(typeof(string));
return(new StringBuilder().Append("INSERT INTO ")
.Append(SqlGenerationHelper.DelimitIdentifier(TableName, TableSchema))
.Append(" (")
.Append(SqlGenerationHelper.DelimitIdentifier(MigrationIdColumnName))
.Append(", ")
.Append(SqlGenerationHelper.DelimitIdentifier(ProductVersionColumnName))
.AppendLine(")")
.Append("VALUES (")
.Append(stringTypeMapping.GenerateSqlLiteral(row.MigrationId))
.Append(", ")
.Append(stringTypeMapping.GenerateSqlLiteral(row.ProductVersion))
.Append(')')
.AppendLine(SqlGenerationHelper.StatementTerminator)
.ToString());
}
public virtual string GetInsertScript(HistoryRow row)
{
Check.NotNull(row, nameof(row));
return new StringBuilder().Append("INSERT INTO ")
.Append(SqlGenerationHelper.DelimitIdentifier(TableName, TableSchema))
.Append(" (")
.Append(SqlGenerationHelper.DelimitIdentifier(MigrationIdColumnName))
.Append(", ")
.Append(SqlGenerationHelper.DelimitIdentifier(ProductVersionColumnName))
.AppendLine(")")
.Append("VALUES ('")
.Append(SqlGenerationHelper.EscapeLiteral(row.MigrationId))
.Append("', '")
.Append(SqlGenerationHelper.EscapeLiteral(row.ProductVersion))
.AppendLine("');")
.ToString();
}
