MVC + EF DB-First Unit Testing

Question

I am wondering whether Unit Testing is possible if I use a DB-First Entity Framework model -- or shall I rather do Integrity Tests only? Can I detach the system from the DB while testing?

I already have a context factory to have maximum one context per request. I could make the factory return an interface which could be instanciated as a wrapper of the EF context OR a fake testing implementation. So I would have to manually wrap the tables and stored functions of the generated EF context (including each changes), because it is not implementing anything... Man, that would be pain in everything and surely wouldn't worth it.

So what are your recommendations about Unit (or not Unit) Testing in this environment?

Update: I'm using EF 5

MaxSC · Accepted Answer · 2013-07-30 12:27:03Z

3

You should take a look at this article where Julie Lerman answers to a similar question someone asked her on twitter. It will give you an overview of all the available testing techniques around EF.
Have a look at the article's comments as well where other interesting things are mentioned.

answered Jul 30, 2013 at 12:27

MaxSC

4,7982 gold badges27 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Gábor Imre Over a year ago

Thanks, I found lots of useful stuff here (and on blogs around this one) but not a direct solution for my question yet. (There is a very nice guide for EF4 though.)

SwampyFox Over a year ago

The article has moved to here

dlebech · Accepted Answer · 2013-07-30 10:19:31Z

0

Take a look at The Repository Pattern.

answered Jul 30, 2013 at 10:19

dlebech

1,83914 silver badges29 bronze badges

Collectives™ on Stack Overflow

MVC + EF DB-First Unit Testing

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related