Need help with sqlite-net-pcl query

[Khaikaa]

Hi,

 

I'm developing a little desktop application in c# using sqlite-net-pcl NuGet package to manage a little sqlite database. Everything works well but I can't use a siple 'and' operator in the querys. I've tried this 2 ways:

 

conexion.Query<Participacion>($"select * from Participacion where idtorneo = {participacion.IDTorneo} and identrenador = {participacion.IDEntrenador}").FirstOrDefault();

conexion.Table<Participacion>().Where(c => c.IDTorneo == participacion.IDTorneo && c.IDEntrenador == participacion.IDEntrenador).FirstOrDefault();

They don't work, they always return the first data where c.IDTorneo ==participacion.IDTorneo, it doesn't matter if the c.IDEntrenador matches with the participacion.IDEntrenador or not. Can you help me?

 

[Khaikaa]

I just relized it was not a problem on the sql query but a mistake on another point of my code. Problem solved.