What model to use? Entity FW, MVC 3, REST Service, SQL and DB2

Question

3.00/5 (2 votes)

See more:

VS2010

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

Posted 7-Mar-12 8:27am

Vince Y

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Shahin Khorshidnia · Answer 1 · 2012-03-07T12:57:00

Solution 1

Hello

Maybe it helps:

Architecture Guide: ASP.NET MVC Framework + N-tier + Entity Framework and Many More[^]

Posted 7-Mar-12 12:57pm

Shahin Khorshidnia

Comments

Vince Y 15-Mar-12 10:32am

Thank you Shahin. It is a very useful article. However, I still have some undecided questions in my mind. How do I fit into the model with REST Service? Also, with Entity Framework, would it be a lot of hassle maintaining the DB model match between DAL and SQL end all time? I used to experience the mismatch DB structure when I made change in the code first approach. So, making change on DB after deployment can be a big problem with Entity Framework, am I correct?

Thanks,
Vince