Missing stored procedure 'HtmlPages_GetByFilter'

Mar 24, 2010 at 3:44 PM

I just tried to use this program and config to use SQL server database instead of Mock db, then there prompts error 'missing stored procedure ''HtmlPages_GetByFilter'', see below, I tried with the sql scripts inside the project folder but it seems not valid sql scripts, "System.Collections.Generic.List`1[System.String]", is this script file correct or missing?


line 113:            int pageSize = 10;
line 114:            int pageIndex = page == null ? 1 : (int)page;
line 115:            BoolResult<PagedList<T>> result = service.Get(pageIndex, pageSize);
line 116:            // pagedData.Url = "/" + typeof(T).Name + "s/index?";
line 117:            ActionResult action = View("List", result.Item);

source file: D:\Projects\MVC\iNuggets.NET\iNuggets.NET\Lib\EntityControllerBase.cs    line: 115

stack tracking:


[SqlException (0x80131904): 找不到存储过程 'HtmlPages_GetByFilter'。]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1953274
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4849707
   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() +96
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, 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() +12
   ComLib.Database.DBQuery.Query(IDBHelper dbHelper, String commandText, CommandType commandType, DbParameter[] dbParameters, IRowMapper`2 rowMapper, String[] outputParamNames) +226
   ComLib.Entities.RepositorySql`1.GetByFilter(String filter, Int32 pageNumber, Int32 pageSize) +745
   ComLib.Entities.EntityService`1.Get(Int32 pageNumber, Int32 pageSize) +160
   ComLib.Mvc.Lib.EntityControllerBase`1.Index(Nullable`1 page) in D:\Projects\MVC\iNuggets.NET\iNuggets.NET\Lib\EntityControllerBase.cs:115
   ComLib.Mvc.Controllers.HtmlPageController.Index(Nullable`1 page) in D:\Projects\MVC\iNuggets.NET\iNuggets.NET\Controllers\HtmlPageController.cs:77
   lambda_method(ExecutionScope , ControllerBase , Object[] ) +124
   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__DisplayClassd.<InvokeActionMethodWithFilters>b__a() +52
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +254
   System.Web.Mvc.<>c__DisplayClassf.<InvokeActionMethodWithFilters>b__c() +19
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +192
   System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) +314
   System.Web.Mvc.Controller.ExecuteCore() +105
   System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) +39
   System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext) +7
   System.Web.Mvc.<>c__DisplayClass8.<BeginProcessRequest>b__4() +34
   System.Web.Mvc.Async.<>c__DisplayClass1.<MakeVoidDelegate>b__0() +21
   System.Web.Mvc.Async.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _) +12
   System.Web.Mvc.Async.WrappedAsyncResult`1.End() +59
   System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +44
   System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +7
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +8678910
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155

Coordinator
Apr 4, 2010 at 2:20 PM

Hi, I have not uploaded an official beta release yet. There are 2 stored procedures that I forgot to include in the source code in svn. I'll will upload these soon.