I started a new project recently. OpenAccess Q2 2010 build 714 is used.
The database schema is empty. The tables will be 100+. The initial application version will use SQL Server Express (e.g. 2008R2). Later versions may support Oracle XE.
Do you suggest the new Domain Model or the traditional 'ORM-Enable' way?
- if Domain Model: I hope to create tables visually in the domain model (entity diagram), and then forward mapping to the database schema.
- if ORM-Enble: I may create tables using SQL Server Management Studio, and then reverse mapping to OpenAccess.
The DTO template seems to work with Domain Model only. Can I gain DTO-similar capabilities from the traditional 'ORM-Enable' way?
Any suggestions will be very useful . Thanks!