我试图创建一个数据源的XElement以插入到SSRS RDL文件中。但是,我似乎无法让它正确地创建rd:别名。这是我正在使用的代码。
XNamespace rootNs = "http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition";
XNamespace rdNs = "http://schemas.microsoft.com/SQLServer/reporting/reportdesigner";
XElement _dataSource = new XElement("DataSource",
new XAttribute(XNamespace.Xmlns + "rd", rdNs),
new XAttribute("Name", "eFinancials_LOCAL"),
new XElement("ConnectionProperties", new XElement("DataProvider", "SQL"), new XElement("ConnectString", connectionString)),
new XElement(_rdns + "SecurityType", "DataBase"),
new XElement(_rdns + "DataSourceID", dataSourceId)
);
生成的XML元素是:
<DataSource xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" Name="eFinancials_LOCAL">
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>Data Source=.;Initial Catalog=800_LMS_eFin_Deploy</ConnectString>
</ConnectionProperties>
<SecurityType xmlns="rd">DataBase</SecurityType>
<DataSourceID xmlns="rd">56e5e869-6ca5-44f9-8340-22821177569e</DataSourceID>
</DataSource>
但是,它必须是:
<DataSource Name="eFinancials_LOCAL">
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>Data Source=.;Initial Catalog=800_LMS_eFin_Deploy</ConnectString>
</ConnectionProperties>
<rd:SecurityType>DataBase</SecurityType>
<rd:DataSourceID>56e5e869-6ca5-44f9-8340-22821177569e</DataSourceID>
</DataSource>
我如何调整我的代码来创建正确的XML如上所述?我几乎要把它创建为文本了
XNamespace ns = @"http://www.somesite.com/xml/customer/2006-10-31";
XElement xe = new XElement(ns + "customers",
new XAttribute("xmlns", ns),
new XElement(ns + "customer", new XElement(ns + "firstname", customer.FirstName);