Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
LinqToSql Question
Message
General information
Forum:
ASP.NET
Category:
LINQ
Title:
LinqToSql Question
Miscellaneous
Thread ID:
01486527
Message ID:
01486527
Views:
109
I have this method:
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;
}
Do I have to use ToList to make this work? How do I query for just one Merchant and return the MerchantModel?

Thanks
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Next
Reply
Map
View

Click here to load this message in the networking platform