Hi,
I've got this code and I wanted to refactor it and put it into my Data Layer so I can call it multiple times and not have to keep copy pasting it.
var gridDS = from compEntries in db.tblCompetitionEntries
join comp in db.tblCompetitions on compEntries.CompetitionId equals comp.CompetitionId
join title in db.tblTitles on compEntries.TitleId equals title.TitleId
join province in db.tblProvinces on compEntries.ProvinceId equals province.ProvinceId
orderby compEntries.FirstName descending
select new
{
CompetitionEntryId = compEntries.CompetitionEntryId,
Competition = comp.CompetitionName,
Title = title.Title,
FirstName = compEntries.FirstName,
Surname = compEntries.SurN ...
Go to the complete details ...