Click here to Skip to main content
12,761,707 members (41,719 online)
Rate this:
Please Sign up or sign in to vote.
See more: 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
Posted 21-Jul-12 6:50am
Updated 21-Jul-12 7:45am
WoodenLegNamedSmith 21-Jul-12 12:20pm
woutercx 21-Jul-12 16:22pm
Do these other tables also have a CLIENT_ID? I'm trying to find out what it is exactly that you're trying to accomplish.
Wonde Tadesse 21-Jul-12 16:47pm
If there is no relationships b/n the tables, There is no way to iterate a record for all tables with a single select statement.
Christian Amado 21-Jul-12 17:25pm
Why you want to do something like that? I think is unnecessary.

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

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.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170217.1 | Last Updated 21 Jul 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100