Ejemplos de InsertStatement.ToSql en C# (CSharp)

Ejemplo n.º 1

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

Ejemplo n.º 2

Archivo: GivenInsertStatement.cs Proyecto: slocld/awesome-sql-builder

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

Ejemplo n.º 3

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

Ejemplo n.º 4

Archivo: GivenInsertStatement.cs Proyecto: slocld/awesome-sql-builder

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