[Mono-list] SqlMetal to PostgreSQL

Costantino Pipero cos at beeond.net
Sun Feb 7 19:45:32 EST 2010

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.
Parameter name: dataType
  at DbLinq.Vendor.Implementation.SchemaLoader.MapDbType (System.String columnName, IDataType dataType) [0x00000] in <filename unknown>:0
  at DbLinq.Vendor.Implementation.SchemaLoader.LoadColumns (DbLinq.Schema.Dbml.D
atabase schema, DbLinq.Schema.SchemaName schemaName, IDbConnection conn, INameAl
iases nameAliases, DbLinq.Schema.NameFormat nameFormat, DbLinq.Vendor.Implementa
tion.Names names) [0x00000] in <filename unknown>:0
  at DbLinq.Vendor.Implementation.SchemaLoader.Load (System.String databaseName,
 INameAliases nameAliases, DbLinq.Schema.NameFormat nameFormat, Boolean loadStor
edProcedures, System.String contextNamespace, System.String entityNamespace) [0x
00000] in <filename unknown>:0
  at DbMetal.Generator.Implementation.Processor.ReadSchema (DbMetal.Parameters p
arameters, ISchemaLoader& schemaLoader) [0x00000] in <filename unknown>:0
  at DbMetal.Generator.Implementation.Processor.ProcessSchema (DbMetal.Parameter
s parameters) [0x00000] in <filename unknown>:0

If anyone has a workaround (possibly not implying changing that datatype), I'd appreciate. I have been trying to get this going for 2 months...
I guess I will try with MSSQL and see what happens....

Thank you 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-list/attachments/20100207/5f9d3239/attachment.html 

More information about the Mono-list mailing list