XML / XSL

//   C#, in global.asax code-behind file
protected void   Application_Start(Object sender, EventArgs e)
{
   //   load the xml file into the app state
   DataSet   ds = new DataSet();

   ds.Load(Server.MapPath("./db.xml"));   //   map URL to local file

   Application.Contents.Add("db") = ds;   //   store in HTTP app state
}

DataSet   ds = (DataSet)Application.Contents["db"];

---

"When the only tool you have is a hammer, a sore thumb you will have."

//   C# -- one way to load the Xml...
XmlDocument   doc = new XmlDocument();
doc.LoadXml([doc string here]);   //   or you can use doc.Load([path to doc file]);  (See <a href="http://msdn.microsoft.com/library/en-us/cpref/html/frlrfSystemXmlXmlDocumentClassLoadTopic.asp?frame=true" target="_blank">XmlDocument.Load</a>)
XmlNode   outerListNode = doc.SelectSingleNode("descendant::OuterList[@id='124']");   //   this next line selects the node you're interested in

<drive dev="/dev/hda1">
   <folder name="bin"/>
   <folder name="usr">
      <folder name="bin"/>
      <folder name="sbin"/>
      <folder name="src"/>
         <folder name="darwin" link="true"/>
         <folder name="include"/>
         <folder name="linux" link="true"/>
      </folder>
   </folder>
   <folder name="sbin"/>
</drive>

//   excuse the C#
string   tmpFilePath = Path.GetTempFileName();

try
{
   TextReader rdr = new StreamReader(Assembly.GetExecutingAssembly().GetManifestResourceStream("MyDataAccess.MySchemaFile.xsd");
   TextWriter wr = new StreamWriter(tmpFilePath, false);

   wr.WriteLine(rdr.ReadToEnd());

   wr.Close();
   rdr.Close();

   //   now tmpFilePath can be used in your SqlXmlCommand.SchemaPath until done, e.g.,
   //   cmd.SchemaPath = tmpFilePath;
}
catch (Exception e)
{
   //   handle the exception
}
finally
{
   //  get rid of that temp file!
   if (File.Exists(tmpFilePath))   File.Delete(tmpFilePath);
}