[Mono-list] SqlMetal to PostgreSQL

Jonathan Pryor jonpryor at vt.edu
Mon Feb 8 11:03:45 EST 2010

On Sun, 2010-02-07 at 19:45 -0500, Costantino Pipero wrote:
> Having failed to use sqlmetal for MySql, I ported my data to Postgres.
> Now, this time the sqlmetal command finds the right provider, but it
> chokes on a data type with the error:
> sqlmetal failed:System.ArgumentException: Don't know how to convert
> the SQL type 'timestamp with time zone' into a managed type.

Support for this type was added in DbLinq r1300...which hasn't been
integrated with Mono svn yet.

You can manually fix this by editing 
mcs/class/System.Data.Linq/src/DbLinq/Vendor/Implementation/SchemaLoader.TypeMapping.cs and adding the following after `case "timestamp"` (around line 193):

            case "timestamp":
            case "timestamp without time zone":
            case "timestamp with time zone":

Recompile and install the new System.Data.Linq and it should work.

 - Jon

More information about the Mono-list mailing list