How to deal with "The underlying provider failed on Open" in Entity Framework

Please use using statement to include your access to Object Context:

            using (var ctx = new Entities())
            {
                ....
            }

Provides a convenient syntax that ensures the correct use of IDisposable objects.