Edison questions

• EF core Linq groupby and having sum count - could not be translated and will be evaluated locally
• should I choose azure application gateway or load balancer or front door or traffic manager?
• DROP TABLE IF EXISTS not working on Azure SQL Data Warehouse

Edison answers