public static List<UserComposition> Load()
        {
            using (SqlCommand sqlcmd = new SqlCommand())
            {
                List<UserComposition> ListUserCompositions = new List<UserComposition>();
                sqlcmd.Connection = new System.Data.SqlClient.SqlConnection(ConnectionString);
                sqlcmd.CommandText = "SELECT * FROM UserCompositions";
                sqlcmd.Connection.Open();
                using (var sqlreader = sqlcmd.ExecuteReader())
                {
                    if (sqlreader.HasRows)
                    {
                        while (sqlreader.Read())
                        {
                            UserComposition UserComposition = new UserComposition();
                            UserComposition.Id = (Guid)sqlreader[0];
                            UserComposition.User = (User)User.Find((Guid)sqlreader[1]);
                            UserComposition.Composition = (Composition)Composition.Find((Guid)sqlreader[2]);

                            ListUserCompositions.Add(UserComposition);

                        }
                    }
                    sqlcmd.Connection.Close();
                    return ListUserCompositions;
                }
            }
        }
 public void CreateLink(User SelectedUser, Composition SelectedComposition)
 {
     UserComposition UserComposition = new UserComposition(SelectedUser, SelectedComposition);
 }
        private void we_Click(object sender, RoutedEventArgs e)
        {
            UserComposition us = new UserComposition((User)Users.SelectedItem, (Composition)Compositions.SelectedItem);

        }