>>>>>public MerchantModel GetMerchant(int MerchantID) >>>>>{ >>>>> MerchantModel retVal = null; >>>>> >>>>> using (TDCDataDataContext dc = new TDCDataDataContext()) >>>>> { >>>>> var merchants = (from m in dc.tblMerchants >>>>> where m.RecordId == MerchantID >>>>> select new MerchantModel >>>>> { >>>>> RecordId = m.RecordId, >>>>> CategoryId = m.CategoryId, >>>>> Title = m.Title, >>>>> Icon = m.Icon, >>>>> Slogan = m.Slogan, >>>>> DateAdded = m.DateAdded, >>>>> Rating = m.Rating.Value, >>>>> WebSiteURL = m.WebSiteURL >>>>> }).ToList(); >>>>> >>>>> retVal = merchants[0]; >>>>> } >>>>> >>>>> return retVal; >>>>>} >>>>>>>>>>
>>>public MerchantModel GetMerchant(int MerchantID) >>>{ >>> MerchantModel retVal = null; >>> >>> TDCDataDataContext dc = new TDCDataDataContext(); >>> >>> var merchants = (from m in dc.tblMerchants >>> where m.RecordId == MerchantID >>> select new MerchantModel >>> { >>> RecordId = m.RecordId, >>> CategoryId = m.CategoryId, >>> Title = m.Title, >>> Icon = m.Icon, >>> Slogan = m.Slogan, >>> DateAdded = m.DateAdded, >>> Rating = m.Rating.Value, >>> WebSiteURL = m.WebSiteURL >>> }).ToList(); >>> >>> retVal = merchants[0]; >>> >>> return retVal; >>>} >>>>>>
return (from......).FirstOrDefault();>