. The value of the primary key Association foreign key in NET development

I summarize the 3 kinds:

1. According to the front desk to obtain the WID number to the background to the activity of foreign key table data back, get wname;

2. Add the property public string Wname{get;set in the Entity Class primary key table model, and join Model.wname to return the display when the BLL business logic is acquired at the front end;

3. Inline query in SQL statement: sql= "select A.*,b.wname from Goods a LEFT join Category B on A.wid=b.wid"

. The value of the primary key Association foreign key in NET development