Need XPath help

[Richard]

Hi,

I am trying to use an XmlDocument object to manipulate the default database
instance node of the enterprise template library dataConfiguration section
from a custom installer step:

<?xml version="1.0" encoding="utf-8"?>
<dataConfiguration>
<xmlSerializerSection
type="Microsoft.Practices.EnterpriseLibrary.Data.C onfiguration.DatabaseSettings,
Microsoft.Practices.EnterpriseLibrary.Data, Version=1.1.0.0, Culture=neutral,
PublicKeyToken=null">
<enterpriseLibrary.databaseSettings
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
defaultInstance="AdessoOdbc"
xmlns="http://www.microsoft.com/practices/enterpriselibrary/08-31-2004/data">
<databaseTypes>

I have tried several XPath queries but I am not having any luck fetching the
"defaultInstance" attribute - xpath seems to be unhappy about the '.' in the
"enterpriseLibrary.databaseSettings" node name. For example this code:

XmlNode node =
xml.SelectSingleNode("dataConfiguration/xmlSerializerSection/enterpriseLibrary.databaseSettings");

does NOT return "enterpriseLibrary.databaseSettings" node - it returns null.
Any ideas on how I can get to the defaultInstance attribute?

[Wiebe Tijsma]

Richard wrote:

Hi,

I am trying to use an XmlDocument object to manipulate the default database
instance node of the enterprise template library dataConfiguration section
from a custom installer step:

<?xml version="1.0" encoding="utf-8"?>
<dataConfiguration>
<xmlSerializerSection
type="Microsoft.Practices.EnterpriseLibrary.Data.C onfiguration.DatabaseSettings,
Microsoft.Practices.EnterpriseLibrary.Data, Version=1.1.0.0, Culture=neutral,
PublicKeyToken=null">
<enterpriseLibrary.databaseSettings
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
defaultInstance="AdessoOdbc"
xmlns="http://www.microsoft.com/practices/enterpriselibrary/08-31-2004/data">
<databaseTypes>

I have tried several XPath queries but I am not having any luck fetching the
"defaultInstance" attribute - xpath seems to be unhappy about the '.' in the
"enterpriseLibrary.databaseSettings" node name. For example this code:

XmlNode node =
xml.SelectSingleNode("dataConfiguration/xmlSerializerSection/enterpriseLibrary.databaseSettings");

does NOT return "enterpriseLibrary.databaseSettings" node - it returns null.
Any ideas on how I can get to the defaultInstance attribute?

Hi,

It's not the dot.

The enterpriseLibrary.databaseSettings is in a different namespace,
declared by the
xmlns="http://www.microsoft.com/practices/enterpriselibrary/08-31-2004/data"
attribute.

You have to use a nametable/namespacemanager to assign a prefix for this
namespace, after that you can use xpath queries it like this:

XmlNode node =
xml.SelectSingleNode("dataConfiguration/xmlSerializerSection/myprefix:enterpriseLibrary.databaseSettings");

If you need help with the C# part, let me know...

Luck, Wiebe

[Abubakar]

Hi,
Will this be the right way to do this? :

XmlTextReader xreader = new XmlTextReader( xmlfilename );
XmlNamespaceManager nsm = new XmlNamespaceManager(xreader.NameTable );
nsm.AddNamespace("abc",
"http://www.microsoft.com/practices/enterpriselibrary/08-31-2004/data");
XmlNode node =
doc.DocumentElement.SelectSingleNode("xmlSerialize rSection/abc:enterpriseLib
rary.databaseSettings", nsm);

and than you can write:

node.Attributes.GetNamedItem("defaultInstance").Va lue

to get the value.

Ab.
http://joehacker.blogspot.com

"Wiebe Tijsma" <wi*********@CAPITALStijsma.com> wrote in message
news:#4*************@tk2msftngp13.phx.gbl...

Richard wrote:

Hi,

I am trying to use an XmlDocument object to manipulate the default database instance node of the enterprise template library dataConfiguration section from a custom installer step:

<?xml version="1.0" encoding="utf-8"?>
<dataConfiguration>
<xmlSerializerSection
type="Microsoft.Practices.EnterpriseLibrary.Data.C onfiguration.DatabaseSetti
ngs, Microsoft.Practices.EnterpriseLibrary.Data, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null">
<enterpriseLibrary.databaseSettings
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
defaultInstance="AdessoOdbc"
xmlns="http://www.microsoft.com/practices/enterpriselibrary/08-31-2004/data"

<databaseTypes>

I have tried several XPath queries but I am not having any luck fetching

the "defaultInstance" attribute - xpath seems to be unhappy about the '.' in the "enterpriseLibrary.databaseSettings" node name. For example this code:

XmlNode node =
xml.SelectSingleNode("dataConfiguration/xmlSerializerSection/enterpriseLibra
ry.databaseSettings");
does NOT return "enterpriseLibrary.databaseSettings" node - it returns null. Any ideas on how I can get to the defaultInstance attribute?

Hi,

It's not the dot.

The enterpriseLibrary.databaseSettings is in a different namespace,
declared by the

xmlns="http://www.microsoft.com/practices/enterpriselibrary/08-31-2004/data" attribute.

You have to use a nametable/namespacemanager to assign a prefix for this
namespace, after that you can use xpath queries it like this:

XmlNode node =
xml.SelectSingleNode("dataConfiguration/xmlSerializerSection/myprefix:enterp
riseLibrary.databaseSettings");
If you need help with the C# part, let me know...

Luck, Wiebe