How to map an Entity Framework model that has a list property using SQL

Question

I am using Database first approach to map my tables to entity models. Currently I have two tables, Orders and Products:

Orders: Id, DateCreated

Products: Id, Name, OrderId

As you can see it's a one to many relationship. And I would like to create a view using these two tables and map it to an entity called Order and Products:

public class Order
{
    public int Id {get;set;}
    public DateTime DateCreated {get;set;}
    public IList<Product> Products {get;set;}
}

public class Product
{
    public int Id {get;set;}
    public string Name {get;set;}
}

I know how to map a single property, but have no idea how I would approach it for a list property. Any ideas?

Please note that the tables are slightly more complicated and I HAVE TO use views to map these entities.

Alexander Taran · Accepted Answer · 2016-12-05 17:03:33Z

1

there are a lot of guides on it around the web. one of them is @ msdn site

Replace IList with ICollection and you should be good with that.

answered Dec 5, 2016 at 17:03

Alexander Taran

6,7252 gold badges42 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Joel Min Over a year ago

that was very helpful. THANKS!

Collectives™ on Stack Overflow

How to map an Entity Framework model that has a list property using SQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related