BExISMigration.PrimaryData.queryDistInsertDates C# (CSharp) Method

queryDistInsertDates() private method

private queryDistInsertDates ( string dataSetID, string DataBase ) : List
dataSetID string
DataBase string
return List
        private List<DB2TimeStamp> queryDistInsertDates(string dataSetID, string DataBase)
        {
            List<DB2TimeStamp> distInsertDates = new List<DB2TimeStamp>();

            string mySelectQuery = "select distinct insertdate";
            mySelectQuery += " from explorer.observation where datasetid = " + dataSetID + " order by insertdate asc;";
            DB2Connection connect = new DB2Connection(DataBase);
            DB2Command myCommand = new DB2Command(mySelectQuery, connect);
            connect.Open();
            DB2DataReader myReader = myCommand.ExecuteReader();
            while (myReader.Read())
            {
                distInsertDates.Add(myReader.GetDB2TimeStamp(0));
            }
            myReader.Close();
            connect.Close();

            return distInsertDates;
        }