Implement NOT in clause in LINQ

See more:

C#

LINQ

lambda

Hi want to return a list of areas which dont appear in the current list of data;

I have two list of data, once which contains a list of areas;

A second one which contains the data

i want to query the data list and return only where area does not exist in the list

What I have tried:

This is my code

public static List<string> CheckprocessSubmisson(string department, string searchDate)
      {
          var itemsnotListed = new List<string>();

          var listofProcess = getListofProcesses(department);

          var startDate = DateTime.Parse(searchDate).AddHours(7);
          var endDate = startDate.AddHours(24);

          using (var smpEntities = new SMPEntities())
          {

              var test1 = (from x in smpEntities.Checks_Records.Where(x => x.DateLogged >= startDate
                                                                        && x.DateLogged < endDate
                                                                        && x.Checks_Records_Department.Equals(
                                                                        department))
                           select x).ToList();

              foreach (var item in listofProcess)
              {
                  itemsnotListed = (from x in test1.Where !(from i in x=
              }
          }

          return null;
      }