public IEnumerable <Bill> RetrieveAdvanced(int id) { var database = new SQLiteDatabase(); var query = string.Format("SELECT * FROM {0} WHERE Id = @Id", Bill.FullTableName); using (var command = database.CreateCommand(query)) { command.Parameters.Add(database.CreateParameter("@Id", id)); return(Bill.Create(database.GetData(command))); } }