Example #1
0
        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)));
            }
        }