public static ReadOnlyCollection <Line> CreateSqlUpdateStatement(OrmSampleTable record)
{
var identifier = new UpdateSqlStatementFactory.Column("Id", record.Id.ToSqlConstant());
var columns = new[]
{
new UpdateSqlStatementFactory.Column("Text", record.Text.ToNVarChar()),
new UpdateSqlStatementFactory.Column("Version", record.Version.ToSqlConstant()),
new UpdateSqlStatementFactory.Column("Timestamp", record.Timestamp.ToSqlConstant())
};
var updateSqlStatement = UpdateSqlStatementFactory.Create("dbo.OrmSampleTable", identifier, columns);
return(updateSqlStatement);
}
public static ReadOnlyCollection <Line> CreateUpdateSqlStatement(OrmSampleTable record, long expectedVersion)
{
var setColumns = new[]
{
new ColumnNameValue("Version", record.Version.ToSqlConstant()),
new ColumnNameValue("Text", record.Text.ToNullableNVarChar()),
new ColumnNameValue("Timestamp", record.Timestamp.ToSqlConstant())
};
var whereColumns = new[]
{
new ColumnNameValue("Id", record.Id.ToSqlConstant()),
new ColumnNameValue("Version", expectedVersion.ToSqlConstant())
};
var updateSqlStatement = UpdateSqlStatementFactory.Create("dbo.OrmSampleTable", setColumns, whereColumns);
var validation = ValidationFactory.Create("update dbo.OrmSampleTable failed");
var textBuilder = new TextBuilder();
textBuilder.Add(updateSqlStatement);
textBuilder.Add(validation);
return(textBuilder.ToLines());
}
