Populate Drop Down List from SQL Database
Here's a simplification of the OfficeRepository methods. Note the other IDisposable types in using blocks:

    public static IEnumerable&lt;OfficeRollups&gt; ListOfficeRollups(bool active, bool inactive)
    {
        var whereClause = active &amp;&amp; !inactive
            ? @"Where Active = 1"
            : (!active &amp;&amp; inactive ? @"Where Active = 0" : string.Empty);
        var srtQry = @"
Select OfficeRollupID, OfficeRollupName, Active
From OfficeRollups
" + whereClause + @"
Order By OfficeRollupName
";

        using (var conn = new SqlConnection(Settings.ConnectionString))
        using (var objCommand = new SqlCommand(srtQry, conn) { CommandType = CommandType.Text })
        using (var dt = new DataTable())
        using (var adp = new SqlDataAdapter(objCommand))
        {
            conn.Open();
            adp.Fill(dt);
            return dt.AsEnumerable().Select(o =&gt; new OfficeRollups
            {
                OfficeRollupID = o.Field&lt;int&gt;("OfficeRollupID"),
                OfficeRollupName = o.Field&lt;string&gt;("OfficeRollupName"),
                Active = o.Field&lt;bool&gt;("Active")
            }).ToList();
        }
    }

    public static IEnumerable&lt;SelectListItem&gt; ListOfficeRollupsForDD(bool active, bool inactive)
    {
        var listOfficeRollups = OfficeRepository.ListOfficeRollups(active, inactive);

        return listOfficeRollups
                .Where(o =&gt; !string.IsNullOrEmpty(o.OfficeRollupName))
                .OrderBy(o =&gt; o.OfficeRollupName)
                .Select(o =&gt; new SelectListItem
                {
                    Text = o.OfficeRollupName,
                    Value = o.OfficeRollupID.ToString()
                })
                .ToList();
    }