Upper case database object names

Upper case database object names

Postby matt.downing » Wed 02 Feb 2011 17:46

Hi,
I've just started working with Oracle (via EF using Devart's dotConnet) and discovered that Oracle prefers uppercase db objects.
Further, we have a 3rd-party database tool for Oracle that only expects/allows uppercase names.

But I've been unable to find how I can get the Devart Oracle provider for EF to alter the EDM/generated DDL so uppercase db entities are created from camel case code entities.

How can I perform this?
Thanks,
Matt
matt.downing
 
Posts: 4
Joined: Wed 02 Feb 2011 17:32

Postby AndreyR » Thu 03 Feb 2011 12:52

I recommend you to use Devart Entity Model.
It has the same functionality as the Microsoft one, but has a better designer and a more flexible code generation.
You can set the Upper case for both generated classes and properties on the Naming Rules page while adding a new Devart Entity model to your project.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby matt.downing » Thu 03 Feb 2011 17:44

Thanks, that's great. I wasn't aware of that component.
Matt
matt.downing
 
Posts: 4
Joined: Wed 02 Feb 2011 17:32


Return to dotConnect for Oracle