Esempio n. 1
0
        public Post Get(int id)
        {
            using (var conn = new SQLiteConnection(Connectionstring)) 
            {
                conn.Open();

                var p = conn.Get<Post>(id);

                conn.Close();

                return p;
            }
        }
Esempio n. 2
0
        public bool Delete(int id)
        {
            bool result = false;

            if (id > 0)
            {

                using (var conn = new SQLiteConnection(Connectionstring))
                {
                    conn.Open();

                    var item = conn.Get<Post>(id);

                    if (item != null)
                    {
                        result = conn.Delete(item);
                    }

                    conn.Close();
                }
            }

            return result;
        }