protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                Beer b = new PremiumBeer();
                b.Name = "Primator";
                b.Weight = b.InitialWeight = 645;
                b.Country = "CZECH";

                using (TweetBeerContainer dbContainer = new TweetBeerContainer())
                {
                    #region Inserting

                    dbContainer.AddToBeer(b);
                    dbContainer.SaveChanges();

                    #endregion

                    #region Updating

                    b.Name = "Corona";
                    dbContainer.SaveChanges();

                    #endregion

                    #region Delete

                    //dbContainer.DeleteObject(b);
                    //dbContainer.SaveChanges();

                    #endregion

                    #region LINQ Query

                    var coronas = from beer in dbContainer.Beer.ToList()
                                  where beer.Name == "Corona"
                                  select beer;

                    #endregion
                }

                #region Equivalent to using

                //TweetBeerContainer v = null;
                //try
                //{
                //    v = new TweetBeerContainer();
                //    // Fazer um monte de coisa
                //}
                //catch
                //{
                //}
                //finally
                //{
                //    v.Dispose();
                //}

                #endregion
            }
        }
        /// <summary>
        /// Create a new PremiumBeer object.
        /// </summary>
        /// <param name="id">Initial value of the Id property.</param>
        /// <param name="name">Initial value of the Name property.</param>
        /// <param name="country">Initial value of the Country property.</param>
        /// <param name="weight">Initial value of the Weight property.</param>
        /// <param name="initialWeight">Initial value of the InitialWeight property.</param>
        public static PremiumBeer CreatePremiumBeer(global::System.Int64 id, global::System.String name, global::System.String country, global::System.Double weight, global::System.Double initialWeight)
        {
            PremiumBeer premiumBeer = new PremiumBeer();

            premiumBeer.Id            = id;
            premiumBeer.Name          = name;
            premiumBeer.Country       = country;
            premiumBeer.Weight        = weight;
            premiumBeer.InitialWeight = initialWeight;
            return(premiumBeer);
        }
 /// <summary>
 /// Create a new PremiumBeer object.
 /// </summary>
 /// <param name="id">Initial value of the Id property.</param>
 /// <param name="name">Initial value of the Name property.</param>
 /// <param name="country">Initial value of the Country property.</param>
 /// <param name="weight">Initial value of the Weight property.</param>
 /// <param name="initialWeight">Initial value of the InitialWeight property.</param>
 public static PremiumBeer CreatePremiumBeer(global::System.Int64 id, global::System.String name, global::System.String country, global::System.Double weight, global::System.Double initialWeight)
 {
     PremiumBeer premiumBeer = new PremiumBeer();
     premiumBeer.Id = id;
     premiumBeer.Name = name;
     premiumBeer.Country = country;
     premiumBeer.Weight = weight;
     premiumBeer.InitialWeight = initialWeight;
     return premiumBeer;
 }