示例#1
0
        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);
        }
示例#2
0
        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);
        }