public void PopulateData()
{
//Get source data
Sanyo sanyo = new Sanyo();
sanyo.PopulateData(ref SourceData, "SELECT * FROM " + SourceName);
//Delete temp tables in destination
Azure azure = new Azure();
azure.DeleteTempTable(DestinationName);
}
public void PopulateData()
{
//Get last field PK
Azure azure = new Azure();
string queryAzure = "SELECT MAX(TransactionNumber) FROM " + RealTableName;
string maxID = azure.GetSingleValue(queryAzure);
//Get source data
Sanyo sanyo = new Sanyo();
string querySanyo = String.Format("SELECT * FROM {0} WHERE {1} > {2}", SourceName, UpdateIdentifier, maxID);
sanyo.PopulateData(ref SourceData, querySanyo);
//Delete temp tables in destination
azure.DeleteTempTable(DestinationTableName);
}