format problem query linq to xml

Question

format problem query linq to xml

Navigation

#1 by (0 votes)

0

I do the following linq query on an xml file, and it shows me this result, how can I remove the keys and the text (code =), I am programming on asp.net c #.

this is the linq query

var q = (from r in LicitacionesD.Descendants("Licitacion")
                     where r.Element("CodigoEstado").Value == "8"
                     select new
                     {
                         codigo = r.Element("CodigoExterno").Value + " " + r.Element("Nombre").Value

                     });

linq asp.net xml

asked by leonoscuro 23.05.2016 в 19:04

source

1 answer

Error: Data too long for column 'image' at row 1 with MySQL medium column Return null in SQLite

score 0 · Accepted Answer

You can only build the text as C # IEnumerable<string> with the query

from r in LicitacionesD.Descendants("Licitacion")
                     where r.Element("CodigoEstado").Value == "8"
                     select r.Element("CodigoExterno").Value + " " + r.Element("Nombre").Value

If you know that there is only one element or if you only want to find the first element you can use

string codigo = (from r in LicitacionesD.Descendants("Licitacion")
                         where r.Element("CodigoEstado").Value == "8"
                         select r.Element("CodigoExterno").Value + " " + r.Element("Nombre").Value).FirstOrDefault();