I have to save and read xml file in one column linq database

Question

I have linq database table with 3 columns one use for stored xml file
CREATE TABLE dbo.Txml

(

brRacuna int NULL,

korisnickoime varchar(50) NULL,

xmldata xml NULL

)

I need to write xml file into column xmldata and aslo read data from this column using linq query

I need realy help thanks in advance

Sumit Jolly · Answer

# Open xml file like normal text file  eg.g var xmlFile = System.IO.ReadFile(xml.dat) now store this xmlFile into sqlserver column # While you're reading it back you can use it in same fashion  e.g. var sqlOutput = db .Query( xmldata); XElement xelement = XElement.Load(sqlOutput); var name = from nm in xelement.Elements( korisnickoime ) where (string)nm.Element( korisnickoime ) == abc select korisnickoime  brRacuna ; foreach (XElement xEle in name) Console.WriteLine(xEle);

Sumit Jolly · Answer

I hope ur problem solved? if you think my code reference was useful please accept it.

miroslav nikolic · Answer

Thanks a lot But I do some different I load information from database and create my custom xml element and save it to column DataClasses1DataContext Pro = new DataClasses1DataContext(); XElement xlinq = new XElement(ProizvodUkorpi from p in Pro.ProizvodUkorpis where p.korisnickoime == korime select new XElement(proizvod new XElement(naziv p.naziv) new XElement(kolicina p.kolicina) new XElement(cena p.cena) new XElement(iznos p.iznos) ) ); Txml nov = new Txml(); nov.xmldata = xlinq; nov.korisnickoime = korime; Pro.Txmls.InsertOnSubmit(nov); Pro.SubmitChanges(); One more thanks on your time and help