public async Task <long> GetNextId() { object id = await template.ScalarAsync <int>("SELECT `auto_increment` value FROM INFORMATION_SCHEMA.TABLES WHERE table_name = 'address'"); return(Convert.ToInt64(id)); }