C#

private IQueryable<MaterialModel> getMaterialQuery()
{
    var query = (from mh in DataContext.MaterialHeaders
                    join md in DataContext.MaterialDetails on mh.MaterialHeaderId equals md.MaterialId
                    select new MaterialModel
                    {
                        Id = md.MaterialDetailId,
                        MaterialHeaderId = mh.MaterialHeaderId,
                        MaterialDetailId = md.MaterialDetailId,
                        SafetyLabelTextId = mh.SafetyLabelTextId.Value,
                        MaterialTypeId = mh.MaterialTypeId,
                        IncludeInSolventProgram = mh.IncludeInSolventProgram.Value,
                        IsDamagedByFreezing = mh.IsDamagedByFreezing.Value,
                        IsEquipment = mh.IsEquipment.Value,
                        IsMSDS = mh.IsMSDS.Value,
                        IsPPE = mh.IsPPE.Value,
                        IsTDG = mh.IsTDG.Value,
                        IsMiscellanousCost = mh.IsMiscellanousCost.Value,
                        IsSolvent = mh.IsSolvent.Value,
                        ItemName = mh.ItemName,
                        ItemNumber = mh.ItemNumber,
                        ProductTypeId = mh.ProductTypeId,
                        ProductUsage1Id = mh.ProductUsage1Id.Value,
                        ProductUsage2Id = mh.ProductUsage2Id.Value,
                        ProductUsage3Id = mh.ProductUsage3Id.Value,
                        ProductUsage4Id = mh.ProductUsage4Id.Value,
                        SafetyLabelRequired = mh.SafetyLabelRequired.Value,
                        WarehouseLocationId = md.WarehouseLocationId.Value,
                        Color = md.Color,
                        DiamondGritId = md.DiamondGritId.Value,
                        IsActive = md.IsActive,
                        IsDiscontinued = md.IsDiscontinued.Value,
                        IsNormallyStocked = md.IsNormallyStocked.Value,
                        FittingId = md.FittingId,
                        ShowOnJobLists = md.ShowOnJobLists.Value,
                        MinimumOnHandQuantity = md.MinimumOnHandQuantity.Value,
                        MSDSDescription = md.MSDSDescription,
                        PhysicalCount = md.PhysicalCount.Value,
                        PhysicalCountDate = md.PhysicalCountDate.Value,
                        RackingLocation = md.RackingLocation,
                        RackingNumber = md.RackingNumber,
                        SizeId = md.SizeId
                    });

    return query;
} 

public MaterialModel GetDuplicateMaterial(NewMaterialInfoModel NewMaterialInfoEntity)
{
    var query = getMaterialQuery();
    MaterialModel entity = query.Where(e => e.ItemName == NewMaterialInfoEntity.ItemName &&
                                            e.MaterialTypeId == (int)NewMaterialInfoEntity.MaterialType &&
                                            e.SizeId == NewMaterialInfoEntity.SizeId &&
                                            e.Color == NewMaterialInfoEntity.Color).FirstOrDefault();
    return entity;
}

if (!String.IsNullOrEmpty(CustodianEAddress.Text))
{
    for (AddressLength1 = 0; AddressLength1 < Length; AddressLength1++)
    {
        List<string> list1 = new List<string>();
        using (StreamReader reader = new StreamReader(FileLocation))
        {
            string line1;
            //max 500
            string[] LineArray1 = new string[500];

            while ((line1 = reader.ReadLine()) != null)
            {
                list1.Add(line1); // Add to list.

                if (line1.IndexOf(cust1[AddressLength1].ToString()) != -1)
                {
                    count1++;
                    LineArray1[count1] = line1;
                }
            }

            reader.Close();
            using (System.IO.StreamWriter filed = 
               new System.IO.StreamWriter(FileLocation, true))
            {
                filed.WriteLine("");
                filed.WriteLine("The email address " + 
             cust1[AddressLength1].ToString() + " was found " + count1 +
             " times within the recipient's inbox");
            }

            string count1a;
            count1a = count1.ToString();
        }
    }
}
else
{
    MessageBox.Show("Please Enter an Email Address");
}