nested linq-to-sql queries
- by ile
var result = (
from contact in db.Contacts
join user in db.Users on contact.CreatedByUserID equals user.UserID
orderby contact.ContactID descending
select new ContactListView
{
ContactID = contact.ContactID,
FirstName = contact.FirstName,
LastName = contact.LastName,
Company = (from field in contact.XmlFields.Descendants("Company")
select field.Value).SingleOrDefault().ToString()
}).Take(10);
Here I described how my database tables look like. So, contacts table has one field that is xml type. In that field is stored Company filename and I need to read it. I tried it using this way:
Company = (from field in contact.XmlFields.Descendants("Company")
select field.Value).SingleOrDefault().ToString()
}).Take(10);
but I get following error:
Member access 'System.String Value' of
'System.Xml.Linq.XElement' not legal
on type
'System.Collections.Generic.IEnumerable`1[System.Xml.Linq.XElement].
Any solution for this?
Thanks in advance,
Ile
