Entity-framework – How to connect to SqlExpress for Entity Framework using Visual Studio 2010 Express

For those using Entity Framework 6 and up, if you want to view the output SQL in Visual Studio (like I did) you have to use the new logging/interception functionality.

Adding the following line will spit out the generated SQL (along with additional execution-related details) in the Visual Studio output panel:

using (MyDatabaseEntities context = new MyDatabaseEntities())
{
    context.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
    // query the database using EF here.
}

More information about logging in EF6 in this nifty blog series: http://blog.oneunicorn.com/2013/05/08/ef6-sql-logging-part-1-simple-logging/

Note: Make sure you are running your project in DEBUG mode.

DB2 will work, but if you want to use some of the out-of-the-box .NET features that we all take for granted (think membership and role providers), you will have quite a bit of work on your hands. DB2 doesn't really do well with Stored Procedures, so you are also looking at a lot of parameterized inline SQL.

I also had some performance issues with the provider from IBM. There is another provider available from a company called DataDirect. It looks to be more performant, but it will cost you. For something like an external facing website, where speed is important, the cost probably will not be an issue.

I am sure that DB2 is a great system if you are building on another platform, but it wasn’t really designed to play nice with .NET. Unless you are already married to DB2, I would look elsewhere.