public static void AssignEmailConfirmation(int userId, Guid?emailConfirmation, bool isActive = false)
{
using (SqlCmd cmd = new SqlCmd("UPDATE [User] SET EmailConfirmation = @EmailConfirmation, IsActive = @IsActive WHERE Id = @Id", false))
{
cmd.AddIInt("@Id", userId);
cmd.AddIGuid("@EmailConfirmation", emailConfirmation);
cmd.AddIBool("@IsActive", isActive);
cmd.Execute();
}
}