public void ShoulCreateUpdateCommandWithTableSchema()
{
FlepperQueryBuilder.Update("dbo", "table")
.Build()
.Trim()
.Should()
.Be("UPDATE [dbo].[table]");
}
public void ShoulCreateUpdateCommand()
{
FlepperQueryBuilder.Update("table")
.Build()
.Trim()
.Should()
.Be("UPDATE [table]");
}
public void ShouldCreateUpdateCommandWithColumnAndValue()
{
var queryResult = FlepperQueryBuilder.Update("dbo", "table")
.Set("column", "value")
.BuildWithParameters();
queryResult
.Query
.Trim()
.Should()
.Be("UPDATE [dbo].[table] SET [column] = @p0");
dynamic parameters = queryResult.Parameters;
Assert.Equal("value", parameters.@p0);
}
