Hi there. I'm have a trouble trying to find in my table elements witch starts with a specified character using this code:
using (SQLite.SQLiteConnection cx = new SQLite.SQLiteConnection(dbPath))
{
var squery = cx.Query<DictDatabase>("SELECT * FROM DictTable WHERE Word LIKE ?", sel[e.Position].Character );
dict_lst = squery.ToList();
}
I'll try using this "... LIKE ?%" in the query, but have a message error saying 'input incomplete'
I try to use linq too, but for some reason i have another message saying 'System.AggregateException'
using this code.
var _dictionario = from dct in dbconnection.Table<DictDatabase>()
where dct.Word.Contains(sel[e.Position].Character)
select dct;
dict_lst = _dictionario.ToListAsync().Result; // message error in this line
I don't know if the error message is why I'm using another linq querying another table before this code line
so I opt for use the Query statement, also to know how use it.
thanks in advance