Wednesday, 30 July 2014

Save and read xml file into linq database in column xml data type using linqdatacontext



I have this sql table Which I using in Datacontext in aplication



CREATE TABLE dbo.Txml(
brRacuna int NULL,
korisnickoime varchar(50) NULL,
xmldata xml NULL
)


I have xml file which have this look



<ProizvodUkorpi>
<proizvod>
<naziv>fff</naziv>
<kolicina>2</kolicina>
<cena>567</cena>
<iznos>1134</iznos>
</proizvod>
<proizvod>
<naziv>cam</naziv>
<kolicina>1</kolicina>
<cena>678</cena>
<iznos>678</iznos>
</proizvod>
<proizvod>
<naziv>alarm</naziv>
<kolicina>2</kolicina>
<cena>3456</cena>
<iznos>6912</iznos>
</proizvod>
</ProizvodUkorpi>


I want to save and read this xml file into linq database table into column xmldata which is xml data type


How I can do that using datacontext and fuction insertonsubmit and submitchanges, I hope someone can help me


No comments:

Post a Comment