Error : Column 'Employee_Key' does not belong to table Employee.

public DataTable GetData(Entities.Config.EtlConfig config)
        {
            var s = new SqlLoader();
            var dt = s.GetSchemaTable(config.SqlTableToLoad);
            string setdate = DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss");
            dt.TableName = "Employee";

            try
            {
                DirectoryEntry de = GetDirectoryEntry();
                DirectorySearcher ds = new DirectorySearcher(de);
                SearchResultCollection results = ds.FindAll();
                foreach (SearchResult result in results)
                {
                    DirectoryEntry dey = GetDirectoryEntry();

                    DataRow dr = dt.NewRow();

                    dr["Employee_Key"] = dey.Properties["title"].Value ?? string.Empty; 
                    dr["Employee_Name"] = dey.Properties["cn"].Value;
                    dr["Employee_Full_Name"] = dey.Properties["distinguishedName"].Value;
                    dr["Employee_Phone_Number"] = dey.Properties["telephoneNumber"];
                    dr["Email_Address"] = dey.Properties["mail"];
                    dr["Business_Unit"] = dey.Properties["department"];
                    dr["Supervisor_Full_Name"] = dey.Properties["manager"];
                    dr["Row_Update_Date"] = setdate;
                    dr["Source"] = config.Source;
                    dt.Rows.Add(dr);
                    dey.Close();
                }
                de.Close();

                return dt;
            }
            catch(Exception e)
            {
                _log.Error(e.Message);
                throw new CustomException(e,ErrorType.DataImporter,e.Message);
            }
        }

        public DataTable GetSchemaTable(string sqlTable)
        {   
            DataTable dt;
            try
            {
                _dbManager.Open();
               SqlDataReader rd;
               using (rd= (SqlDataReader)_dbManager.ExecuteReader(CommandType.Text, "Select top 1 * from " + sqlTable + " NOLOCK"))
               {
                   dt = rd.GetSchemaTable();
               }
            }
            catch (Exception ex)
            {
                _log.Error("Error getting schema for table : " + sqlTable + " " + ex.Message);
                throw new CustomException(ex,ErrorType.SQLImport,"Error getting schema for table : " + sqlTable + " " +  ex.Message);
               
            }
            finally
            {
                  _dbManager.Dispose();
            }

            return dt;
        }

Select allOpen in new window