.NET types and Oracle types

object · Post by **object** » Thu 11 Nov 2010 10:09

I noticed that when I generate an Oracle database script from a conceptual model that was imported from a SQL server database, the script contains a few things that Oracle does not support:

1. "datetime" is not supported, should be "date" or "timestamp" in Oracle.
2. "varchar(max)" is not supported, "max" should be replaced with maximum string column size which I believe is 4000 in Oracle.
3. Oracle does not have support for boolean values, so "bit" in generated Oracle script should be mapped to char(1) or number(1).

I can probably write a custom T4 template that does it, but shouldn't this be handled by Devart EF script generator?

AndreyR · Post by **AndreyR** » Thu 11 Nov 2010 16:24

Please comment out the context connection string in the application configuration file (App.Config/Web.Config) and run the Generate Database from Model wizard again. Provide a correct connection on the first step of the wizard, and the DDL script will be generated successfully.

object · Post by **object** » Thu 11 Nov 2010 16:41

Worked like a charm, thanks!