.NET types and Oracle types

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
object
Posts: 89
Joined: Tue 26 Oct 2010 08:29

.NET types and Oracle types

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
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

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
Posts: 89
Joined: Tue 26 Oct 2010 08:29

Post by object » Thu 11 Nov 2010 16:41

Worked like a charm, thanks!

Post Reply