using System;

public class Program

{

    public static void Main()

    {

        Console.WriteLine("Hello World");

    }

    public void databaseDoSomething()

    {

        Database.SetInitializer(new InventarioContextInitializer());

​

​

            using (var db = new InventarioContext())

            {

​

​

                var brands = new List<Brand>()

                {

                    new Brand() { Created = DateTime.Now, Description = "VW", Name = "VW" },

​

                    new Brand() { Created = DateTime.Now, Description = "GM", Name = "GM" }

                };

​

​

​

                brands.ForEach(b =>

                {

​

                    db.Brands.Add(b);

                });

​

                db.SaveChanges();

​

                var vwBrandId = db.Brands.FirstOrDefault(b=> b.Name=="VW");

​

                var vwModels = new List<Model>()

                {

                    new Model() { BrandId = vwBrandId.ID , ShortDescription = "Jetta", Description ="Jetta"},

                    new Model() { BrandId = vwBrandId.ID , ShortDescription = "Passat", Description ="Passat"},

                    new Model() { BrandId = vwBrandId.ID , ShortDescription = "Beetle", Description ="Beetle"}

                };

​

                db.Model.AddRange(vwModels);

​

                db.SaveChanges();

​

                var colors = new List<Color>

                {

                    new Color(){ Name="Platinum Gray Metallic"},

                    new Color(){ Name="Tornado Red"},

                    new Color(){ Name="Pure White"},

                    new Color(){ Name="Black"}

                };

​

                db.Colors.AddRange(colors);

​

                var jetta = db.Model.FirstOrDefault(m=> m.ShortDescription =="Jetta");

​

​

                ModelVersion JettaGLISE = new ModelVersion()

                {

                    Colors = colors,

                    FichaTecnica = null,

                    ModelId = jetta.ID,

                    Name = "GLI SE",

                    Tramision = Tramision.Automatica,

                    Year = 2015

                };

​

​

​

                db.ModelVersion.Add(JettaGLISE);    

​

                db.SaveChanges();

​

​

                var found  = db.ModelVersion.FirstOrDefault(mv => mv.Name == "GLI SE");

​

​

                var colorsnew = new List<Color>

                {

                    new Color(){ Name="Green"},

                    new Color(){ Name="Yellow"},

                    new Color(){ Name="Pink"},

                    new Color(){ Name="Red"}

                };

​

                db.Colors.AddRange(colorsnew);

​

                db.SaveChanges();

​

                var colorsList = db.Colors.ToList();

    }

}