title: Entity Framework with npgsql won't accept money datatype
body: <p>I'm creating a .NET C# app using Entity Framework 5 and PostgreSQL DB. I'm using <a href="http://npgsql.projects.pgfoundry.org/" rel="nofollow">npgsql</a> 2.0.12 as Data Provider and Database First approach.</p>
  
  <p>First, I created model files (csdl, ssdl, mdl) and object layer using <a href="http://msdn.microsoft.com/en-us/library/bb387165.aspx" rel="nofollow">edmgen</a> with connection string to the postgresql db as parameter. </p>
  
  <p>The edmgen shows a warning when doing it's job:</p>
  
  <blockquote>
    <p>warning 6005: The data type 'money' is not supported, the column 'amount' in table 'tablename' was excluded.</p>
  </blockquote>
  
  <p>Then it all works fine, just that column is not included in the model.
  Of course, I'm not happy with that, since I need this column.
  I should not modify DB structure.</p>
  
  <p>So, what I did is I modified the model files manually - CSDL, SSDL, MDL respectively:</p>
  
  <blockquote>
  <pre><code>&lt;Property Name="amount" Type="Decimal" Nullable="false" Precision="19" Scale="4" /&gt;
  &lt;Property Name="amount" Type="money" Nullable="false" /&gt;
  &lt;ScalarProperty Name="amount" ColumnName="amount" /&gt;
  </code></pre>
  </blockquote>
  
  <p>I also edited the ObjectLayer by adding this attribute, just like any others in this table.</p>
  
  <p><strong>Now when I run the app I get:</strong></p>
  
  <blockquote>
    <p>Schema specified is not valid. Errors:  The Type money is not qualified with a namespace or alias. Only primitive types can be used without qualification.</p>
  </blockquote>
  
  <p>Whose fault is that? EF? npgsql? edmgen?</p>
  
  <p>I found something on <a href="http://pgfoundry.org/forum/forum.php?thread_id=1871&amp;forum_id=519" rel="nofollow">pgfoundry.org/forum</a>, but changing to numeric doesn't help me.
  <a href="http://npgsql.projects.pgfoundry.org/docs/manual/UserManual.html" rel="nofollow">User Manual</a> of npgsql indicates that money is a supported type.</p>
  
  <p><strong>How can I make this thing work with money-typed column?</strong></p>