public void TheConnectionStringIsSetAndANewInsertHasTheSameColumns()
        {
            const string connection = "some connection";

            var insertStatement = new Insert(SomeTable)[FirstColumn.WillBe(FirstValue)].ConnectTo(connection);
            var newStatement = insertStatement.ConnectTo(connection);

            newStatement.Columns.Should().BeEquivalentTo(insertStatement.Columns);
        }
        public void ANewInsertIsCreatedWhenSettingTheColumnsAndTheConnectionIsTheSame()
        {
            const string firstConnection = "connectionA";
            const string secondConnection = "connectionB";

            var insertStatement = new Insert(SomeTable)[FirstColumn.WillBe(_fakeValue)].ConnectTo(firstConnection);
            var newStatement = insertStatement.ConnectTo(secondConnection);

            var connectionA = RetrieveValueFromObject(insertStatement, ConnectionKeyword);
            var connectionB = RetrieveValueFromObject(newStatement, ConnectionKeyword);

             connectionA.Should().Be(connectionB);
        }
        public void TheConnectionStringIsSetAndANewInsertIsCreated()
        {
            const string connection = "some connection";

            var insertStatement = new Insert(SomeTable).ConnectTo(connection);
            var newStatement = insertStatement.ConnectTo(connection);

            insertStatement.Should().NotBe(newStatement);
        }