SqlXmlException - Schema: relationship expected on <element name>. Help!

[Json]

Ok, brand new to SQLXML 3.0 and its various issues. Heres what I'm
trying to do:

1. I am trying to load xml data into an empty SQL table from my .NET
console application.
2. This isn't a huge amount of data so I'm not interested in
BulkXMLLoad (or whatever its called).
3. I have the xml and xml schema ready to go, with (I hope) the proper
sql annotations.

Heres my xml schema (built via xsd tool with added sql annotations):

<?xml version="1.0" encoding="utf-8"?>
<xs:schema elementFormDefa ult="qualified"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:sql="urn: schemas-micrsooft-com:mapping-schema">
<xs:element name="Visitors" nillable="true" type="VisitorLi st"
sql:is-constant="1" />
<xs:complexTy pe name="VisitorLi st">
<xs:sequence>
<xs:element minOccurs="0" maxOccurs="unbo unded" name="Visitor"
type="VisitorIn fo" sql:relation="L iveMeetingAtten deesBMO1" />
</xs:sequence>
<xs:attribute name="Count" type="xs:int" use="required"
sql:mapped="fal se" />
</xs:complexType>
<xs:complexTy pe name="VisitorIn fo">
<xs:sequence>
<xs:element minOccurs="0" maxOccurs="1" name="ID"
type="xs:string " sql:mapped="fal se" />
<xs:element minOccurs="0" maxOccurs="1" name="userName"
type="xs:string " sql:field="Name " />
<xs:element minOccurs="0" maxOccurs="1" name="Role"
type="xs:string " />
<xs:element minOccurs="0" maxOccurs="1" name="email"
type="xs:string " />
<xs:element minOccurs="0" maxOccurs="1" name="company"
type="xs:string " />
<xs:element minOccurs="0" maxOccurs="1" name="ipAddress "
type="xs:string " sql:field="[IP Address]" />
<xs:element minOccurs="0" maxOccurs="1" name="browser"
type="xs:string " />
<xs:element minOccurs="0" maxOccurs="1" name="meetingNa me"
type="xs:string " sql:field="[Meeting ID]" />
<xs:element minOccurs="1" maxOccurs="1" name="duration"
type="xs:int" />
<xs:element minOccurs="1" maxOccurs="1" name="meetingTi me"
type="xs:dateTi me" sql:field="[Activity Day and Time]" />
<xs:element minOccurs="1" maxOccurs="1" name="startTime "
type="xs:dateTi me" sql:field="Arri ved" />
</xs:sequence>
</xs:complexType>
</xs:schema>

As you can see, one Visitor record should apply to one record in the
backend SQL table, named LiveMeetingAtte ndeesBMO1.

Heres my code to post to the database:

public void PostToDatabase( ConferenceType confType, MeetingInfo
Meeting)
{
SqlXmlCommand cmd = new SqlXmlCommand(C onfiguration.Co nnectionString) ;
cmd.RootTag = "ROOT";
cmd.CommandType = SqlXmlCommandTy pe.XPath;
cmd.CommandText = "LiveMeetingAtt endeesBM01";
cmd.SchemaPath = "../../XML/VisitorList_Eve nts.xsd";

DataSet dataset = new DataSet();
SqlXmlAdapter adapter = new SqlXmlAdapter(c md);
adapter.Fill(da taset); //-- ERROR HITS HERE

//this serializes class into XML according to schema above.
XmlTextReader reader = ConvertToXML();

//now load dataset with new records and update database!
dataset.ReadXml (reader, XmlReadMode.Aut o);
adapter.Update( dataset);
}

The "adapter.Fill(d ataset)" line causes the error - SqlXmlException :
Schema: relationship expected on 'Visitor'.

I'm not sure why this is appearing... there is no join here, so I don't
need a relationship right? I also map my Visitor elements to records in
the LiveMeetingAtte ndeesBMO1 table via the "sql:relati on" attribute.

Has anyone seen anything like this?

NOTE: The sql:is-constant='1' attribute in the schema - the results are
the same with or without it.

Thanks for the help!! :)

J'son

[Json]

Some clarity after banging my head on my desk:

I think that since my initial table in the SQL database is empty, the
fill code is unnecessary. Also, in reading some more I figured out that
the CommandText refers to the XSD file of the SqlXmlCommand when using
CommandType = XPath (duh!). So here is the updated PostToDatabase( )
function:

public void PostToDatabase( ConferenceType confType, MeetingInfo
Meeting)
{
SqlXmlCommand cmd = new
SqlXmlCommand(C onfiguration.Co nnectionString) ;
cmd.CommandText = "Visitor";
cmd.CommandType = SqlXmlCommandTy pe.XPath;
cmd.SchemaPath = "../../XML/VisitorList_Eve nts.xsd";

DataSet dataset = new DataSet();
SqlXmlAdapter adapter = new SqlXmlAdapter(c md);

//this serializes class into XML according to schema above.
XmlTextReader reader = ConvertToXML();

dataset.ReadXml Schema(cmd.Sche maPath);
dataset.ReadXml (reader, XmlReadMode.Rea dSchema);
dataset = dataset.GetChan ges(DataRowStat e.Added);

adapter.Update( dataset); //-- ERROR NOW HAPPENS
HERE (SAME ERROR)
}

Same error occurs, just now on the adapter.Update method so its still
an issue with my schema.

Thanx!

Sincerely,

J'son

[Json]

Figured it out... check out my urn for the xmlns:sql namespace in the
schema - micrsooft! Arrrggh... :P

J'son