asp.net – SqlException(0x80131904):第28行:'(‘.)附近
发布时间:2020-12-15 23:48:59 所属栏目:asp.Net 来源:网络整理
导读:请有人帮我! 我有一个应用程序运行在Windows 2003与sql server 2005.当我尝试部署这一些应用程序在其他服务器在windows 2003与sql server 2000,应用程序的一些页面显示消息如下: Server Error in '/' Application.Line 1: Incorrect syntax near '('. Desc
请有人帮我!
我有一个应用程序运行在Windows 2003与sql server 2005.当我尝试部署这一些应用程序在其他服务器在windows 2003与sql server 2000,应用程序的一些页面显示消息如下: Server Error in '/' Application. Line 1: Incorrect syntax near '('. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near '('. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SqlException (0x80131904): Line 1: Incorrect syntax near '('.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception,Boolean breakConnection) +1948826 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,Boolean breakConnection) +4844747 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,SqlCommand cmdHandler,SqlDataReader dataStream,BulkCopySimpleResultSet bulkCopyHandler,TdsParserStateObject stateObj) +2392 System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33 System.Data.SqlClient.SqlDataReader.get_MetaData() +83 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,RunBehavior runBehavior,String resetOptionsString) +297 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior,Boolean returnStream,Boolean async) +954 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,String method,DbAsyncResult result) +162 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,String method) +32 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior,String method) +141 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12 System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10 System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand,CommandBehavior behavior) +383 [EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details.] System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand,CommandBehavior behavior) +422 System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute(ObjectContext context,ObjectParameterCollection parameterValues) +745 System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) +162 System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() +45 System.Linq.Enumerable.FirstOrDefault(IEnumerable`1 source) +203 System.Data.Objects.ELinq.ObjectQueryProvider.<GetElementFunction>b__1(IEnumerable`1 sequence) +40 System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle(IEnumerable`1 query,Expression queryRoot) +60 System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute(Expression expression) +109 System.Linq.Queryable.FirstOrDefault(IQueryable`1 source) +269 SebraeFE.Models.Repositories.InterestsRepository.DeleteInterests(Interests interestsToDelete) +418 SebraeFE.Models.Managers.InterestsManager.DeleteInterests(Interests interestsToDelete) +41 SebraeFE.Models.Facades.InterestsFacade.DeleteInterests(Interests interestsToDelete) +41 SebraeFE.Controllers.OportunidadeController.ApagarInteresse(Int32 Id) +265 lambda_method(ExecutionScope,ControllerBase,Object[] ) +78 System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller,Object[] parameters) +17 System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext,IDictionary`2 parameters) +178 System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext,ActionDescriptor actionDescriptor,IDictionary`2 parameters) +24 System.Web.Mvc.<>c__DisplayClassa.<InvokeActionMethodWithFilters>b__7() +53 System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter,ActionExecutingContext preContext,Func`1 continuation) +258 System.Web.Mvc.<>c__DisplayClassc.<InvokeActionMethodWithFilters>b__9() +20 System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter,Func`1 continuation) +258 System.Web.Mvc.<>c__DisplayClassc.<InvokeActionMethodWithFilters>b__9() +20 System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext,IList`1 filters,IDictionary`2 parameters) +193 System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext,String actionName) +382 System.Web.Mvc.Controller.ExecuteCore() +123 System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) +23 System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext) +7 System.Web.Mvc.MvcHandler.ProcessRequest(HttpContextBase httpContext) +144 System.Web.Mvc.MvcHandler.ProcessRequest(HttpContext httpContext) +54 System.Web.Mvc.MvcHandler.System.Web.IHttpHandler.ProcessRequest(HttpContext httpContext) +7 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +406 System.Web.HttpApplication.ExecuteStep(IExecutionStep step,Boolean& completedSynchronously) +76 Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053 一个令人震惊的技术: > asp.net mvc 1 请帮帮我! 解决方法
用xml编辑器打开你的模型.edmx,并修改它
ProviderManifestToken="2008" 至 ProviderManifestToken="2000" 它可能是linq .first()生成sql2005中工作的sql脚本“Top(1)”,但在sql 2000中应该是”””””’1′ 它在我的解决方案中起作用. (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |
相关内容
- asp.net-mvc – Html.BeginForm的默认区域是否始终是ASP.NE
- asp.net-mvc – Asp.Net Mvc 2 Checkbox在模型中总是假的
- 如何将TextBox双向绑定到ASP.NET中的代码隐藏属性?
- asp.net-mvc-3 – Action在提交时执行两次
- asp.net-mvc – 我如何moq aingleingleResult?我是不是该?
- asp.net-mvc-3 – 如何使用DropdownList助手正确创建MultiS
- asp.net-mvc – 使用MVC Futures的异步控制器在.NET 3.5 SP
- asp.net-mvc-2 – Asp.net Mvc显示String的模板,但现在每个
- asp.net-mvc – @ Html.BeginForm()如何工作?
- asp.net-mvc-3 – 如何添加整数列表到路由
推荐文章
站长推荐
- asp.net-mvc – 如何从视图中检索传递给我的自定
- 在asp.net web.config中,如何配置httphandlers?
- asp.net – 使用asp .net TextBox的iPhone电子邮
- asp.net core在linux上的部署调试
- 将ASP.NET Web API 2中值类型(C#)的.MinValue序列
- asp.net-mvc – 使用nHibernate.validator的MVC.
- asp.net – 从SignalR Hub调用方法的问题.调用失
- asp.net – 在更新面板中自动上传文件到服务器第
- asp.net-mvc – ASP.NET MVC如何链接视图和控制器
- asp.net-core – 我需要在ASP.NET Core for Cach
热点阅读