private void btnQuick2_Click(object sender, EventArgs e)
        {
            using (EQDIRECTEntities context = new EQDIRECTEntities())
            {
                IQueryable<ProcessAreaLookup> query =
                    from pal in context.ProcessAreaLookups
                    where pal.CustomerProcessAreas.Any(o=>o.CustomerProduct.Customer.cust_CustomerID == 1 && o.CustomerProduct.Product.prdt_ProductID == 1)
                    select pal;

                var query2 = from cp in context.CustomerProducts
                            join cpa in context.CustomerProcessAreas on cp.cp_CustomerProductsID equals cpa.CustomerProduct.cp_CustomerProductsID
                            join pal in context.ProcessAreaLookups on cpa.ProcessAreaLookup.pal_ProcessAreaID equals pal.pal_ProcessAreaID
                            where cp.Customer.cust_CustomerID == 1 && cp.Product.prdt_ProductID == 1
                            select pal;

            }
        }