public void CustomSourceWithWebService() { SqlTask.ExecuteNonQuery("Create test table", @"CREATE TABLE dbo.ws_dest ( Id INT NOT NULL, UserId INT NOT NULL, Title NVARCHAR(100) NOT NULL, Completed BIT NOT NULL )" ); WebserviceReader wsreader = new WebserviceReader(); CustomSource <Todo> source = new CustomSource <Todo>(wsreader.ReadTodo, wsreader.EndOfData); DBDestination <Todo> dest = new DBDestination <Todo>("dbo.ws_dest"); source.LinkTo(dest); source.Execute(); dest.Wait(); }
public void CustomSourceWithWebService() { //Arrange SqlTask.ExecuteNonQuery(Connection, "Create test table", @"CREATE TABLE dbo.WebServiceDestination ( Id INT NOT NULL, Title NVARCHAR(100) NOT NULL, Completed BIT NOT NULL )" ); DbDestination <Todo> dest = new DbDestination <Todo>(Connection, "dbo.WebServiceDestination"); WebserviceReader wsreader = new WebserviceReader(); //Act CustomSource <Todo> source = new CustomSource <Todo>(wsreader.ReadTodo, wsreader.EndOfData); source.LinkTo(dest); source.Execute(); dest.Wait(); //Assert Assert.Equal(5, RowCountTask.Count(Connection, "dbo.WebServiceDestination")); }