Why, why, why I hear you say would you want to use Datasets with the Entity Framework?
I’m not here to debate the whys and wherefores for doing this, just finding a simple solution to the problem.
Entity Framework is always a pain the back side when it comes to managing multiple database and know what to do if things get out of sync, an article by Anders Abel clearly lays out what need to be done and what can be used to sort out any sync problems, here is a snip from his article:
I’m not often shocked, but when I found out that Entity Framework was not thread safe, I was horrified. I even had to buy a fellow college dinner as I lost a bet.
Now that I knew what the problem was how can it be resolved?
If you are like me, some customer just can’t upgrade from SQL 2000, so how do you use the EntityFramework 4.0+ with SQL Server 2000?
Here is one solution that has worked for me:
Here are the steps to add a new Entity Framework 4.0+ entity context to a Visual Studio 2010 project: