public void TestThatDisposeCanBeCalledMoreThanOnce() { using (var oracleClient = new OracleClient()) { Assert.That(oracleClient, Is.Not.Null); oracleClient.Dispose(); oracleClient.Dispose(); } }
public void TestThatValidateTableThrowsDeliveryEngineMetadataExceptionIfColumnDoesNotExist() { var fixture = new Fixture(); var fieldCollectionMock = new List <IField>(1) { MockRepository.GenerateMock <IField>() }; fieldCollectionMock.ElementAt(0).Expect(m => m.NameSource) .Return(fixture.CreateAnonymous <string>()) .Repeat.Any(); var tableMock = MockRepository.GenerateMock <ITable>(); tableMock.Expect(m => m.NameSource) .Return("TABEL") .Repeat.Any(); tableMock.Expect(m => m.Fields) .Return(new ReadOnlyObservableCollection <IField>(new ObservableCollection <IField>(fieldCollectionMock))) .Repeat.Any(); using (var oracleClient = new OracleClient()) { Assert.Throws <DeliveryEngineMetadataException>(() => oracleClient.ValidateTable(tableMock)); oracleClient.Dispose(); } tableMock.AssertWasCalled(m => m.Fields); fieldCollectionMock.ElementAt(0).AssertWasCalled(m => m.NameSource); }
public void TestThatValidateTableThrowsDeliveryEngineMetadataExceptionIfDatatypeFromDatabaseCanNotBeMapped() { var fieldCollectionMock = new List <IField>(1) { MockRepository.GenerateMock <IField>() }; fieldCollectionMock.ElementAt(0).Expect(m => m.NameSource) .Return("SYSTEM_NR") .Repeat.Any(); fieldCollectionMock.ElementAt(0).Expect(m => m.DatatypeOfSource) .Return(typeof(string)) .Repeat.Any(); var tableMock = MockRepository.GenerateMock <ITable>(); tableMock.Expect(m => m.NameSource) .Return("TABEL") .Repeat.Any(); tableMock.Expect(m => m.Fields) .Return(new ReadOnlyObservableCollection <IField>(new ObservableCollection <IField>(fieldCollectionMock))) .Repeat.Any(); using (var oracleClient = new OracleClient()) { Assert.Throws <DeliveryEngineMetadataException>(() => oracleClient.ValidateTable(tableMock)); oracleClient.Dispose(); } tableMock.AssertWasCalled(m => m.Fields); fieldCollectionMock.ElementAt(0).AssertWasCalled(m => m.DatatypeOfSource); }
public void TestThatValidateTableThrowsArgumentNullExceptionIfTableIsNull() { using (var oracleClient = new OracleClient()) { Assert.Throws <ArgumentNullException>(() => oracleClient.ValidateTable(null)); oracleClient.Dispose(); } }
public void TestThatConstructorInitializeOracleClient() { using (var oracleClient = new OracleClient()) { Assert.That(oracleClient, Is.Not.Null); oracleClient.Dispose(); } }
public void TestThatGetNumberOfEqualKeyValuesThrowsArgumentNullExceptionIfExtraCriteriasIsNull() { var fixture = new Fixture(); fixture.Customize <IKey>(e => e.FromFactory(() => MockRepository.GenerateMock <IKey>())); using (var oracleClient = new OracleClient()) { Assert.Throws <ArgumentNullException>(() => oracleClient.GetNumberOfEqualKeyValues(fixture.CreateAnonymous <IKey>(), null, fixture.CreateAnonymous <string>())); oracleClient.Dispose(); } }
public void TestThatGetNumberOfEqualKeyValuesThrowsArgumentNullExceptionIfKeyIsNull() { var fixture = new Fixture(); fixture.Customize <KeyValuePair <string, object> >(e => e.FromFactory(() => new KeyValuePair <string, object>(fixture.CreateAnonymous <string>(), fixture.CreateAnonymous <object>()))); using (var oracleClient = new OracleClient()) { Assert.Throws <ArgumentNullException>(() => oracleClient.GetNumberOfEqualKeyValues(null, fixture.CreateMany <KeyValuePair <string, object> >(5).ToList(), fixture.CreateAnonymous <string>())); oracleClient.Dispose(); } }
public void TestThatGetNumberOfEqualKeyValuesThrowsArgumentNullExceptionIfMatchingKeyValueIsEmpty() { var fixture = new Fixture(); fixture.Customize <IKey>(e => e.FromFactory(() => MockRepository.GenerateMock <IKey>())); fixture.Customize <KeyValuePair <string, object> >(e => e.FromFactory(() => new KeyValuePair <string, object>(fixture.CreateAnonymous <string>(), fixture.CreateAnonymous <object>()))); using (var oracleClient = new OracleClient()) { Assert.Throws <ArgumentNullException>(() => oracleClient.GetNumberOfEqualKeyValues(fixture.CreateAnonymous <IKey>(), fixture.CreateMany <KeyValuePair <string, object> >(5).ToList(), string.Empty)); oracleClient.Dispose(); } }
public void TestThatValidateTableThrowsDeliveryEngineMetadataExceptionIfTableDoesNotExist() { var fixture = new Fixture(); var tableMock = MockRepository.GenerateMock <ITable>(); tableMock.Expect(m => m.NameSource) .Return(fixture.CreateAnonymous <string>()) .Repeat.Any(); using (var oracleClient = new OracleClient()) { Assert.Throws <DeliveryEngineMetadataException>(() => oracleClient.ValidateTable(tableMock)); oracleClient.Dispose(); } tableMock.AssertWasCalled(m => m.NameSource); }
public void TestThatGetDataThrowsArgumentNullExceptionIfOnHandleOracleDataIsNull() { var fixture = new Fixture(); fixture.Customize <ITable>(e => e.FromFactory(() => MockRepository.GenerateMock <ITable>())); var tableMock = fixture.CreateAnonymous <ITable>(); using (var oracleClient = new OracleClient()) { Assert.Throws <ArgumentNullException>(() => oracleClient.GetData(tableMock, null)); oracleClient.Dispose(); } tableMock.AssertWasNotCalled(m => m.Fields); tableMock.AssertWasNotCalled(m => m.RecordFilters); tableMock.AssertWasNotCalled(m => m.PrimaryKey); tableMock.AssertWasNotCalled(m => m.NameSource); }
public void TestThatGetDataThrowsArgumentNullExceptionIfTableIsNull() { var fixture = new Fixture(); fixture.Customize <IHandleDataEventArgs>(e => e.FromFactory(() => MockRepository.GenerateMock <IHandleDataEventArgs>())); DeliveryEngineEventHandler <IHandleDataEventArgs> onHandleOracleData = (s, e) => { Assert.That(s, Is.Not.Null); Assert.That(e, Is.Not.Null); }; onHandleOracleData.Invoke(fixture.CreateAnonymous <object>(), fixture.CreateAnonymous <IHandleDataEventArgs>()); using (var oracleClient = new OracleClient()) { Assert.Throws <ArgumentNullException>(() => oracleClient.GetData(null, onHandleOracleData)); oracleClient.Dispose(); } }
public void TestThatGetNumberOfEqualKeyValuesThrowsDeliveryEngineMetadataExceptionIfTableIsNullOnKey() { var fixture = new Fixture(); fixture.Customize <KeyValuePair <string, object> >(e => e.FromFactory(() => new KeyValuePair <string, object>(fixture.CreateAnonymous <string>(), fixture.CreateAnonymous <object>()))); var keyMock = MockRepository.GenerateMock <IKey>(); keyMock.Expect(m => m.Table) .Return(null) .Repeat.Any(); using (var oracleClient = new OracleClient()) { Assert.Throws <DeliveryEngineMetadataException>(() => oracleClient.GetNumberOfEqualKeyValues(keyMock, fixture.CreateMany <KeyValuePair <string, object> >(5).ToList(), fixture.CreateAnonymous <string>())); oracleClient.Dispose(); } keyMock.AssertWasCalled(m => m.Table); }
public void TestThatSelectCountForTableGetNumberOfRecordsWithoutRecordFilters() { var tableMock = MockRepository.GenerateMock <ITable>(); tableMock.Expect(m => m.NameSource) .Return("TABEL") .Repeat.Any(); tableMock.Expect(m => m.RecordFilters) .Return(new ReadOnlyObservableCollection <IFilter>(new ObservableCollection <IFilter>(new List <IFilter>(0)))) .Repeat.Any(); using (var oracleClient = new OracleClient()) { var numberOfRecords = oracleClient.SelectCountForTable(tableMock); Assert.That(numberOfRecords, Is.GreaterThan(0)); oracleClient.Dispose(); } tableMock.AssertWasCalled(m => m.NameSource); tableMock.AssertWasCalled(m => m.RecordFilters); }
public void TestThatSelectCountForTableGetNumberOfRecordsWithRecordFilters() { var firstFilter = MockRepository.GenerateMock <IFilter>(); firstFilter.Expect(m => m.AsSql()) .Return("SYSTEM_NR=0 AND TABEL=0 AND NR='00'") .Repeat.Any(); var secordFilter = MockRepository.GenerateMock <IFilter>(); secordFilter.Expect(m => m.AsSql()) .Return("SYSTEM_NR=0 AND TABEL=0 AND NR='01'") .Repeat.Any(); var tableMock = MockRepository.GenerateMock <ITable>(); tableMock.Expect(m => m.NameSource) .Return("TABEL") .Repeat.Any(); tableMock.Expect(m => m.RecordFilters) .Return(new ReadOnlyObservableCollection <IFilter>(new ObservableCollection <IFilter>(new List <IFilter> { firstFilter, secordFilter }))) .Repeat.Any(); using (var oracleClient = new OracleClient()) { var numberOfRecords = oracleClient.SelectCountForTable(tableMock); Assert.That(numberOfRecords, Is.EqualTo(2)); oracleClient.Dispose(); } tableMock.AssertWasCalled(m => m.NameSource); tableMock.AssertWasCalled(m => m.RecordFilters); firstFilter.AssertWasCalled(m => m.AsSql()); secordFilter.AssertWasCalled(m => m.AsSql()); }
public void TestThatGetNumberOfEqualKeyValuesGetsNumberOfEqualKeyValuesForKeyWhereThereMultipleRecords() { var fieldCollection = new List <IField> { MockRepository.GenerateMock <IField>(), MockRepository.GenerateMock <IField>(), MockRepository.GenerateMock <IField>(), MockRepository.GenerateMock <IField>() }; fieldCollection.ElementAt(0).Expect(m => m.NameSource) .Return("SYSTEM_NR") .Repeat.Any(); fieldCollection.ElementAt(0).Expect(m => m.DatatypeOfSource) .Return(typeof(int?)) .Repeat.Any(); fieldCollection.ElementAt(0).Expect(m => m.DatatypeOfTarget) .Return(typeof(int?)) .Repeat.Any(); fieldCollection.ElementAt(1).Expect(m => m.NameSource) .Return("TABEL") .Repeat.Any(); fieldCollection.ElementAt(1).Expect(m => m.DatatypeOfSource) .Return(typeof(int?)) .Repeat.Any(); fieldCollection.ElementAt(1).Expect(m => m.DatatypeOfTarget) .Return(typeof(int?)) .Repeat.Any(); fieldCollection.ElementAt(2).Expect(m => m.NameSource) .Return("NR") .Repeat.Any(); fieldCollection.ElementAt(2).Expect(m => m.DatatypeOfSource) .Return(typeof(string)) .Repeat.Any(); fieldCollection.ElementAt(2).Expect(m => m.DatatypeOfTarget) .Return(typeof(string)) .Repeat.Any(); fieldCollection.ElementAt(3).Expect(m => m.NameSource) .Return("TEKST") .Repeat.Any(); fieldCollection.ElementAt(3).Expect(m => m.DatatypeOfSource) .Return(typeof(string)) .Repeat.Any(); fieldCollection.ElementAt(3).Expect(m => m.DatatypeOfTarget) .Return(typeof(string)) .Repeat.Any(); var filterCollection = new List <IFilter>(); var tableMock = MockRepository.GenerateMock <ITable>(); var keyMock = MockRepository.GenerateMock <ICandidateKey>(); keyMock.Expect(m => m.Table) .Return(tableMock) .Repeat.Any(); keyMock.Expect(m => m.Fields) .Return(new ReadOnlyObservableCollection <KeyValuePair <IField, IMap> >(new ObservableCollection <KeyValuePair <IField, IMap> >(new List <KeyValuePair <IField, IMap> >(fieldCollection.GetRange(0, 3).Select(field => new KeyValuePair <IField, IMap>(field, null)))))) .Repeat.Any(); tableMock.Expect(m => m.NameSource) .Return("TABEL") .Repeat.Any(); tableMock.Expect(m => m.Fields) .Return(new ReadOnlyObservableCollection <IField>(new ObservableCollection <IField>(fieldCollection))) .Repeat.Any(); tableMock.Expect(m => m.PrimaryKey) .Return(keyMock) .Repeat.Any(); tableMock.Expect(m => m.RecordFilters) .WhenCalled(e => e.ReturnValue = new ReadOnlyObservableCollection <IFilter>(new ObservableCollection <IFilter>(filterCollection))) .Return(new ReadOnlyObservableCollection <IFilter>(new ObservableCollection <IFilter>(filterCollection))) .Repeat.Any(); tableMock.Expect(m => m.AddRecordFilter(Arg <IFilter> .Is.NotNull)) .WhenCalled(e => filterCollection.Add((IFilter)e.Arguments.ElementAt(0))) .Repeat.Any(); tableMock.Expect(m => m.Clone()) .Return(tableMock) .Repeat.Any(); var mocker = new MockRepository(); var dataManipulatorsMock = mocker.DynamicMultiMock <IDataManipulators>(new[] { typeof(IEnumerable <IDataManipulator>) }); Expect.Call(dataManipulatorsMock.GetEnumerator()) .Return(new List <IDataManipulator>(0).GetEnumerator()) .Repeat.Any(); mocker.ReplayAll(); using (var oracleClient = new OracleClient(dataManipulatorsMock)) { var extraCriterias = new List <KeyValuePair <string, object> > { new KeyValuePair <string, object>("SYSTEM_NR", 0), new KeyValuePair <string, object>("TABEL", 0) }; var numberOfEqualKeys = oracleClient.GetNumberOfEqualKeyValues(keyMock, extraCriterias, "0|0|00"); Assert.That(numberOfEqualKeys, Is.EqualTo(1)); oracleClient.Dispose(); } keyMock.AssertWasCalled(m => m.Table); tableMock.AssertWasCalled(m => m.Clone()); tableMock.AssertWasCalled(m => m.RecordFilters, opt => opt.Repeat.Times(6)); tableMock.AssertWasCalled(m => m.AddRecordFilter(Arg <IFilter> .Is.NotNull)); dataManipulatorsMock.AssertWasCalled(m => m.GetEnumerator()); }
public void TestThatGetNumberOfEqualKeyValuesGetsNumberOfEqualKeyValuesForKeyWhereThereOnlyAreOnRecord() { var fixture = new Fixture(); var fieldCollection = new List <IField> { MockRepository.GenerateMock <IField>(), MockRepository.GenerateMock <IField>(), MockRepository.GenerateMock <IField>(), MockRepository.GenerateMock <IField>() }; fieldCollection.ElementAt(0).Expect(m => m.NameSource) .Return("SYSTEM_NR") .Repeat.Any(); fieldCollection.ElementAt(0).Expect(m => m.DatatypeOfSource) .Return(typeof(int?)) .Repeat.Any(); fieldCollection.ElementAt(1).Expect(m => m.NameSource) .Return("TABEL") .Repeat.Any(); fieldCollection.ElementAt(1).Expect(m => m.DatatypeOfSource) .Return(typeof(int?)) .Repeat.Any(); fieldCollection.ElementAt(2).Expect(m => m.NameSource) .Return("NR") .Repeat.Any(); fieldCollection.ElementAt(2).Expect(m => m.DatatypeOfSource) .Return(typeof(string)) .Repeat.Any(); fieldCollection.ElementAt(3).Expect(m => m.NameSource) .Return("TEKST") .Repeat.Any(); fieldCollection.ElementAt(3).Expect(m => m.DatatypeOfSource) .Return(typeof(string)) .Repeat.Any(); var filterCollection = new List <IFilter>(); var tableMock = MockRepository.GenerateMock <ITable>(); var keyMock = MockRepository.GenerateMock <ICandidateKey>(); keyMock.Expect(m => m.Table) .Return(tableMock) .Repeat.Any(); keyMock.Expect(m => m.Fields) .Return(new ReadOnlyObservableCollection <KeyValuePair <IField, IMap> >(new ObservableCollection <KeyValuePair <IField, IMap> >(fieldCollection.GetRange(0, 3).Select(field => new KeyValuePair <IField, IMap>(field, null))))) .Repeat.Any(); tableMock.Expect(m => m.NameSource) .Return("TABEL") .Repeat.Any(); tableMock.Expect(m => m.Fields) .Return(new ReadOnlyObservableCollection <IField>(new ObservableCollection <IField>(fieldCollection))) .Repeat.Any(); tableMock.Expect(m => m.PrimaryKey) .Return(keyMock) .Repeat.Any(); tableMock.Expect(m => m.RecordFilters) .WhenCalled(e => e.ReturnValue = new ReadOnlyObservableCollection <IFilter>(new ObservableCollection <IFilter>(filterCollection))) .Return(new ReadOnlyObservableCollection <IFilter>(new ObservableCollection <IFilter>(filterCollection))) .Repeat.Any(); tableMock.Expect(m => m.AddRecordFilter(Arg <IFilter> .Is.NotNull)) .WhenCalled(e => filterCollection.Add((IFilter)e.Arguments.ElementAt(0))) .Repeat.Any(); tableMock.Expect(m => m.Clone()) .Return(tableMock) .Repeat.Any(); using (var oracleClient = new OracleClient()) { var extraCriterias = new List <KeyValuePair <string, object> > { new KeyValuePair <string, object>("SYSTEM_NR", 0), new KeyValuePair <string, object>("TABEL", 0), new KeyValuePair <string, object>("NR", "00") }; var numberOfEqualKeys = oracleClient.GetNumberOfEqualKeyValues(keyMock, extraCriterias, fixture.CreateAnonymous <string>()); Assert.That(numberOfEqualKeys, Is.EqualTo(1)); oracleClient.Dispose(); } keyMock.AssertWasCalled(m => m.Table); tableMock.AssertWasCalled(m => m.Clone()); tableMock.AssertWasCalled(m => m.RecordFilters, opt => opt.Repeat.Times(7)); tableMock.AssertWasCalled(m => m.AddRecordFilter(Arg <IFilter> .Is.NotNull)); }
public void TestThatValidateTableValidatesTable() { var fieldCollectionMock = new List <IField>(7) { MockRepository.GenerateMock <IField>(), MockRepository.GenerateMock <IField>(), MockRepository.GenerateMock <IField>(), MockRepository.GenerateMock <IField>(), MockRepository.GenerateMock <IField>(), MockRepository.GenerateMock <IField>(), MockRepository.GenerateMock <IField>() }; fieldCollectionMock.ElementAt(0).Expect(m => m.NameSource) .Return("SYSTEM_NR") .Repeat.Any(); fieldCollectionMock.ElementAt(0).Expect(m => m.DatatypeOfSource) .Return(typeof(int?)) .Repeat.Any(); fieldCollectionMock.ElementAt(1).Expect(m => m.NameSource) .Return("TABEL") .Repeat.Any(); fieldCollectionMock.ElementAt(1).Expect(m => m.DatatypeOfSource) .Return(typeof(int?)) .Repeat.Any(); fieldCollectionMock.ElementAt(2).Expect(m => m.NameSource) .Return("NR") .Repeat.Any(); fieldCollectionMock.ElementAt(2).Expect(m => m.DatatypeOfSource) .Return(typeof(string)) .Repeat.Any(); fieldCollectionMock.ElementAt(3).Expect(m => m.NameSource) .Return("TEKST") .Repeat.Any(); fieldCollectionMock.ElementAt(3).Expect(m => m.DatatypeOfSource) .Return(typeof(string)) .Repeat.Any(); fieldCollectionMock.ElementAt(4).Expect(m => m.NameSource) .Return("FORDELPCT") .Repeat.Any(); fieldCollectionMock.ElementAt(4).Expect(m => m.DatatypeOfSource) .Return(typeof(decimal?)) .Repeat.Any(); fieldCollectionMock.ElementAt(5).Expect(m => m.NameSource) .Return("O_DATO") .Repeat.Any(); fieldCollectionMock.ElementAt(5).Expect(m => m.DatatypeOfSource) .Return(typeof(DateTime?)) .Repeat.Any(); fieldCollectionMock.ElementAt(6).Expect(m => m.NameSource) .Return("O_TID") .Repeat.Any(); fieldCollectionMock.ElementAt(6).Expect(m => m.DatatypeOfSource) .Return(typeof(TimeSpan?)) .Repeat.Any(); var tableMock = MockRepository.GenerateMock <ITable>(); tableMock.Expect(m => m.NameSource) .Return("TABEL") .Repeat.Any(); tableMock.Expect(m => m.Fields) .Return(new ReadOnlyObservableCollection <IField>(new ObservableCollection <IField>(fieldCollectionMock))) .Repeat.Any(); using (var oracleClient = new OracleClient()) { oracleClient.ValidateTable(tableMock); oracleClient.Dispose(); } tableMock.AssertWasCalled(m => m.NameSource); tableMock.AssertWasCalled(m => m.Fields); fieldCollectionMock.ElementAt(0).AssertWasCalled(m => m.NameSource); fieldCollectionMock.ElementAt(0).AssertWasCalled(m => m.DatatypeOfSource); fieldCollectionMock.ElementAt(1).AssertWasCalled(m => m.NameSource); fieldCollectionMock.ElementAt(1).AssertWasCalled(m => m.DatatypeOfSource); fieldCollectionMock.ElementAt(2).AssertWasCalled(m => m.NameSource); fieldCollectionMock.ElementAt(2).AssertWasCalled(m => m.DatatypeOfSource); fieldCollectionMock.ElementAt(3).AssertWasCalled(m => m.NameSource); fieldCollectionMock.ElementAt(3).AssertWasCalled(m => m.DatatypeOfSource); }
public void TestThatGetDataGetDataWithRecordFilters() { var fieldCollectionMock = new List <IField>(7) { MockRepository.GenerateMock <IField>(), MockRepository.GenerateMock <IField>(), MockRepository.GenerateMock <IField>(), MockRepository.GenerateMock <IField>(), MockRepository.GenerateMock <IField>(), MockRepository.GenerateMock <IField>(), MockRepository.GenerateMock <IField>() }; fieldCollectionMock.ElementAt(0).Expect(m => m.NameSource) .Return("SYSTEM_NR") .Repeat.Any(); fieldCollectionMock.ElementAt(0).Expect(m => m.DatatypeOfSource) .Return(typeof(int?)) .Repeat.Any(); fieldCollectionMock.ElementAt(0).Expect(m => m.DatatypeOfTarget) .Return(typeof(int?)) .Repeat.Any(); fieldCollectionMock.ElementAt(0).Expect(m => m.Nullable) .Return(false) .Repeat.Any(); fieldCollectionMock.ElementAt(1).Expect(m => m.NameSource) .Return("TABEL") .Repeat.Any(); fieldCollectionMock.ElementAt(1).Expect(m => m.DatatypeOfSource) .Return(typeof(int?)) .Repeat.Any(); fieldCollectionMock.ElementAt(1).Expect(m => m.DatatypeOfTarget) .Return(typeof(int?)) .Repeat.Any(); fieldCollectionMock.ElementAt(1).Expect(m => m.Nullable) .Return(false) .Repeat.Any(); fieldCollectionMock.ElementAt(2).Expect(m => m.NameSource) .Return("NR") .Repeat.Any(); fieldCollectionMock.ElementAt(2).Expect(m => m.DatatypeOfSource) .Return(typeof(string)) .Repeat.Any(); fieldCollectionMock.ElementAt(2).Expect(m => m.DatatypeOfTarget) .Return(typeof(string)) .Repeat.Any(); fieldCollectionMock.ElementAt(2).Expect(m => m.Nullable) .Return(false) .Repeat.Any(); fieldCollectionMock.ElementAt(3).Expect(m => m.NameSource) .Return("TEKST") .Repeat.Any(); fieldCollectionMock.ElementAt(3).Expect(m => m.DatatypeOfSource) .Return(typeof(string)) .Repeat.Any(); fieldCollectionMock.ElementAt(3).Expect(m => m.DatatypeOfTarget) .Return(typeof(string)) .Repeat.Any(); fieldCollectionMock.ElementAt(3).Expect(m => m.Nullable) .Return(true) .Repeat.Any(); fieldCollectionMock.ElementAt(4).Expect(m => m.NameSource) .Return("FORDELPCT") .Repeat.Any(); fieldCollectionMock.ElementAt(4).Expect(m => m.DatatypeOfSource) .Return(typeof(decimal?)) .Repeat.Any(); fieldCollectionMock.ElementAt(4).Expect(m => m.DatatypeOfTarget) .Return(typeof(decimal?)) .Repeat.Any(); fieldCollectionMock.ElementAt(4).Expect(m => m.Nullable) .Return(true) .Repeat.Any(); fieldCollectionMock.ElementAt(5).Expect(m => m.NameSource) .Return("O_DATO") .Repeat.Any(); fieldCollectionMock.ElementAt(5).Expect(m => m.DatatypeOfSource) .Return(typeof(DateTime?)) .Repeat.Any(); fieldCollectionMock.ElementAt(5).Expect(m => m.DatatypeOfTarget) .Return(typeof(DateTime?)) .Repeat.Any(); fieldCollectionMock.ElementAt(5).Expect(m => m.Nullable) .Return(true) .Repeat.Any(); fieldCollectionMock.ElementAt(6).Expect(m => m.NameSource) .Return("O_TID") .Repeat.Any(); fieldCollectionMock.ElementAt(6).Expect(m => m.DatatypeOfSource) .Return(typeof(TimeSpan?)) .Repeat.Any(); fieldCollectionMock.ElementAt(6).Expect(m => m.DatatypeOfTarget) .Return(typeof(TimeSpan?)) .Repeat.Any(); fieldCollectionMock.ElementAt(6).Expect(m => m.Nullable) .Return(true) .Repeat.Any(); var primaryKeyMock = MockRepository.GenerateMock <ICandidateKey>(); primaryKeyMock.Expect(m => m.Fields) .Return(new ReadOnlyObservableCollection <KeyValuePair <IField, IMap> >(new ObservableCollection <KeyValuePair <IField, IMap> >(fieldCollectionMock.GetRange(0, 3).Select(field => new KeyValuePair <IField, IMap>(field, null))))) .Repeat.Any(); var recordFilterCollectionMock = new List <IFilter>(2) { MockRepository.GenerateMock <IFilter>(), MockRepository.GenerateMock <IFilter>() }; recordFilterCollectionMock.ElementAt(0).Expect(m => m.AsSql()) .Return("TABEL=0") .Repeat.Any(); recordFilterCollectionMock.ElementAt(1).Expect(m => m.AsSql()) .Return("TABEL=1") .Repeat.Any(); var tableMock = MockRepository.GenerateMock <ITable>(); tableMock.Expect(m => m.NameSource) .Return("TABEL") .Repeat.Any(); tableMock.Expect(m => m.PrimaryKey) .Return(primaryKeyMock) .Repeat.Any(); tableMock.Expect(m => m.RecordFilters) .Return(new ReadOnlyObservableCollection <IFilter>(new ObservableCollection <IFilter>(recordFilterCollectionMock))) .Repeat.Any(); tableMock.Expect(m => m.Fields) .Return(new ReadOnlyObservableCollection <IField>(new ObservableCollection <IField>(fieldCollectionMock))) .Repeat.Any(); using (var oracleClient = new OracleClient()) { var data = new List <IEnumerable <IDataObjectBase> >(); oracleClient.GetData(tableMock, (s, e) => { data.AddRange(e.Data); Assert.That(data.Any(row => { var dataRow = row.ToList(); return(dataRow.ElementAt(1).GetSourceValue <int?>() == 0 && dataRow.ElementAt(1).GetSourceValue <int?>() == 1); }), Is.False); }); Assert.That(data, Is.Not.Null); var dataAsList = data.ToList(); Assert.That(dataAsList, Is.Not.Null); Assert.That(dataAsList.Count(), Is.GreaterThan(0)); oracleClient.Dispose(); } tableMock.AssertWasCalled(m => m.Fields); tableMock.AssertWasCalled(m => m.RecordFilters); tableMock.AssertWasCalled(m => m.PrimaryKey); tableMock.AssertWasCalled(m => m.NameSource); recordFilterCollectionMock.ElementAt(0).AssertWasCalled(m => m.AsSql()); recordFilterCollectionMock.ElementAt(1).AssertWasCalled(m => m.AsSql()); primaryKeyMock.AssertWasCalled(m => m.Fields); }