底层提供程序在Open上失败。 [英] The underlying provider failed on Open.

问题描述

嗨大家好



到目前为止，我想我已经尝试过网上的每一招。



本周末我遇到了这个错误基础提供商在Open上失败了。当我尝试在我的本地机器上访问EntityFramework时。



这是我创建EF时自动创建的连接字符串

 <   add     name   =  dbPropertyManagerEntities     connectionString   = < span class =code-keyword> 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   = 系统。 Data.EntityClient    /  >  

现在这是我访问EF的代码

 使用（ var  context =  new  dbPropertyManagerEntities（））
 {
  var  query = 来自 row  in  context.tbl_Property 
  select 行; 
 
  if （！string.IsNullOrEmpty（searchTerm））
 {
 query = query.Where（row = < span class =code-keyword>>  row.propName.Contains（searchTerm）|| row.propAddress.Contains（searchTerm））; 
} 
 query = query.OrderBy（s = >  s.propName）; 
 
  var  qRowCount = query.Count（）;  //  错误在这里 
  var  qRow = query.Skip（skip）.Take（take）; 
 
 rowCount = qRowCount; 
 
  return  qRow.ToList（）; 
} 

解决方案

可能由于连接字符串问题而发生



只需删除模型并进行更新即可。



有时数据库中有更改make而我们不会更新模型。













Ravi Halvadiya



www.InsightSoftech.com

这里有2个解决方案



错误：实体框架应用程序中的基础提供程序在Open上失败[ ^ ]

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();
           }

解决方案

It may occurs due to connection string problem

just delete the model and take update it .

sometimes there was change make in database and we not update the model.






Ravi Halvadiya

www.InsightSoftech.com

Here 2 solutions

Error: "The underlying provider failed on Open" in Entity Framework application[^]

这篇关于底层提供程序在Open上失败。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！