title: Making a Fhir server using C# and SQL Server ( RDBMS )
body: <p>I am excited with Fhir's promises. I started getting my head around on this subject for last couple of days. </p>
  
  <p>We have an existing SQL Server database containing health related records. We are trying to communicate with Fhir compliant messages.</p>
  
  <ol>
  <li><p>Sending data : Based on the given specification in <a href="http://hl7.org/fhir/" rel="nofollow">http://hl7.org/fhir/</a>, and using data object model of <a href="https://www.nuget.org/packages/Hl7.Fhir.DSTU2" rel="nofollow">https://www.nuget.org/packages/Hl7.Fhir.DSTU2</a> , I can transform my relational data to Hl7.Fhir.Model data. Then , its a matter of transforming that data to either JSON / XML.</p></li>
  <li><p>Consuming data : We can have the incoming data mapped to Hl7.Fhir.Model. But , I find it difficult to map extensions ( i.e. not a direct property) with our columns. Is there any way I can do this easily?</p></li>
  <li><p>Is SQL Server not a good choice to build a Fhir server ? Do I have to consider using MongoDB / DocumentDB ?</p></li>
  </ol>