How to edit items in sqlite.net with Xamarin

Question

I’m learning to use sqlite.net in the Xamarin, but when editing an item is not working, I debug the code and gave a breakpoint in the EditItens() and saw that the values passed to conexao.Query<Itens> are correct, but received in the variable Teste below continue the same as before, I’m missing something at the time of editing the values in sqlite? Also there may be something wrong in GetItens(), but I find it kind of hard because it works normally when used to take the values and show in the ListView of MainActivity. Below the methods cited

string pasta = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal);
public List<Itens> GetItens()
    {
        try
        {
            var conexao = new SQLiteConnection(System.IO.Path.Combine(pasta, "Itens.db3"));
            return conexao.Table<Itens>().ToList();
        }
        catch (Exception)
        {
            return null;
        }
    }

public bool EditItens(Itens itens)
    {
        try
        {
            var conexao = new SQLiteConnection(System.IO.Path.Combine(pasta, "Itens.db3"));
            conexao.Query<Itens>("UPDATE Itens set Nome=?,Preco=? Where Id=?", itens.Nome, itens.Preco, itens.Id);
            Teste = GetItens();
            return true;
        }
        catch (Exception)
        {
            return false;
        }
    }

If you could tell me where I can find the pasta, "Itens.db3" by Windows File Explorer, it will also help because I can check if the item really isn’t being edited.

Answer 1

Anderson, use this to update the data:

var conexao = new SQLiteConnection(System.IO.Path.Combine(pasta, "Itens.db3"));
            conexao.Execute("UPDATE Itens set Nome=?,Preco=? Where Id=?", 
itens.Nome, itens.Preco, itens.Id);

Optional and preferably, since you have the items object, use this:

conexao.Update(itens);

Your database will be located on the smartphone, in the folder that was set in

var conexao = new SQLiteConnection(System.IO.Path.Combine(pasta, "Itens.db3"));