// Checks for empty zones private async Task <string[]> _getEmptyZoneIdeasAsync() { List <string> ideas = new List <string>(); using (SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM Zones WHERE id NOT IN (SELECT zone_id FROM SpeciesZones);")) using (DataTable table = await Database.GetRowsAsync(cmd)) foreach (DataRow row in table.Rows) { ideas.Add(string.Format("**{0}** does not contain any species yet. Why not make one?", ZoneUtils.ZoneFromDataRow(row).GetFullName())); } return(ideas.ToArray()); }