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()); }