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