//

*****************************************************************************************************************

//

LNQ Retrieving related entity columns (for 1 to N relationships)

//

*****************************************************************************************************************

System.Console.WriteLine();

System.Console.WriteLine(

"

List of Contact and Account Info by retrieving related entity columns

"

);

System.Console.WriteLine(

"

======================================

"

);

var query_retrieve1

=

from c

in

context.ContactSet

join a

in

context.AccountSet on c.ContactId equals a.PrimaryContactId.Id

where

c.ContactId

!=

_contactid2

select

new

{ Contact

=

c, Account

=

a };

foreach

(var c

in

query_retrieve1)

{

System.Console.WriteLine(

"

Acct:

"

+

c.Account.Name

+

"

\t\t

"

+

"

Contact:

"

+

c.Contact.FullName);

}

System.Console.WriteLine(

"

=====================================

"

);

System.Console.WriteLine();