public static List <DataLog> getDistinctList(string projectID) { List <DataLog> result = new List <DataLog>(); string sql = string.Format("SELECT DISTINCT(typename), version,TEST_PROJECT_ID, OBJECT_TABLE FROM MDS_IMP_DATA_LOG WHERE TEST_PROJECT_ID='{0}'", projectID); DataSet ds = OracleHelper.Query(sql); foreach (DataRow dr in ds.Tables[0].Rows) { DataLog item = DataLog.Parse(dr); result.Add(item); } return(result); }