The underlying provider failed on Open.

See more:

C#

C#4.0

entity-framework

Hi Guys

So far I think I have tried every trick on the net.

I got this error this weekend "The underlying provider failed on Open." when trying to access EntityFramework in my local machine.

This is my connection string that was created automaticaly when creating EF

<add name="dbPropertyManagerEntities" connectionString="metadata=res://*/PropSoftModel.csdl|res://*/PropSoftModel.ssdl|res://*/PropSoftModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=.\SQLEXPRESS;attachdbfilename=|DataDirectory|\dbPropertyManager.mdf;integrated security=True;connect timeout=30;user instance=True;multipleactiveresultsets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

Now this is my code to access the EF

using (var context = new dbPropertyManagerEntities())
           {
               var query = from row in context.tbl_Property
                           select row;

               if (!string.IsNullOrEmpty(searchTerm))
               {
                   query = query.Where(row => row.propName.Contains(searchTerm) || row.propAddress.Contains(searchTerm));
               }
               query = query.OrderBy(s => s.propName);

               var qRowCount = query.Count();//Error is here
               var qRow = query.Skip(skip).Take(take);

               rowCount = qRowCount;

               return qRow.ToList();
           }