linq mysql 多表,从数据库获取所有表，并使用C＃，linq查询和实体框架工作循环遍历每个表...

I have sql server 2012 database with 12 tables (excluding look up tables). i am using entity frame work and trying to query. i am able to query a table:ClientEntities dc = new ClientEntities();

var query = from client1 in dc.CLIENTTable

where client1.CLIENT_ID == txtId.Text

select client1;

above works for 1 table but i need to do it for all the 12 tables. Is there a way to do it in loop

解决方案

Yes, if your other tables have keys that link them together, you can do it. Otherwise, you need to read them separately. You need to explain why you want to do this, and what you''re trying to achieve. As it stands, it makes no sense at all.

You realise that you''ll have to define your own type that contains the combined data ? You can''t read the data from one table and store it in a type from another table, EF is all strongly typed. You can use var to create an anonymous type, of course.