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