Tables t1 {id, name, addr_id}
and t2 {addr_id, addr}
When you create entity for t1
like
dim db = new t1entity()
dim tt = from t in db.t1s where t.addr_id
Here, I cannot use addr_id
corresponding to the t
Tables t1 {id, name, addr_id}
and t2 {addr_id, addr}
When you create entity for t1
like
dim db = new t1entity()
dim tt = from t in db.t1s where t.addr_id
Here, I cannot use addr_id
corresponding to the t
If you have navigation properties correctly set, you can use where t.t2.addr_id
. If you are using .NET 4.0 or newer you can tell EF to generate addr_id
property directly in t1
entity. That will use FK association instead of independent association you are using at the moment.