Microsoft Visual C# 2010 Express with ADO.Net Entitity data model conecting to SQL Server

Microsoft Visual C# 2010 Express has restricted functionality for connecting to SQL Server databases not allowing connection to a running SQL Server.

Microsoft Visual Web Developer 2010 Express does have this functionality enabled, so a work around can be creating an ADO.Net Entity Data Model in Microsoft Visual Web Developer 2010 Express, compiling and then adding the dll as a reference in your Microsoft Visual C# 2010 Express project.