Entity Framework (select all fields from two table)

Question

0.00/5 (No votes)

See more:

Hello!
I have code:

CSS

var listOfUsers = from a in context.CMSPI_CODICIACCESSO
                              join b in context.CMSPI_ANAGRAFICAINFOBASE
                              on a.IDANAGRAFICA equals b.IDANAGRAFICA
                              select b;

But this code returns only fields from table a. I need return all fields from every tables. How it make? Thank you

Posted 8-Apr-13 0:57am

Junoli

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

_Amy · Answer 1 · 2013-04-08T01:40:00

Solution 2

Try this:

C#

var listOfUsers = (from x in context.CMSPI_CODICIACCESSO
         join u in context.CMSPI_ANAGRAFICAINFOBASE on x.IDANAGRAFICA equals u.IDANAGRAFICA
    select new {
          RowA = x, RowB = u
    });
DataTable result = new DataTable();
foreach (var x in listOfUsers)
{
     result.Rows.Add(x.RowA , x.RowB);
}

--Amit

Posted 8-Apr-13 1:40am

_Amy

Updated 8-Apr-13 2:04am

v2

Comments

[no name] 8-Apr-13 7:58am

So it is good solutions. But how i can display it at VIEW? at emp there is two objects:
RowA = {CMSPI.Models.CMSPI_CODICIACCESSO}
RowB = {CMSPI.Models.CMSPI_ANAGRAFICAINFOBASE}
and at each there are fields that i must show

_Amy 8-Apr-13 8:05am

Marked as Answer and Again Undo. Why?
Anyways, see my updated solution with a Resultant DataTable. Now you can do anything with the result DataTable.

[no name] 8-Apr-13 8:13am

i can not use DataTable. I must show it at table HTML.

_Amy 8-Apr-13 8:15am

Yes, then loop through the DataTable and show the content in HTML Table. There should not be any problem in that.

[no name] 8-Apr-13 8:31am

Can you show me example. I dont understand

_Amy 8-Apr-13 8:36am

Try like this:

foreach(DataRow drow in result.Rows)
{
//Write your code here to put the values in Html Table. e.g.
//Console.WriteLine(drow["YourColumnName"].ToString());
}

--Amit

[no name] 8-Apr-13 8:38am

I can repaet problem. At loop foreach @foreach (var emp in ViewBag.list)
i have at amp the next object: emp = { USERNAME = 1, COGNOME = ponm, NOME = olg, EMAIL = o@mail.su, CODICEFISCALE = 111 , PARTITAIVA = 222 , TELEFONOPRINCIPALE = 333333, TELEFONOSECONDARIO = 333, CELLULARE = 333, FAX = 33333, STATOANAGRAFICA = 3 }

How i can show TELEFONOPRINCIPALE, TELEFONOSECONDARIO and etc?

[no name] 8-Apr-13 8:49am

If do how you advised me. then get error: Input array is longer than the number of columns in this table.

[no name] 8-Apr-13 9:56am

Have idies?

[no name] 9-Apr-13 3:35am

Problem is at dinamic object, need convert it