entity framework 4 - MS EF4: How to decipher a self referencing table? -


I have a product table, such as Field:

  Public class product {public int ID {Get; Set;} ...}  

and a table that includes products in other "cross-cell" products (like items):

  Public square crossover {public integer productivity}; Set;} Public Ink Cross-CellId {get; My intention is to any product, receives a list of cross-selling products  

Unit Framework 4 (EF Second Edition)

Takes these tables and creates a product and product 1 relationship, where the line joining the table is called crossover.

What do I have to do:

  public class product {public id id {get; Set;} ... Public IList & lt; Products & gt; ESP made it:  
  public class product {public Ent ID {get; Set;} ... Public IList & LT; Products & gt; Product {get; Set;} Public IList & lt; Products & gt; Product 1 {get; Set;}} Can I just delete another list by product 1, change the name of "cross-cell" for the first time, and do all this work only magically? Should I remake the SQL tables differently so that EF could better understand my intentions? What do these SQL tables look like if there can be multiple cross-sale items in the same product?  

Edit:

What I'm really looking for is a circular reference. Right now, the product refers to other products which in turn refers to other products ... itemprop = "text">

Find the unit in the model browser Product 1 find the property click it. Rename it in the Property Editor.


Comments