>>>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(); }The ToList() is optional and is ONLY needed if you absolutely need to be sure the query has been executed before exiting this method (for example, you put the using statement back in).
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(); }If you don't need the query run before exiting the method:
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()' }