ASP.NET MVC4: How do I keep from having multiple identical results in my lookup tables

Posted by sehummel on Stack Overflow See other posts from Stack Overflow or by sehummel
Published on 2012-12-05T23:01:49Z Indexed on 2012/12/05 23:03 UTC
Read the original article Hit count: 188

I'm new to ASP.NET so this may be an easy question. I'm seeding my database with several rows of dummy data. Here is one of my rows:

new Software { Title = "Microsoft Office", Version = "2012", SerialNumber = "12346231434543", Platform = "PC", Notes = "Macs really rock!", PurchaseDate = "2011-12-04", Suite = true, SubscriptionEndDate = null, SeatCount = 0, SoftwareTypes = new List<SoftwareType> { new SoftwareType { Type="Suite" }}, Locations = new List<Location> { new Location { LocationName = "Paradise" }}, Publishers = new List<SoftwarePublisher> { new SoftwarePublisher { Publisher = "Microsoft" }}}

But when I do this, a new row is created for each location, with the LocationName being set in each row like this. We only have two locations. How do I get it to create a LocationID property for the Software class and in my Locations class. Here is my Location class:

public class Location
    {
        public int Id { get; set; }
        [Required]
        [StringLength(20)]
        public string LocationName { get; set; }
        public virtual Software Software { get; set; }
    }

I have this line in my Software class to reference this table:

public virtual List<Location> Locations { get; set; }

Again, what I want when I am done is a Locations table with two entries, and a LocationID field in my Software table. How do I do this?

© Stack Overflow or respective owner

Related posts about asp.net-mvc

Related posts about entity-framework