SQLite database query with multiple WHERE conditions
Assuming you are using SQLite-Net as your ORM, you can just pass in the parameters after the query. As far as I know there is no support for anonymous classes, as in your example. Try this:
var existingmaintenance = db.Query<maintenance>( "select * from maintenance where VehID = ? AND MaintID = ?", Maintenance.Vehicleid, Maintenance.Maintid).FirstOrDefault();You can also use a linq query, like so:
var existingmaintenance = db.Table<maintenance>().Where (c => c.VehID == Maintenance.Vehicleid && c.MaintID == Maintenance.Maintid).FirstOrDefault();
Try this
I hope both Id are int in database
var existingmaintenance = db.Query<maintenance> ("select * from maintenance where VehID = " + Maintenance.Maintid + " AND MaintID = " + Maintenance.Vehicleid ).FirstOrDefault();