How to write Entity Framework when the table has foreign key

Question

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

There is a link that might help you. Check here http://stackoverflow.com/questions/1589166/it-has-a-definingquery-but-no-insertfunction-element-err[enter link description here][1] [1]: http://stackoverflow.com/questions/1589166/it-has-a-definingquery-but-no-insertfunction-element-err — Pradip, Sep 24 '12 at 21:01

score 0 · Answer 1 · edited May 23 '17 at 11:56

0

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.

edited May 23 '17 at 11:56

Community

answered Sep 24 '12 at 22:13

Ladislav Mrnka

1 Answers1