public void Build_OrderByAfterOr_ReturnsExpected()
{
var expected = "SELECT * FROM Users WHERE IsActive = 1 OR 2=2 ORDER BY UserName";
var actual = new MsSqlQuery()
.Select()
.From("Users")
.Where("IsActive = 1")
.Or("2=2")
.OrderBy("UserName")
.Build().Query;
Assert.Equal(expected, actual);
}
public void Build_WhereWithParameter_ReturnsExpected()
{
var expected = "SELECT * FROM Users WHERE IsActive = @p1";
var actual = new MsSqlQuery()
.Select()
.From("Users")
.Where("IsActive", 1)
.Build();
Assert.Equal(expected, actual.Query);
Assert.Equal("@p1", actual.Parameters.Single().Name);
Assert.Equal(1, actual.Parameters.Single().Value);
}
public void Build_WhereAnd_ReturnsExpected()
{
var expected = "SELECT * FROM Users INNER JOIN Roles ON Users.RoleId = Roles.RoleId WHERE 1=1 AND 2=2";
var actual = new MsSqlQuery()
.Select()
.From("Users")
.Join("Roles", "Users.RoleId = Roles.RoleId")
.Where("1=1")
.And("2=2")
.Build().Query;
Assert.Equal(expected, actual);
}
public void Build_TwoJoins_ReturnsExpected()
{
var expected = "SELECT * FROM Users " +
"INNER JOIN Roles ON Users.RoleId = Roles.RoleId " +
"INNER JOIN UserSettings ON Users.UserId = UserSettings.UserId";
var actual = new MsSqlQuery()
.Select()
.From("Users")
.Join("Roles", "Users.RoleId = Roles.RoleId")
.Join("UserSettings", "Users.UserId = UserSettings.UserId")
.Build().Query;
Assert.Equal(expected, actual);
}
