Linq query multple tables with different attributes

[Hatake910]

I have a search that looks for two things. Items and Contacts. They each have there own table with there own unqiue attributes. I am able to sucessfully search each independant of eachother and return the results to two list views. But is it ugly and paging has become a issue so I have to convert these two tables into a like result that I can display as a search result. These results have no relationship directly with eachother.The \[code\]group t3 by new\[/code\] is throwing me off. Do i have to group them to have it become a like result? The results currently get displayed in a ListView using for example \[code\]<%#Eval("ItemName") %>\[/code\]\[code\]ItemContext db = new ItemContext(); //DB connection (Item,Contact) var q = (from t1 in db.Item join t2 in db.Categories on t1.CategoryID equals t2.CategoryID join t7 in db.Divisions on t1.DivisionID equals t7.DivisionID from t3 in db.Contacts join t4 in db.Categories on t3.CategoryID equals t4.CategoryID join t5 in db.Divisions on t3.DivisionID equals t5.DivisionID join t6 in db.ContactTitle on t3.ContactTitlesID equals t6.ContactTitlesID where (DDLInt == 1 || t3.DivisionID == DDLInt) && //Contains ( t3.ContactName.Contains(keyword) || t3.ContactEmail.Contains(keyword) || t3.ContactOPhone.Contains(keyword) || t3.ContactID.Equals(searchID) ) group t3 by new { t3.ContactID, t3.ContactName, t3.ContactOPhone, t3.ContactCell, t3.ContactEmail, t3.DivisionID, t3.CategoryID, t4.CategoryName, t5.DivisionName, t6.ContactTitlesName } into i select new { i.Key.ContactID, i.Key.ContactName, i.Key.ContactOPhone, i.Key.ContactEmail, i.Key.ContactCell, i.Key.CategoryName, i.Key.DivisionName, i.Key.CategoryID, i.Key.DivisionID, i.Key.ContactTitlesName }); return q.ToList<dynamic>(); }\[/code\]