Hi, Good Day! I'm working on an ASP.NET MVC application with EF 4.3 and SA 11.0.1 2808 as my database server but got stuck on data update. Savechanges() function throw an UpdateException. I've read link EBF 2813 resolved this issue but I don't see that EBF on the sybase download page. When will it be posted? UpdateException: System.Data.UpdateException was unhandled by user code Message=An error occurred while updating the entries. See the inner exception for details. Source=System.Data.Entity StackTrace: at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache) at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at System.Data.Objects.ObjectContext.SaveChanges() at AssortmentManager.Controllers.OperationController.Edit(operation operation) in D:\projects\WEBCSHARP\AssortmentManager\AssortmentManager\Controllers\OperationController.cs:line 80 at lambda_method(Closure , ControllerBase , Object[] ) at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<invokeactionmethodwithfilters>b__12() at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) InnerException: iAnywhere.Data.SQLAnywhere.SAException Message=Column 'WINFS' not found Source=SQL Anywhere .NET Data Provider ErrorCode=-2147467259 NativeError=-143 StackTrace: at iAnywhere.Data.SQLAnywhere.SACommand.ExecuteNonQuery() at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) InnerException: |
Yes! SQL Anywhere - Express Bug Fix, Update of 11.0.1 to build 2825 is up! I'm going to try this and give everyone a heads up if this fixes the data provider bug. Tests done and indeed it's fixed. Thank you! SQL Anywhere ROCKS! now I can enjoy HTML5 ASP.NET MVC, KendoUI with the coolest RDBMS ever!!!
(19 Jul '12, 22:12)
cirxesoul
|
It is impossible to know or predict when any particular build will be posted.
However, 2808 went up in May so maybe another one will be posted soon. Anything at or above 2813 qualifies.