public int Add(User entity)
        {
            int affectedRows = this.connection.ExecuteScalar <int>(
                UserQuery.Add(),
                new
            {
                FirstName  = entity.FirstName,
                LastName   = entity.LastName,
                Email      = entity.Email,
                Bio        = entity.Bio,
                CreateDate = DateTime.Now,
                UserTypeId = entity.Type,
                IsActive   = entity.IsActive
            },
                this.transaction);

            return(affectedRows);
        }