public void SetUp()
        {
            _columnDefinition = ColumnDefinitionObjectMother.CreateColumn("Column", StorageTypeInformationObjectMother.CreateVarchar100StorageTypeInformation());
            _objectValue1     = "<Test1";
            _objectValue2     = 689;
            _objectValue3     = true;

            _specification = new SqlXmlSetComparedColumnSpecification(_columnDefinition, new[] { _objectValue1, _objectValue2, _objectValue3 });

            _statement = new StringBuilder();

            _parametersCollectionMock = MockRepository.GenerateStrictMock <IDataParameterCollection> ();

            _commandStub = MockRepository.GenerateStub <IDbCommand> ();
            _commandStub.Stub(stub => stub.Parameters).Return(_parametersCollectionMock);

            _parameterStub = MockRepository.GenerateStub <IDbDataParameter>();
            _commandStub.Stub(stub => stub.CreateParameter()).Return(_parameterStub);

            _sqlDialectStub = MockRepository.GenerateStub <ISqlDialect> ();
            _sqlDialectStub.Stub(stub => stub.StatementDelimiter).Return("delimiter");
        }
        public void AddParameters_NullValue()
        {
            _specification = new SqlXmlSetComparedColumnSpecification(_columnDefinition, new[] { _objectValue1, null, _objectValue3 });

            _specification.AddParameters(_commandStub, _sqlDialectStub);
        }