public void AddReview(int videoId, Guid userId, string reviewText)
    {
            var connSettings = ConfigurationManager.ConnectionStrings["VideoLibrary"];
            var connString = connSettings.ConnectionString;


            using (var conn = new SqlConnection(connString))
            {
                var cmd = conn.CreateCommand();
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = @"
INSERT INTO dbo.Reviews (VideoId, UserId, Review)
Values (@VideoID, @UserID, @Review)
";
                cmd.Parameters.AddWithValue("VideoID", videoId);
                cmd.Parameters.AddWithValue("UserID", userId);
                cmd.Parameters.AddWithValue("Review", reviewText);
                conn.Open();

                cmd.ExecuteNonQuery();

            }

    }