阅读背景:

实体框架ExecuteSQLCommand返回XML字符串

来源:互联网 

I have the following code:

我有以下代码:

_sql += "SELECT [CodeListNumber] as '@Number'"
_sql += "      ,[ShortDescription]"
_sql += "      ,[ExpiryDate]"
_sql += "      ,[CompositeCode]"
_sql += "  FROM [Aviva_Guidewire_Dev_V3].[dbo].[Aviva_CompleteCodeList] as [CodeListNumber]"
_sql += "  order by [CodeListNumber]"
_sql += "  for xml path('CodeList'), root('CodeLists'), elements"

Dim params As String()
Dim _Rtn As String = _dbRoot.Database.ExecuteSqlCommand(_sql, params)
Dim _xDoc As New XmlDocument
_xDoc.LoadXml(_Rtn)
_sql += 



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: