public string UpDateHeader(HeaderEntityDL headerToDB)
        {
            try
            {
                using (EntityFramework accessToDB = new EntityFramework())
                {
                    accessToDB.Entry(headerToDB).State = EntityState.Modified;
                    accessToDB.SaveChanges();
                    return("Die Anforderung wurde erfüllt");
                }
            }
            catch (Exception ex)
            {
                string error = $"Die Anforderung wurde nicht erfüllt. Unten Fehlerbeschreibung: \n{ex.Message.ToString()}";
                return(error);
            }

            //using (SqlConnection connection = new SqlConnection(ConnectionString))
            //{
            //    connection.Open();
            //    using (SqlCommand command = new SqlCommand("UPDATE Header SET Title=@Title, Text=@Text , Link1Text=@Link1Text, Link1Address=@Link1Address, Link2Text=@Link2Text, Link2Address=@Link2Address", connection))
            //    {
            //        command.Parameters.AddWithValue("@Title", headerToDB.Title);
            //        command.Parameters.AddWithValue("@Text", headerToDB.Text);
            //        command.Parameters.AddWithValue("@Link1Text", headerToDB.Link1.LinkText);
            //        command.Parameters.AddWithValue("@Link1Address", headerToDB.Link1.LinkAddress);
            //        command.Parameters.AddWithValue("@Link2Text", headerToDB.Link2.LinkText);
            //        command.Parameters.AddWithValue("@Link2Address", headerToDB.Link2.LinkAddress);
            //        command.ExecuteNonQuery();
            //    }
            //}
        }
        //private const string ConnectionString = @"Data Source=.\sqlexpress;Initial Catalog=WebDB;Integrated Security=True";

        // HEADER
        public HeaderEntityDL GetHeaderData()
        {
            try
            {
                using (EntityFramework accessToDB = new EntityFramework())
                {
                    return(accessToDB.HeaderEntityDLTable.SingleOrDefault());
                }
            }
            catch (Exception ex)
            {
                HeaderEntityDL error = new HeaderEntityDL();
                error.Title          = "Die KopfSeite wurde nicht eingelesen";
                error.Text           = "Unten Fehlerbeschreibung: \n";
                error.Link1.LinkText = ex.Message.ToString();
                return(error);
            }
            //using (SqlConnection connection = new SqlConnection(ConnectionString))
            //{
            //    connection.Open();
            //    using (SqlCommand command = new SqlCommand("SELECT Title,Text,Link1Text,Link1Address,Link2Text,Link2Address FROM Header", connection))
            //    {
            //        using (SqlDataReader reader = command.ExecuteReader())
            //        {
            //            if (!reader.Read())
            //            {
            //                return null;
            //            }
            //            HeaderEntityDL headerEntityDL = new HeaderEntityDL(); headerEntityDL.Link1 = new LinkDL(); headerEntityDL.Link2 = new LinkDL();
            //            headerEntityDL.Title = reader.GetString(reader.GetOrdinal("Title"));
            //            headerEntityDL.Text = reader.GetString(reader.GetOrdinal("Text")) ?? string.Empty;
            //            headerEntityDL.Link1.LinkText = reader.GetString(reader.GetOrdinal("Link1Text")) ?? string.Empty;
            //            headerEntityDL.Link1.LinkAddress = reader.GetString(reader.GetOrdinal("Link1Address")) ?? string.Empty;
            //            headerEntityDL.Link2.LinkText = reader.GetString(reader.GetOrdinal("Link2Text")) ?? string.Empty;
            //            headerEntityDL.Link2.LinkAddress = reader.GetString(reader.GetOrdinal("Link2Address")) ?? string.Empty;
            //            return headerEntityDL;
            //        }
            //    }
            //}
        }