public void seed()
        {

            this.Database.EnsureCreated();

            if (this.Event.Any())
            {
                return;
            }

            Event.AddRange(new List<Event>()
            {
                new Event(){Title = "Partaj", Description = "Fest", Place = "Halmstad", Address = "Tullgatan", Date = "27/3", SpotsAvailable = 101, Organizer = "Partajarna"},
                new Event(){Title = "Partaj2", Description = "Fest2", Place = "Halmstad2", Address = "Tullgatan2", Date = "28/3", SpotsAvailable = 102, Organizer = "Festarna"},
                new Event(){Title = "Partaj3", Description = "Fest3", Place = "Halmstad3", Address = "Tullgatan3", Date = "29/3", SpotsAvailable = 103, Organizer = "Kalasarna"},
                new Event(){Title = "Partaj4", Description = "Fest4", Place = "Halmstad4", Address = "Tullgatan4", Date = "27/4", SpotsAvailable = 104, Organizer = "Pajaserna"}
            });

            Organizer.AddRange(new List<Organizer>()
            {
                new Organizer(){Name = "Partajarna", Email = "Fest", PhoneNumber = "Halmstad"},
                new Organizer(){Name = "Festarna", Email = "Fest2", PhoneNumber = "Halmstad2"},
                new Organizer(){Name = "Kalasarna", Email = "Fest3", PhoneNumber = "Halmstad3"},
                new Organizer(){Name = "Pajaserna", Email = "Fest4", PhoneNumber = "Halmstad4"}
            });

            Attendee.AddRange(new List<Attendee>()
            {
                new Attendee(){Name = "John Nilsson", Email = "*****@*****.**", PhoneNumber = "0738318513"}
            });

            

            this.SaveChanges();
        }