LINQ Distinct IQueryable RRS feed

  • Question

  • I have the following method, which shows me from my table EMPLOYEE all the data in the EDLEVEL column but I just want to show a data in case that esxist duplicates with DISTINCT, but I do not know where to use it

    public IQueryable selectLevel()
                DataClassesEje06DataContext context = new DataClassesEje06DataContext();
                var qry = from a in context.EMPLOYEE orderby a.EDLEVEL descending
                          select new
                              NIV_EDU = a.EDLEVEL
                return qry;

    Tuesday, October 9, 2018 8:24 PM


  • return qry.Distinct();
    • Marked as answer by MarioCode Wednesday, October 10, 2018 1:03 AM
    Tuesday, October 9, 2018 9:48 PM