public static async Task <IPictureGallery> GetGalleryAsync(this SQLiteDatabase database, string name) { IPictureGallery gallery = null; using (SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM Gallery WHERE name = $name")) { cmd.Parameters.AddWithValue("$name", name); DataRow row = await database.GetRowAsync(cmd); if (row != null) { return(await database.CreateGalleryFromDataRowAsync(row)); } } return(gallery); }
public static async Task <IPictureGallery> GetGalleryAsync(this SQLiteDatabase database, long?id) { IPictureGallery gallery = null; if (id.HasValue) { using (SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM Gallery WHERE id = $id")) { cmd.Parameters.AddWithValue("$id", id); DataRow row = await database.GetRowAsync(cmd); if (row != null) { return(await database.CreateGalleryFromDataRowAsync(row)); } } } return(gallery); }