试试这个：

  var  listOfUsers =（ from  x  in  context.CMSPI_CODICIACCESSO 
 join  u  in  context.CMSPI_ANAGRAFICAINFOBASE on x.IDANAGRAFICA等于u.IDANAGRAFICA 
选择  new  {
 RowA = x，RowB = u 
}）; 
 DataTable result =  new  DataTable（）; 
 foreach （ var  x  in  listOfUsers）
 {
 result.Rows.Add（x.RowA，x.RowB）; 
} 

--Amit

Hello!
I have code:

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

Try this:

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