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