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 dataConfigurati on section
from a custom installer step:

<?xml version="1.0" encoding="utf-8"?>
<dataConfigurat ion>
<xmlSerializerS ection
type="Microsoft .Practices.Ente rpriseLibrary.D ata.Configurati on.DatabaseSett ings,
Microsoft.Pract ices.Enterprise Library.Data, Version=1.1.0.0 , Culture=neutral ,
PublicKeyToken= null">
<enterpriseLibr ary.databaseSet tings
xmlns:xsd="http ://www.w3.org/2001/XMLSchema"
xmlns:xsi="http ://www.w3.org/2001/XMLSchema-instance"
defaultInstance ="AdessoOdbc "
xmlns="http://www.microsoft.c om/practices/enterpriselibra ry/08-31-2004/data">
<databaseType s>

I have tried several XPath queries but I am not having any luck fetching the
"defaultInstanc e" attribute - xpath seems to be unhappy about the '.' in the
"enterpriseLibr ary.databaseSet tings" node name. For example this code:

XmlNode node =
xml.SelectSingl eNode("dataConf iguration/xmlSerializerSe ction/enterpriseLibra ry.databaseSett ings");

does NOT return "enterpriseLibr ary.databaseSet tings" 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 dataConfigurati on section
from a custom installer step:

<?xml version="1.0" encoding="utf-8"?>
<dataConfigurat ion>
<xmlSerializerS ection
type="Microsoft .Practices.Ente rpriseLibrary.D ata.Configurati on.DatabaseSett ings,
Microsoft.Pract ices.Enterprise Library.Data, Version=1.1.0.0 , Culture=neutral ,
PublicKeyToken= null">
<enterpriseLibr ary.databaseSet tings
xmlns:xsd="http ://www.w3.org/2001/XMLSchema"
xmlns:xsi="http ://www.w3.org/2001/XMLSchema-instance"
defaultInstance ="AdessoOdbc "
xmlns="http://www.microsoft.c om/practices/enterpriselibra ry/08-31-2004/data">
<databaseType s>

I have tried several XPath queries but I am not having any luck fetching the
"defaultInstanc e" attribute - xpath seems to be unhappy about the '.' in the
"enterpriseLibr ary.databaseSet tings" node name. For example this code:

XmlNode node =
xml.SelectSingl eNode("dataConf iguration/xmlSerializerSe ction/enterpriseLibra ry.databaseSett ings");

does NOT return "enterpriseLibr ary.databaseSet tings" node - it returns null.
Any ideas on how I can get to the defaultInstance attribute?

Hi,

It's not the dot.

The enterpriseLibra ry.databaseSett ings is in a different namespace,
declared by the
xmlns="http://www.microsoft.c om/practices/enterpriselibra ry/08-31-2004/data"
attribute.

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

XmlNode node =
xml.SelectSingl eNode("dataConf iguration/xmlSerializerSe ction/myprefix:enterp riseLibrary.dat abaseSettings") ;

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 );
XmlNamespaceMan ager nsm = new XmlNamespaceMan ager(xreader.Na meTable );
nsm.AddNamespac e("abc",
"http://www.microsoft.c om/practices/enterpriselibra ry/08-31-2004/data");
XmlNode node =
doc.DocumentEle ment.SelectSing leNode("xmlSeri alizerSection/abc:enterpriseL ib
rary.databaseSe ttings", nsm);

and than you can write:

node.Attributes .GetNamedItem(" defaultInstance ").Value

to get the value.

Ab.
http://joehacker.blogspot.com

"Wiebe Tijsma" <wi*********@CA PITALStijsma.co m> wrote in message
news:#4******** *****@tk2msftng p13.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 dataConfigurati on section from a custom installer step:

<?xml version="1.0" encoding="utf-8"?>
<dataConfigurat ion>
<xmlSerializerS ection
type="Microsoft .Practices.Ente rpriseLibrary.D ata.Configurati on.DatabaseSett i
ngs, Microsoft.Pract ices.Enterprise Library.Data, Version=1.1.0.0 , Culture=neutral , PublicKeyToken= null">
<enterpriseLibr ary.databaseSet tings
xmlns:xsd="http ://www.w3.org/2001/XMLSchema"
xmlns:xsi="http ://www.w3.org/2001/XMLSchema-instance"
defaultInstance ="AdessoOdbc "
xmlns="http://www.microsoft.c om/practices/enterpriselibra ry/08-31-2004/data"

<databaseType s>

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

the "defaultInstanc e" attribute - xpath seems to be unhappy about the '.' in the "enterpriseLibr ary.databaseSet tings" node name. For example this code:

XmlNode node =
xml.SelectSingl eNode("dataConf iguration/xmlSerializerSe ction/enterpriseLibra
ry.databaseSett ings");
does NOT return "enterpriseLibr ary.databaseSet tings" node - it returns null. Any ideas on how I can get to the defaultInstance attribute?

Hi,

It's not the dot.

The enterpriseLibra ry.databaseSett ings is in a different namespace,
declared by the

xmlns="http://www.microsoft.c om/practices/enterpriselibra ry/08-31-2004/data" attribute.

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

XmlNode node =
xml.SelectSingl eNode("dataConf iguration/xmlSerializerSe ction/myprefix:enterp
riseLibrary.dat abaseSettings") ;
If you need help with the C# part, let me know...

Luck, Wiebe