//group all above policies by broker to send an email about "broker re-assignment'
var brokerPolicies = from pol in policy.ListData.AsEnumerable()
group pol by pol.Field<int>("intUserID") into grp
select new
{
brokerID = grp.Key,
listOfPolicies = from x in grp.AsEnumerable()
select new
{
list = String.Format("{0:00}-{1:000000}",x.Field<short>("intPolicySequence"), x.Field<int>("intPolicyNumber"))
}
};