godaddy 管理mysql_在godaddy上使用MySQL和Entity Framework的安全例...

我们在godaddy上使用Entity框架时会遇到SecurityException.该实体已针对MySQL存储进行配置. (v.6.1.2)虽然有点奇怪但是…看看异常堆栈似乎暗示如果我们在站点的任何地方打开到MySQL的连接,那么我们应该得到相同的异常;然而,直接打开MySQL连接似乎在网站的另一部分工作…

这是验证：

using (MySqlConnection connection = new MySqlConnection(ConnectionString))

{

connection.Open();

...

}

有人遇到过类似的问题吗？

完整的错误堆栈跟踪如下：

[SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.]

System.Reflection.MethodBase.PerformSecurityCheck(Object obj, RuntimeMethodHandle method, IntPtr parent, UInt32 invocationFlags) +0

System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +470

System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) +1051

System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) +111

System.Resources.ResourceManager.CreateResourceSet(Stream store, Assembly assembly) +357

System.Resources.ResourceManager.InternalGetResourceSet(CultureInfo culture, Boolean createIfNotExists, Boolean tryParents) +471

System.Resources.ResourceManager.InternalGetResourceSet(CultureInfo culture, Boolean createIfNotExists, Boolean tryParents) +583

System.Resources.ResourceManager.InternalGetResourceSet(CultureInfo culture, Boolean createIfNotExists, Boolean tryParents) +583

System.Resources.ResourceManager.GetString(String name, CultureInfo culture) +74

MySql.Data.MySqlClient.Resources.get_PerfMonCategoryName() +40

MySql.Data.MySqlClient.PerformanceMonitor..ctor(MySqlConnection connection) +43

MySql.Data.MySqlClient.MySqlConnection.Open() +434

System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure) +173

System.Data.EntityClient.EntityConnection.Open() +96

System.Data.Objects.ObjectContext.EnsureConnection() +81

System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) +46

System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable.GetEnumerator() +44

jet.Controllers.WorkOrder.WorkOrderView..ctor() +219

jet.Controllers.WorkOrder.WorkOrderView.get_Instance() +29

jet.Controllers.WorkItemController.Index() +11

lambda_method(ExecutionScope , ControllerBase , Object[] ) +39

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.b__7() +53

System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +258

System.Web.Mvc.<>c__DisplayClassc.b__9() +20

System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, 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() +181

System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75