C#

IWorkbook workbook = spreadsheetControl.Document;
            Worksheet worksheet = workbook.Worksheets.ActiveWorksheet;
            CellRange range = worksheet.GetDataRange();
            int LastRow = range.BottomRowIndex;
            var keys = new List<string>();
            var values = new List<int>();

            for (int i = 0; i < LastRow + 1; i++)
            {
                keys.Add(string.Join(",", worksheet.Cells[i, 0].DisplayText, worksheet.Cells[i, 1].DisplayText,
                    worksheet.Cells[i, 2].DisplayText, worksheet.Cells[i, 3].DisplayText));
                values.Add((int)worksheet.Cells[i, 4].Value.NumericValue);
            }
            var mydic = new Dictionary<string, int>();
            for (int i = 0; i < keys.Count; i++)
            {
                try
                {
                    mydic.Add(keys[i], values[i]);
                }
                catch (Exception)
                {
                    if (mydic.ContainsKey("f,a,r,d") == true)
                    {
                        MessageBox.Show("Duplicate");
                    }
                }
            }

if (mydic.ContainsKey("f,a,r,d") == true)
                    {
                        MessageBox.Show("Duplicate");
                    }

 Query A:
from a in violations
join b in programs on a.ViolationTypeId equals b.ViolationTypeId
join d in branches on b.BranchId equals d.BranchId
join e in subprograms on a.ViolationSubtypeId equals e.ViolationTypeId into es
from e in es.DefaultIfEmpty()
join f in nonUniquePenalties on a.ViolationSubtypeId equals f.ViolationTypeId && f.ParentViolationTypeId==a.ViolationTypeId
where a.ApplyUniquePenalty == true