>>>>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 > }; > > retVal = merchants.FirstOrDefault(); > > return retVal.ToList(); >} > >>
>public MerchantModel GetMerchant(int MerchantID) >{ > 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 > }; > > return merchants.FirstOrDefault().ToList(); >} > >>
>public MerchantModel GetMerchant(int MerchantID) >{ > 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 > }; > > return merchants.FirstOrDefault()' >} > >Thsi is exactly what I'm looking for. Since I passed in a PK, then I know I'll get back one Merchant.