title: BizTalk Business Rule for checking against list of values contained in .csv, xml, etc
body: <p>I'm new to BRE and fairly new to BizTalk as a whole, so this may be quite simple and just evading me...</p>
  
  <p>What I'd like to do is this: create a business rule in BRE that takes as an input the incoming message and checks to see if a value contained in message matches any of the values within a specified set of values. A sample message is as follows. The <code>&lt;isFound&gt;</code> field would then be updated accordingly.</p>
  
  <pre><code>&lt;n1:DocumentTemplate xmlns:n1="mynamespace"&gt;
      &lt;rootOid&gt;2.16.840.1.113883.3.51.60.2.5&lt;/rootOid&gt;
      &lt;isFound&gt;false&lt;/isFound&gt;
  &lt;/n1:DocumentTemplate&gt;
  </code></pre>
  
  <p>Basically I'd like to match the <code>&lt;rootOid&gt;</code> node against a list of values. I've already created a business that will match the <code>&lt;rootOid&gt;</code> against a hardcoded value in the Conditions of the business rule...just as a proof of concept to learn the basics of how to use the  BRE and call a rule in an orchestration.</p>
  
  <p>I'm failing to find a way to match against a list of values beyond doing a giant list of hard-coded ORs in the "Conditions" of the Business Rule. The list of accepted values is large enough that doing a bunch of ORs is not going to work.</p>
  
  <p>Ideally, I'd like to have a maintainable XML file full of acceptable <code>&lt;rootOid&gt;</code> values to check against from within the business rule.</p>
  
  <p>I also realize that there is a way to call a database and read the values from a table/column for matching, but I'd rather keep SQL out of the equation so that this can be a little more self-contained.</p>