//private static void ClearFieldData(DAL database) //{ // database.Execute(CSM.Utility.SQL.CLEAR_FIELD_DATA); //} //inserts Component Records into master private static List <ComponentDO> BuildMasterComponentTable(DAL masterDAL, int numComp) { var masterFileName = System.IO.Path.GetFileName(masterDAL.Path); var compList = new List <ComponentDO>(); for (int i = 1; i <= numComp; i++) { String compFileName = GetCompFileName(masterFileName, i); var compInfo = masterDAL.From <ComponentDO>() .Where("FileName = @p1").Read(compFileName).FirstOrDefault(); if (compInfo == null) { compInfo = new ComponentDO(masterDAL); compInfo.GUID = Guid.NewGuid(); compInfo.FileName = compFileName; compInfo.Save(); } compList.Add(compInfo); } return(compList); }