CODEWITHSUNDEEP
c#asp.net
Severin
Severin

Reputation: 8588

How to setup a relational data model?

I am completely new to ASP.NET and was trying to cross-reference two different models with each other. I have 'Customer':

public class Customer
    {
        public int CustomerID { get; set; }
        public string FirstName { get; set; }
        public string LastName { get; set; }
        public string Address { get; set; }
        public string Zipcode { get; set; }
        public string City { get; set; }
        public string Email { get; set; }
        public string Phone { get; set; }
    }

and 'Reservation':

public class Reservation
    {
        public int ReservationID { get; set; }
        public string PetName { get; set; }
        public DateTime Birthdate { get; set; }
        public string Specie { get; set; }
        public DateTime StartDate { get; set; }
        public DateTime EndDate { get; set; }
        public Customer Customer { get; set; }
    }

Now, each Reservation should belong to a Customer (as you can see in the bottom line of the Reservation model) and should therefore contain the CustomerID. On the other hand should each Customer contain references to each Reservation that was made by him.

How can I setup this relation?

Upvotes: 0

Views: 203

Answers (1)

mason
mason

Reputation: 32699

Use an ICollection for a one to many relationship.

public class Customer
    {
    public int CustomerID { get; set; }
    public string FirstName { get; set; }
    public string LastName { get; set; }
    public string Address { get; set; }
    public string Zipcode { get; set; }
    public string City { get; set; }
    public string Email { get; set; }
    public string Phone { get; set; }
    public ICollection<Reservation> Reservations { get; set; }
    }

Note I originally suggested a generic list, but there's a few subtle differences.

Upvotes: 1

Related Questions