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)));
}
}