Upper case database object names

matt.downing · Post by **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

AndreyR · Post by **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.

matt.downing · Post by **matt.downing** » Thu 03 Feb 2011 17:44

Thanks, that's great. I wasn't aware of that component.
Matt