hossein626
دوشنبه 14 دی 1388, 15:23 عصر
معادل این دستور sql در linq چیه؟
# DECLARE @tblTest AS TABLE (xmlField XML)
#
# INSERT INTO @tblTest
# (
# xmlField
# )
# VALUES
# (
# '<Sample>
# <Node1>Value1</Node1>
# <Node2>Value2</Node2>
# <Node3></Node3>
# </Sample>'
# )
#
# DECLARE @newValue VARCHAR(50)
# SELECT @newValue = 'NewValue'
#
# UPDATE @tblTest
# SET xmlField.modify(
# 'replace value of (/Sample/Node3/text())[1]
# with sql:variable("@newValue")'
# )
#
# SELECT xmlField.value('(/Sample/Node3)[1]','varchar(50)') FROM @tblTest
# DECLARE @tblTest AS TABLE (xmlField XML)
#
# INSERT INTO @tblTest
# (
# xmlField
# )
# VALUES
# (
# '<Sample>
# <Node1>Value1</Node1>
# <Node2>Value2</Node2>
# <Node3></Node3>
# </Sample>'
# )
#
# DECLARE @newValue VARCHAR(50)
# SELECT @newValue = 'NewValue'
#
# UPDATE @tblTest
# SET xmlField.modify(
# 'replace value of (/Sample/Node3/text())[1]
# with sql:variable("@newValue")'
# )
#
# SELECT xmlField.value('(/Sample/Node3)[1]','varchar(50)') FROM @tblTest