Setup And Getting Started Forum


2.0 Getting error

 
An error occurred when trying to create a controller of type 'MvcCms.Web.Controllers.HomeController'. Make sure that the controller has a parameterless public constructor.

Fails here first

public IEnumerable<ContentCategory> ListAllCategories()
{
return (from c in _entities.ContentCategorySet
.Include("ParentCategory")
.Include("SubCategories")
.Include("Portal")
orderby c.ParentCategory.CategoryID, c.Importance, c.Title
select c).ToList();
}

_entities is null


Then with a refresh get the above error message.
3 months 19 days ago by wlgray

Replies

Reply posted by wlgray 3 months 19 days ago View Branch And Reply
Ok got the login working now I get this

Server Error in '/' Application.
----------------------------------------------------------------------------


MvcCmsDataModel.msl(3148,6) : error 3007: Problem in mapping fragments starting at lines 2817, 3148:Column(s) ProductID are being mapped in both fragments to different conceptual side properties.

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.MappingException:
MvcCmsDataModel.msl(3148,6) : error 3007: Problem in mapping fragments starting at lines 2817, 3148:Column(s) ProductID are being mapped in both fragments to different conceptual side properties.


Source Error:


Line 56: public IEnumerable<Portal> ListPortals()
Line 57: {
Line 58: return (from c in _entities.PortalSet
Line 59: .Include("DefaultLanguage")
Line 60: .Include("PortalResources")


Source File: C:\projects\mvccms\MvcCms 2.0\MvcCms.Data\EntityPortalRepository.cs Line: 58

Stack Trace:


[MappingException:
MvcCmsDataModel.msl(3148,6) : error 3007: Problem in mapping fragments starting at lines 2817, 3148:Column(s) ProductID are being mapped in both fragments to different conceptual side properties.
]
System.Data.Mapping.ViewDictionary.SerializedGenerateViews(EntityContainer container, Dictionary`2 resultDictionary) +7951663
System.Data.Mapping.ViewDictionary.SerializedGetGeneratedViews(EntityContainer container) +202
System.Data.Common.Utils.<>cDisplayClass2.<Evaluate>b0() +19
System.Data.Common.Utils.Result.GetValue() +100
System.Data.Common.Utils.Memoizer`2.Evaluate(TArg arg) +181
System.Data.Mapping.ViewDictionary.GetGeneratedView(EntitySetBase extent, MetadataWorkspace workspace, StorageMappingItemCollection storageMappingItemCollection) +74
System.Data.Metadata.Edm.MetadataWorkspace.GetGeneratedView(EntitySetBase extent) +67
System.Data.Query.PlanCompiler.PreProcessor.ExpandView(Node node, ScanTableOp scanTableOp, IsOfOp& typeFilter) +155
System.Data.Query.PlanCompiler.PreProcessor.ProcessScanTable(Node scanTableNode, ScanTableOp scanTableOp, IsOfOp& typeFilter) +96
System.Data.Query.PlanCompiler.PreProcessor.Visit(ScanTableOp op, Node n) +28
System.Data.Query.InternalTrees.ScanTableOp.Accept(BasicOpVisitorOfT`1 v, Node n) +16
System.Data.Query.InternalTrees.BasicOpVisitorOfT`1.VisitNode(Node n) +56
System.Data.Query.PlanCompiler.SubqueryTrackingVisitor.VisitChildren(Node n) +104
System.Data.Query.PlanCompiler.SubqueryTrackingVisitor.VisitRelOpDefault(RelOp op, Node n) +30
System.Data.Query.PlanCompiler.PreProcessor.Visit(ProjectOp op, Node n) +165
System.Data.Query.InternalTrees.ProjectOp.Accept(BasicOpVisitorOfT`1 v, Node n) +16
System.Data.Query.InternalTrees.BasicOpVisitorOfT`1.VisitNode(Node n) +56
System.Data.Query.PlanCompiler.SubqueryTrackingVisitor.VisitChildren(Node n) +104
System.Data.Query.PlanCompiler.SubqueryTrackingVisitor.VisitRelOpDefault(RelOp op, Node n) +30
System.Data.Query.PlanCompiler.PreProcessor.Visit(ProjectOp op, Node n) +165
System.Data.Query.InternalTrees.ProjectOp.Accept(BasicOpVisitorOfT`1 v, Node n) +16
System.Data.Query.InternalTrees.BasicOpVisitorOfT`1.VisitNode(Node n) +56
System.Data.Query.PlanCompiler.SubqueryTrackingVisitor.VisitChildren(Node n) +104
System.Data.Query.PlanCompiler.SubqueryTrackingVisitor.VisitRelOpDefault(RelOp op, Node n) +30
System.Data.Query.PlanCompiler.PreProcessor.Visit(ProjectOp op, Node n) +165
System.Data.Query.InternalTrees.ProjectOp.Accept(BasicOpVisitorOfT`1 v, Node n) +16
System.Data.Query.InternalTrees.BasicOpVisitorOfT`1.VisitNode(Node n) +56
System.Data.Query.PlanCompiler.SubqueryTrackingVisitor.VisitChildren(Node n) +104
System.Data.Query.PlanCompiler.SubqueryTrackingVisitor.VisitRelOpDefault(RelOp op, Node n) +30
System.Data.Query.PlanCompiler.PreProcessor.Visit(SortOp op, Node n) +36
System.Data.Query.InternalTrees.SortOp.Accept(BasicOpVisitorOfT`1 v, Node n) +16
System.Data.Query.InternalTrees.BasicOpVisitorOfT`1.VisitNode(Node n) +56
System.Data.Query.PlanCompiler.PreProcessor.Visit(ProjectOp op, Node n) +537
System.Data.Query.InternalTrees.ProjectOp.Accept(BasicOpVisitorOfT`1 v, Node n) +16
System.Data.Query.InternalTrees.BasicOpVisitorOfT`1.VisitNode(Node n) +56
System.Data.Query.PlanCompiler.SubqueryTrackingVisitor.VisitChildren(Node n) +104
System.Data.Query.InternalTrees.BasicOpVisitorOfNode.VisitDefault(Node n) +15
System.Data.Query.InternalTrees.BasicOpVisitorOfNode.VisitPhysicalOpDefault(PhysicalOp op, Node n) +13
System.Data.Query.InternalTrees.BasicOpVisitorOfT`1.Visit(PhysicalProjectOp op, Node n) +14
System.Data.Query.InternalTrees.PhysicalProjectOp.Accept(BasicOpVisitorOfT`1 v, Node n) +16
System.Data.Query.InternalTrees.BasicOpVisitorOfT`1.VisitNode(Node n) +56
System.Data.Query.PlanCompiler.PreProcessor.Process() +59
System.Data.Query.PlanCompiler.PreProcessor.Process(PlanCompiler planCompilerState, StructuredTypeInfo& typeInfo) +41
System.Data.Query.PlanCompiler.PlanCompiler.Compile(List`1& providerCommands, ColumnMap& resultColumnMap, Int32& columnCount, Set`1& entitySets) +131
System.Data.EntityClient.EntityCommandDefinition..ctor(DbProviderFactory storeProviderFactory, DbCommandTree commandTree) +343

[EntityCommandCompilationException: An error occurred while preparing the command definition. See the inner exception for details.]
System.Data.EntityClient.EntityCommandDefinition..ctor(DbProviderFactory storeProviderFactory, DbCommandTree commandTree) +1267
System.Data.EntityClient.EntityProviderServices.CreateCommandDefinition(DbProviderFactory storeProviderFactory, DbCommandTree commandTree) +97
System.Data.EntityClient.EntityProviderServices.CreateDbCommandDefinition(DbProviderManifest providerManifest, DbCommandTree commandTree) +198
System.Data.Common.DbProviderServices.CreateCommandDefinition(DbCommandTree commandTree) +147
System.Data.Objects.Internal.ObjectQueryExecutionPlan.Prepare(ObjectContext context, DbQueryCommandTree tree, Type elementType, MergeOption mergeOption, Span span, ReadOnlyCollection`1 compiledQueryParameters) +371
System.Data.Objects.ELinq.ELinqQueryState.GetExecutionPlan(Nullable`1 forMergeOption) +642
System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) +149
System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() +44
System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +315
System.Linq.Enumerable.ToList(IEnumerable`1 source) +58
MvcCms.Data.EntityPortalRepository.ListPortals() in C:\projects\mvccms\MvcCms 2.0\MvcCms.Data\EntityPortalRepository.cs:58
MvcCms.Service.Cache.CacheService.<GetCurrentPortal>b5() in C:\projects\mvccms\MvcCms 2.0\MvcCms.Service\Cache\CacheService.cs:104
MvcCms.Core.Cache.InMemoryCache.Get(String cacheId, Func`1 getItemCallback) in C:\projects\mvccms\MvcCms 2.0\MvcCms.Core\Cache\InMemoryCache.cs:16
MvcCms.Service.Cache.CacheService.GetCurrentPortal() in C:\projects\mvccms\MvcCms 2.0\MvcCms.Service\Cache\CacheService.cs:104
MvcCms.Service.CmsService..ctor(IValidationDictionary validationDictionary, ICmsRepository repository, ICacheService cacheService, IMvcCmsValidation mvcCmsValidation) in C:\projects\mvccms\MvcCms 2.0\MvcCms.Service\CMSService.cs:50
MvcCms.Service.CmsService..ctor(IValidationDictionary validationDictionary) in C:\projects\mvccms\MvcCms 2.0\MvcCms.Service\CMSService.cs:37
MvcCms.Web.Controllers.HomeController..ctor() in C:\projects\mvccms\MvcCms 2.0\MvcCms.Web\MvcCms.Web\Controllers\HomeController.cs:28

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck) +0
System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache) +98
System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean skipCheckThis, Boolean fillCache) +241
System.Activator.CreateInstance(Type type, Boolean nonPublic) +69
System.Activator.CreateInstance(Type type) +6
System.Web.Mvc.DefaultControllerFactory.GetControllerInstance(RequestContext requestContext, Type controllerType) +491

[InvalidOperationException: An error occurred when trying to create a controller of type 'MvcCms.Web.Controllers.HomeController'. Make sure that the controller has a parameterless public constructor.]
System.Web.Mvc.DefaultControllerFactory.GetControllerInstance(RequestContext requestContext, Type controllerType) +628
System.Web.Mvc.DefaultControllerFactory.CreateController(RequestContext requestContext, String controllerName) +204
System.Web.Mvc.MvcHandler.ProcessRequestInit(HttpContextBase httpContext, IController& controller, IControllerFactory& factory) +193
System.Web.Mvc.MvcHandler.ProcessRequest(HttpContextBase httpContext) +69
System.Web.Mvc.MvcHandler.ProcessRequest(HttpContext httpContext) +74
System.Web.Mvc.MvcHandler.System.Web.IHttpHandler.ProcessRequest(HttpContext httpContext) +39
System.Web.Mvc.MvcHttpHandler.VerifyAndProcessRequest(IHttpHandler httpHandler, HttpContextBase httpContext) +103
System.Web.Routing.UrlRoutingHandler.ProcessRequest(HttpContextBase httpContext) +144
System.Web.Routing.UrlRoutingHandler.ProcessRequest(HttpContext httpContext) +42
System.Web.Routing.UrlRoutingHandler.System.Web.IHttpHandler.ProcessRequest(HttpContext context) +10
MvcCms.Web.Default.PageLoad(Object sender, EventArgs e) in C:\projects\mvccms\MvcCms 2.0\MvcCms.Web\MvcCms.Web\Default.aspx.cs:19
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +91
System.Web.UI.Control.LoadRecursive() +74
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207




----------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
Reply posted by wlgray 3 months 19 days ago View Branch And Reply
When I rebuild the solution I get
Error 78 Error 3007: Problem in mapping fragments starting at lines 10117, 10336:Column(s) ProductID are being mapped in both fragments to different conceptual side properties.
C:\projects\mvccms\MvcCms 2.0\MvcCms.Data\MvcCmsDataModel.edmx 10337 10341 MvcCms.Data

My dev environment:
Visual Studio 2010 Ultimate
SQL Server 2008 Enterprise
IIS 7
All development done on Windows 7 Ultimate box

I ran the SQL Full Script and haven't changed the portal information. Running from the dev env.
Reply posted by jon 3 months 18 days ago View Branch And Reply
The project isn't setup yet for studio 2010, you will need to use 2008.