.Orderby() Does not order correctly - Aspnet Core

Question

In an Aspnet Core 2.2 application, I had the following code that selected the field of a table and instructed to sort by Text:

Controller:

            //Bairros
            ViewBag.Bairros = _context.Imoveis.Select(c => new SelectListItem()
            { Text = c.Bairro, Value = c.Bairro }).OrderBy(x => x.Text).Distinct();

View

    <div class="form-group">
      <select name="bairro" asp-items="@ViewBag.Bairros" class="form-control">
         <option value="0">Todos os bairros</option>
      </select>
    </div>

In this previous version the code worked. When passing to version 3.1, the code does not work, it is as follows:

Ref the versions,

Previous: Entityframeworkcore 2.2.8, Pomelo.EntityFrameworkCore.Mysql 2.1.0 Current: Entityframeworkcore 3.1.10, Pomelo.EntityFrameworkCore.Mysql 3.2.4

Does the version update have effect on the querie?

Answer 1

After researching I made some changes and Orderby() worked.

The previous Code:

    ViewBag.Bairros = _context.Imoveis.Select(c => new SelectListItem()
    { Text = c.Bairro, Value = c.Bairro }).OrderBy(x => x.Text).Distinct();

The redone code:

ViewBag.Bairros = _context.Imoveis.Select(c => new SelectListItem()
    { Text = c.Bairro, Value = c.Bairro }).Distinct().OrderBy(a => a.Value);