>>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; }I want to do this without having to do the ToList and the merchants[0], so I guess I'm asking what the syntax is to do a FirstOrDefault along with the "new Merchant" part?