public class CustomerStoredProcedures : StoredProcFacade
{
    public DataSet GetCustomersByName(string Name)
    {
        XmlDocument customerXml = new XmlDocument();
        customerXml.Load("Customers.xml");
        string searchExpression;
        if (Name.EndsWith("%"))
        {
            searchExpression = 
                "NewDataSet/Customers[starts-with(CompanyName,'" 
                +Name.Replace("%","")+"')]";
        }
        else
        {
            searchExpression = 
                "NewDataSet/Customers[CompanyName = '"
                +Name.Replace("%","")+"']";
        }
        XmlNodeList customersToReturn = 
            customerXml.SelectNodes(searchExpression);
        XmlDocument resultXml = new XmlDocument();
        StringBuilder sb = new StringBuilder();
        sb.Append("<?xml version=\"1.0\"?><NewDataSet>");
        foreach(XmlNode customer in customersToReturn)
        {
            sb.Append("<Customers>"+
                customer.InnerXml+"</Customers>");
        }
        sb.Append("</NewDataSet>");
        DataSet dsResult = new DataSet();
        dsResult.ReadXml(
            new System.IO.StringReader(sb.ToString()));
        return dsResult;
    }
}