public async Task <IActionResult> SyncUsers() { var errorList = new List <string>(); try { if (_db.Connection.State == System.Data.ConnectionState.Closed) { await _db.Connection.OpenAsync(); } var query = new UserQueries(_db); var users = await query.GetAllUsers(); foreach (var user in users) { var givenName = string.IsNullOrWhiteSpace(user.first_name + " " + user.last_name) ? user.user_login : user.first_name + " " + user.last_name; if (await _userManager.FindByEmailAsync(user.user_email) == null) { var u = new ApplicationUser { UserName = user.user_login, Email = user.user_email, EmailConfirmed = true, GivenName = givenName }; await _userManager.CreateAsync(u, "P2ssw0rd!"); } } _db.Connection.Close(); } catch (Exception ex) { errorList.Add("order taxes:" + ex.ToString()); } return(Ok(errorList)); }