>>>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();