Entity Frame work Oracle and Sql server-how to build a database from Model

Question

Hi ,

I m trying to build a data access layer for using both Sql Server and Oracle(not at the same time). I used Model-first approach for creating the entities and then generate Databse from it.

I came to know from different blogs that oracle and Sql Server generation workflow and DDL generation template are different. Right now my application is supporting for Sql Server, I need to support it for Oracle too.

http://www.oracle.com/technetwork/issue-archive/2011/11-sep/o51odt-453447.html  i m unable to get the Oracle DDl generation template and workflow.

i have downloaded some third party tool to do so from http://www.devart.com/dotconnect/oracle/download.html but still unable to see the DDL generation template and workflow template.

please Let me know,if i missed some thing and  what are the changes I need to follow and exact procedure that is reuqired to support Oracle.

Thanks,

---

Ilyas

Answer 1

Hi Ilyasuddin,

Welcome to MSDN Forum.

Based on the issue, I suggest you to post the question in Oracle Forum. I think there are more specialists about Oracle there can help you with the Oracle DDL generation template and workflow. I hope the issue can be resolved soon.

Best Regards

---

Allen Li [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Thanks Allien for the info.

---

Ilyas