Help using dotConnect for the first time
Posted: Mon 16 Jul 2012 18:26
Hi,
I have just bought dotConnect for Oracle developer and have been playing around trying to connect to our Oracle database. So far I haven't really got very far and don't know the best method for trying to do this.
My application so far is built with asp.net MVC 4, entity framework 4.3 and a code first approach. The models have been abstracted with UnitOfWork and a generic Repository pattern and I am also using an IAuditable pattern and Business logic layer.
I am now at the stage where I need to consume data from our Oracle database that will be used for reference data, no data will be modified on the Oracle database, all changes will go in the applications SQL tables.
I want to keep using the same approach as described above for both my SQL and Oracle tables and I really like the code-centric/ abstracted methods provided by code first and the patterns I have used.
Please can you tell me the best way to achieve this, I haven't figured out which wizard to use to do this and my attempts so far have failed. Also how can I do this but ensure the Oracle tables are not modified in any way and are only used on a read only basis. I do not want to audit the reading of these tables as they will only be used for reference data.
Also can you provide an example of how I can use an Oracle table to create a linked table with my own custom columns added on with data from SQL tales?
Many thanks,
Andy
PS I am a beginner to ASP.net, MVC and dotConnect so please can you assume no prior knowledge.
I have just bought dotConnect for Oracle developer and have been playing around trying to connect to our Oracle database. So far I haven't really got very far and don't know the best method for trying to do this.
My application so far is built with asp.net MVC 4, entity framework 4.3 and a code first approach. The models have been abstracted with UnitOfWork and a generic Repository pattern and I am also using an IAuditable pattern and Business logic layer.
I am now at the stage where I need to consume data from our Oracle database that will be used for reference data, no data will be modified on the Oracle database, all changes will go in the applications SQL tables.
I want to keep using the same approach as described above for both my SQL and Oracle tables and I really like the code-centric/ abstracted methods provided by code first and the patterns I have used.
Please can you tell me the best way to achieve this, I haven't figured out which wizard to use to do this and my attempts so far have failed. Also how can I do this but ensure the Oracle tables are not modified in any way and are only used on a read only basis. I do not want to audit the reading of these tables as they will only be used for reference data.
Also can you provide an example of how I can use an Oracle table to create a linked table with my own custom columns added on with data from SQL tales?
Many thanks,
Andy
PS I am a beginner to ASP.net, MVC and dotConnect so please can you assume no prior knowledge.