I'm trying to rebuild an old ASP site to .NET 4.0. I'm in the process of figure out what to use.
Background:
- There is data in an existing DB2 (old iSeries IBM DB2) need to be used
- There will be some new design SQL DB need to be used also.
- Need to use MVC 3.0 for client side.
My plan of high level architect is MVC client side -> REST WCF Service -> Business Logic Layer (BLL) -> Data Access Layer (DAL) -> SQL and DB2 database
I have try MVC 3.0 with Entity Framework 4.0 which skipping REST service, BLL, DAL for simple taste, it works fine. However, when I try to fit it into the model, I always get the Entity Framework error and not able to get the EF works well with REST Service. Since it involves more than 1 DB (SQL & DB2), I don't know if Entity Framework fits into the model.
Does anyone have any suggestion on what model should I use and what is the best approach? Any suggestion or direction is greatly appreciated.
Thanks,
Vince