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 +=