public Post Get(int id) { using (var conn = new SQLiteConnection(Connectionstring)) { conn.Open(); var p = conn.Get<Post>(id); conn.Close(); return p; } }
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; }