Adding AND in a WHERE clause using ViewBag and SelectList with LINQ in Controller (ASP.Net MVC)

Question

How do I add a 2nd WHERE clause ('AND') in my current ViewBag with LINQ in Controller? Thanks!

ViewBag.Subjects = new SelectList(_odb.SUBJ_MSTR.
                   Where(o => o.TYPE== "4").OrderBy(o => o.SUBJ_NAME), "SUBJ_ID", "SUBJ_VAL");

Answer 1

You can add && with WHERE like this way.

ViewBag.Subjects = new SelectList(_odb.SUBJ_MSTR.
                   Where(o => o.TYPE== "4" && o.TYPE=="5").OrderBy(o => o.SUBJ_NAME), "SUBJ_ID", "SUBJ_VAL");