Selecting Suppliers by Fancy Name

Question

I have a PRODUCT registration form and there is a relationship with the SUPPLIER table, as shown in the image below:

Which click on the SEARCH VENDOR button will appear this View

Now I need to develop a text box that when typing a value it looks for all SUPPLIERS that contain a FANCY NAME as typed in the text box.

This Controller shows all vendors, but I only want the ones with FANCY NAME typed in the text box:

public ActionResult Index()
    {
        try
        {
            using (SistemaDBEntities db = new SistemaDBEntities())
            {
                return View(db.Fornecedor.Where(s => s.Ativo == true).ToList());
            }
        }
        catch (Exception)
        {

            throw;
        }

    }

Answer 1

I so revoked my problem:

[HttpPost] 
public ActionResult Index(string sConsulta)
{
    var consulta = db.Fornecedor.Where(s => s.NomeFantasia.Contains(sConsulta)).ToList();
    return View(consulta);
}



@using (Html.BeginForm())
{
 <p>Digite o nome/fantasia</p>
 <input placeholder="Digite o Nome/Fantasia" type="text" name="sConsulta" id="sConsulta"  />
 <div><button type="submit">Consultar</button></div>   
}