public async Task <int> InsertAsync(User user)
        {
            _logger.LogDebug($"User {_authenticatedService.GetUserKey()} is inserting a new User - {user}");

            var parameters = new DynamicParameters();

            parameters.Add("name", user.Name, direction: ParameterDirection.Input);
            parameters.Add("email", user.Email, direction: ParameterDirection.Input);
            parameters.Add("password", user.Password, direction: ParameterDirection.Input);
            parameters.Add("active", user.Active, direction: ParameterDirection.Input);
            parameters.Add("confirmed", user.Confirmed, direction: ParameterDirection.Input);
            parameters.Add("created", user.Created, direction: ParameterDirection.Input);
            parameters.Add("createdby", user.CreatedBy, direction: ParameterDirection.Input);
            parameters.Add("updated", user.Updated, direction: ParameterDirection.Input);
            parameters.Add("updatedby", user.UpdatedBy, direction: ParameterDirection.Input);

            var id = await _sqlService.ExecuteScalarAsync <int>(UserQuery.INSERT, CommandType.Text, parameters);

            _logger.LogDebug($"User {id} inserted");

            return(id);
        }