public void When_inserting_from_select_Then_builds_properly() { var select = SqlStatements.Select("Name", "EmailAddress") .From("Users") .InnerJoin("Teams", "Users.TeamID = Teams.ID") .Where("Teams.IsOld = FALSE"); var statement = new InsertStatement(select) .Into("Users"); var sql = statement.ToSql(); Assert.That( sql, SqlCompareConstraint.EqualTo(@"INSERT INTO Users ( Name, EmailAddress ) SELECT Name, EmailAddress FROM Users INNER JOIN Teams ON Users.TeamID = Teams.ID WHERE Teams.IsOld = FALSE")); }
public void When_inserting_one_row_Then_builds_properly() { var statement = new InsertStatement(new[] { "Name", "EmailAddress" }) .Into("Users"); var sql = statement.ToSql(); sql.Should().BeEquivalentToIgnoringNewLines(@"INSERT INTO Users ( Name, EmailAddress ) VALUES ( @Name, @EmailAddress )"); }
public void When_inserting_one_row_Then_builds_properly() { var statement = new InsertStatement(new[] { "Name", "EmailAddress" }) .Into("Users"); var sql = statement.ToSql(); Assert.That( sql, SqlCompareConstraint.EqualTo(@"INSERT INTO Users ( Name, EmailAddress ) VALUES ( @Name, @EmailAddress )")); }
public void When_inserting_from_select_Then_builds_properly() { var select = SqlStatements.Select("Name", "EmailAddress") .From("Users") .InnerJoin("Teams", "Users.TeamID = Teams.ID") .Where("Teams.IsOld = FALSE"); var statement = new InsertStatement(select) .Into("Users"); var sql = statement.ToSql(); sql.Should().BeEquivalentToIgnoringNewLines(@"INSERT INTO Users ( Name, EmailAddress ) SELECT Name, EmailAddress FROM Users INNER JOIN Teams ON Users.TeamID = Teams.ID WHERE Teams.IsOld = FALSE"); }