>>>>>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()' >>} >> >>>
public MerchantModel GetMerchant(int MerchantID) >{ > using (TDCDataDataContext dc = new TDCDataDataContext()) > { > return (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 > }).FirstOrDefault() > } >}I certainly don't know much about this topic so my comments are for my educational purpose. As I understand it, L2S with regards to lazy loading is implicit and thus you shouldn't need to use .ToList or any operator to cause an eager load. L2EF is the opposite. Is this the point here or how does the data context going out of scope impact this?