Problem in using Lambda expressions

Question

Hi all,

I have a problem and need help to address this urgent requirement.

The data in the database table resembles like the as below.

 

ID	Name
1001	john
1002	davis
1003	name
1002	name
1001	johny
1003	mani
1003	ganesh

 

I need to show the string in the table like below using c# linq

ID	Name
1001	John, johny
1002	Davis, name
1003	Name, mani, ganesh

 

or

 

1001 = john, Johnny

1002 = davis, name

1003 = name, mani, ganesh

 

Any kind of solution to this problem is greatly appreciated.


Thanks in advance.

Regards,

Rajesh