title: receiving everyday XML files - 12 types need to do search on these everyday
body: <p>Asp.NET - C#.NET</p>
  
  <p>I need a advice regarding a design problem below:</p>
  
  <p>I'll receive everyday XML files. It changes the quantity e.g. yesterday 10 XML files received, today XML 56 files received and maybe tomorrow 161 XML files etc.</p>
  
  <p>There are 12 types (12 XSD)... and in the top there is a attribute called FormType e.g. FormType="1", FormType="2" , FormType="12" etc. up to 12 formtypes.</p>
  
  <p>All of them have common fields like Name, adres, Phone.
  But e.g. FormType=1 is for Construction, FormType=2 is for IT, FormType 3=Hospital, Formtype=4 is for Advertisement etc. etc. </p>
  
  <p>As I said all of them have common attributes.</p>
  
  <p><strong>Requirements:</strong>
  Need a search screen so the user can do search on these XML contents. But I don't have any clue how to approach this. e.g. Search the text in some attributes for the xml's received from Date_From and Date_To.</p>
  
  <p><strong>Problem:</strong>
  I've heard about putting the XML's in a Binary field and do XPATH query or whatever but don't know the word's to search on google.</p>
  
  <p>I was thinking to create a big database.table and read all XML's and put in the Database Table. But the issue is some xml attributes are very huge like 2-3 pages. and the same attributes in other XML file are empty.. 
  So creating NVARCHAR(MAX)  for every XML attribute and putting them in table.field.... After some period my DATABASE will be a big big monster... </p>
  
  <p>Can someone advice what is the best approach to handle this issue?</p>