Hello all,

I am about to undertake my first Enterprise sized application. I have worked a lot on smaller Client server type apps but I am going for mount everest here and would like Suggestions on architecture ideas.

Here the scenario, I am building a Windows UI that in live mode will connect to a SQL server but in Demo Mode will connect to an Access database. There are rumors that Other backend Platforms will be added in the future.


So here is what I Assume:

1. The UI has to ask a class for the data

2. The Middle class Finds out what the backend database is.

3. The middle class calls a 2nd class to reach the correct datasource.


Am I correct in these assumptions?

if so what is next?

if not , what would you suggest?


thanks in advanced

tal