RIA Web 服务包括部署后不工作

发布于 2024-10-25 21:23:42 字数 656 浏览 1 评论 0原文

我有一个 RIA Webservices 调用，在我的开发机器上运行良好。

 var results = repositoryFactory.For<RE059>().AsQueryable()
    .Where(
        r =>
        r.Bk_Term == TerminalName &&
        (r.Ld_Unld_Act == "DH" || r.Ld_Unld_Act == "DS" || r.Ld_Unld_Act == "DR")
        && r.Bk_Term != "Domestic")
        .Include("RE059Note");
return results;

如果我删除 .include ，部署的版本工作正常。当我添加它时，SQL Profiler 不显示任何数据库调用，显然没有数据显示，我的跟踪日志显示异常，但没有消息或本机错误代码。仅 System.ServiceModel.FaultException 的异常类型。

SQL 探查器显示生产版本和开发版本使用相同的 SQL 用户。我检查了 SQL 权限，Profiler 显示的开发版本 SQL 在 SQL Mgmt Studio 中使用相应的 SQL 用户运行良好。

什么样的事情可能是错误的？

原文

I have a RIA Webservices call that works fine on my dev machine.

 var results = repositoryFactory.For<RE059>().AsQueryable()
    .Where(
        r =>
        r.Bk_Term == TerminalName &&
        (r.Ld_Unld_Act == "DH" || r.Ld_Unld_Act == "DS" || r.Ld_Unld_Act == "DR")
        && r.Bk_Term != "Domestic")
        .Include("RE059Note");
return results;

If I remove the .Include the deployed version works fine. When I add it SQL Profiler doesn't show any database call, obviously no data shows up and my trace log shows an exception but there is no Message or Native Error Code. Only an Exception Type of System.ServiceModel.FaultException.

SQL profiler shows the same SQL user is used for the production and dev version. I checked SQL rights and the SQL that Profiler shows for the dev version runs fine in SQL Mgmt Studio with the respective SQL user.

What kind of things might be wrong?

分享到QQ

分享到微博