Description:
This Linq request does perfectly work with Sql Server, but with MySql I've got a not implemented exception from the .Net connector.
myContext = new SiteDbContext();
returnedSite = myContext
.Set<WUSiteObject>().Where(s => s.Id == id)
.Include(s => s.Elements)
.Include(s => s.OrographyFiles.Select(o => o.File))
.Include(s => s.RoughnessFiles.Select(r => r.File))
.Include(s => s.WRAResults.Select(w => w.ResultsFiles))
.Include(s => s.WRAResults.Select(w => w.Outputs))
.Include(s => s.WRAResults.Select(w => w.Parameters.InnerParameters))
.Include(s => s.WRAResults.Select(w => w.Parameters.MMClimatos.Select(c => c.Correction_Turbulence)))
.Include(s => s.WRAResults.Select(w => w.Parameters.RefClimato.Correction_Turbulence))
.Include(s => s.WRAResults.Select(w => w.Parameters.Wind_Turbine_Type))
.Include(s => s.WRAResults.Select(w => w.Parameters.Park.WindTurbinesList.Select(wt => wt.Type)))
.Include(s => s.CFDResults.Select(c => c.ResultsFiles))
.Include(s => s.CFDResults.Select(c => c.Outputs))
.Include(s => s.CFDResults.Select(c => c.CFDParameters))
.Include(s => s.DataForm)
.FirstOrDefault();
How to repeat:
Here is the call stack:
MySql.Data.Entity.EF6.dll!MySql.Data.Entity.SelectGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbApplyExpression expression) + 0x81c octets
EntityFramework.dll!System.Data.Entity.Core.Common.CommandTrees.DbApplyExpression.Accept<MySql.Data.Entity.SqlFragment>(System.Data.Entity.Core.Common.CommandTrees.DbExpressionVisitor<MySql.Data.Entity.SqlFragment> visitor) + 0x6d octets
MySql.Data.Entity.EF6.dll!MySql.Data.Entity.SqlGenerator.VisitInputExpression(System.Data.Entity.Core.Common.CommandTrees.DbExpression e, string name, System.Data.Entity.Core.Metadata.Edm.TypeUsage type) + 0x55 octets
MySql.Data.Entity.EF6.dll!MySql.Data.Entity.SelectGenerator.VisitInputExpressionEnsureSelect(System.Data.Entity.Core.Common.CommandTrees.DbExpression e, string name, System.Data.Entity.Core.Metadata.Edm.TypeUsage type) + 0x41 octets
MySql.Data.Entity.EF6.dll!MySql.Data.Entity.SelectGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbProjectExpression expression) + 0x98 octets
EntityFramework.dll!System.Data.Entity.Core.Common.CommandTrees.DbProjectExpression.Accept<MySql.Data.Entity.SqlFragment>(System.Data.Entity.Core.Common.CommandTrees.DbExpressionVisitor<MySql.Data.Entity.SqlFragment> visitor) + 0x6d octets
MySql.Data.Entity.EF6.dll!MySql.Data.Entity.SqlGenerator.VisitInputExpression(System.Data.Entity.Core.Common.CommandTrees.DbExpression e, string name, System.Data.Entity.Core.Metadata.Edm.TypeUsage type) + 0x55 octets
MySql.Data.Entity.EF6.dll!MySql.Data.Entity.SelectGenerator.VisitInputExpressionEnsureSelect(System.Data.Entity.Core.Common.CommandTrees.DbExpression e, string name, System.Data.Entity.Core.Metadata.Edm.TypeUsage type) + 0x41 octets
MySql.Data.Entity.EF6.dll!MySql.Data.Entity.SelectGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbUnionAllExpression expression) + 0xa5 octets
EntityFramework.dll!System.Data.Entity.Core.Common.CommandTrees.DbUnionAllExpression.Accept<MySql.Data.Entity.SqlFragment>(System.Data.Entity.Core.Common.CommandTrees.DbExpressionVisitor<MySql.Data.Entity.SqlFragment> visitor) + 0x6d octets
MySql.Data.Entity.EF6.dll!MySql.Data.Entity.SqlGenerator.VisitInputExpression(System.Data.Entity.Core.Common.CommandTrees.DbExpression e, string name, System.Data.Entity.Core.Metadata.Edm.TypeUsage type) + 0x55 octets
MySql.Data.Entity.EF6.dll!MySql.Data.Entity.SelectGenerator.VisitInputExpressionEnsureSelect(System.Data.Entity.Core.Common.CommandTrees.DbExpression e, string name, System.Data.Entity.Core.Metadata.Edm.TypeUsage type) + 0x41 octets
MySql.Data.Entity.EF6.dll!MySql.Data.Entity.SelectGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbProjectExpression expression) + 0x98 octets
EntityFramework.dll!System.Data.Entity.Core.Common.CommandTrees.DbProjectExpression.Accept<MySql.Data.Entity.SqlFragment>(System.Data.Entity.Core.Common.CommandTrees.DbExpressionVisitor<MySql.Data.Entity.SqlFragment> visitor) + 0x6d octets
MySql.Data.Entity.EF6.dll!MySql.Data.Entity.SqlGenerator.VisitInputExpression(System.Data.Entity.Core.Common.CommandTrees.DbExpression e, string name, System.Data.Entity.Core.Metadata.Edm.TypeUsage type) + 0x55 octets
MySql.Data.Entity.EF6.dll!MySql.Data.Entity.SelectGenerator.VisitInputExpressionEnsureSelect(System.Data.Entity.Core.Common.CommandTrees.DbExpression e, string name, System.Data.Entity.Core.Metadata.Edm.TypeUsage type) + 0x41 octets
MySql.Data.Entity.EF6.dll!MySql.Data.Entity.SelectGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbUnionAllExpression expression) + 0x79 octets
EntityFramework.dll!System.Data.Entity.Core.Common.CommandTrees.DbUnionAllExpression.Accept<MySql.Data.Entity.SqlFragment>(System.Data.Entity.Core.Common.CommandTrees.DbExpressionVisitor<MySql.Data.Entity.SqlFragment> visitor) + 0x6d octets
MySql.Data.Entity.EF6.dll!MySql.Data.Entity.SqlGenerator.VisitInputExpression(System.Data.Entity.Core.Common.CommandTrees.DbExpression e, string name, System.Data.Entity.Core.Metadata.Edm.TypeUsage type) + 0x55 octets
MySql.Data.Entity.EF6.dll!MySql.Data.Entity.SelectGenerator.VisitInputExpressionEnsureSelect(System.Data.Entity.Core.Common.CommandTrees.DbExpression e, string name, System.Data.Entity.Core.Metadata.Edm.TypeUsage type) + 0x41 octets
MySql.Data.Entity.EF6.dll!MySql.Data.Entity.SelectGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbSortExpression expression) + 0xa6 octets
EntityFramework.dll!System.Data.Entity.Core.Common.CommandTrees.DbSortExpression.Accept<MySql.Data.Entity.SqlFragment>(System.Data.Entity.Core.Common.CommandTrees.DbExpressionVisitor<MySql.Data.Entity.SqlFragment> visitor) + 0x6d octets
MySql.Data.Entity.EF6.dll!MySql.Data.Entity.SqlGenerator.VisitInputExpression(System.Data.Entity.Core.Common.CommandTrees.DbExpression e, string name, System.Data.Entity.Core.Metadata.Edm.TypeUsage type) + 0x55 octets
MySql.Data.Entity.EF6.dll!MySql.Data.Entity.SelectGenerator.VisitInputExpressionEnsureSelect(System.Data.Entity.Core.Common.CommandTrees.DbExpression e, string name, System.Data.Entity.Core.Metadata.Edm.TypeUsage type) + 0x41 octets
MySql.Data.Entity.EF6.dll!MySql.Data.Entity.SelectGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbProjectExpression expression) + 0x98 octets
EntityFramework.dll!System.Data.Entity.Core.Common.CommandTrees.DbProjectExpression.Accept<MySql.Data.Entity.SqlFragment>(System.Data.Entity.Core.Common.CommandTrees.DbExpressionVisitor<MySql.Data.Entity.SqlFragment> visitor) + 0x6d octets
MySql.Data.Entity.EF6.dll!MySql.Data.Entity.SelectGenerator.GenerateSQL(System.Data.Entity.Core.Common.CommandTrees.DbCommandTree tree) + 0xbd octets
MySql.Data.Entity.EF6.dll!MySql.Data.MySqlClient.MySqlProviderServices.CreateDbCommandDefinition(System.Data.Entity.Core.Common.DbProviderManifest providerManifest, System.Data.Entity.Core.Common.CommandTrees.DbCommandTree commandTree) + 0x24e octets
EntityFramework.dll!System.Data.Entity.Core.Common.DbProviderServices.CreateDbCommandDefinition(System.Data.Entity.Core.Common.DbProviderManifest providerManifest, System.Data.Entity.Core.Common.CommandTrees.DbCommandTree commandTree, System.Data.Entity.Infrastructure.Interception.DbInterceptionContext interceptionContext) + 0x30 octets
EntityFramework.dll!System.Data.Entity.Core.Common.DbProviderServices.CreateCommandDefinition(System.Data.Entity.Core.Common.CommandTrees.DbCommandTree commandTree, System.Data.Entity.Infrastructure.Interception.DbInterceptionContext interceptionContext) + 0xdd octets
EntityFramework.dll!System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.EntityCommandDefinition(System.Data.Common.DbProviderFactory storeProviderFactory, System.Data.Entity.Core.Common.CommandTrees.DbCommandTree commandTree, System.Data.Entity.Infrastructure.Interception.DbInterceptionContext interceptionContext, System.Data.Entity.Infrastructure.DependencyResolution.IDbDependencyResolver resolver, System.Data.Entity.Core.Query.ResultAssembly.BridgeDataReaderFactory bridgeDataReaderFactory, System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory columnMapFactory) + 0x3c2 octets
EntityFramework.dll!System.Data.Entity.Core.EntityClient.Internal.EntityProviderServices.CreateCommandDefinition(System.Data.Common.DbProviderFactory storeProviderFactory, System.Data.Entity.Core.Common.CommandTrees.DbCommandTree commandTree, System.Data.Entity.Infrastructure.Interception.DbInterceptionContext interceptionContext, System.Data.Entity.Infrastructure.DependencyResolution.IDbDependencyResolver resolver) + 0x45 octets
EntityFramework.dll!System.Data.Entity.Core.EntityClient.Internal.EntityProviderServices.CreateDbCommandDefinition(System.Data.Entity.Core.Common.DbProviderManifest providerManifest, System.Data.Entity.Core.Common.CommandTrees.DbCommandTree commandTree, System.Data.Entity.Infrastructure.Interception.DbInterceptionContext interceptionContext) + 0x98 octets
EntityFramework.dll!System.Data.Entity.Core.Common.DbProviderServices.CreateCommandDefinition(System.Data.Entity.Core.Common.CommandTrees.DbCommandTree commandTree, System.Data.Entity.Infrastructure.Interception.DbInterceptionContext interceptionContext) + 0xdd octets
EntityFramework.dll!System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlanFactory.CreateCommandDefinition(System.Data.Entity.Core.Objects.ObjectContext context, System.Data.Entity.Core.Common.CommandTrees.DbQueryCommandTree tree) + 0xbe octets
EntityFramework.dll!System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlanFactory.Prepare(System.Data.Entity.Core.Objects.ObjectContext context, System.Data.Entity.Core.Common.CommandTrees.DbQueryCommandTree tree, System.Type elementType, System.Data.Entity.Core.Objects.MergeOption mergeOption, bool streaming, System.Data.Entity.Core.Objects.Span span, System.Collections.Generic.IEnumerable<System.Tuple<System.Data.Entity.Core.Objects.ObjectParameter,System.Data.Entity.Core.Objects.ELinq.QueryParameterExpression>> compiledQueryParameters, System.Data.Entity.Core.Common.Utils.AliasGenerator aliasGenerator) + 0x100 octets
EntityFramework.dll!System.Data.Entity.Core.Objects.ELinq.ELinqQueryState.GetExecutionPlan(System.Data.Entity.Core.Objects.MergeOption? forMergeOption) + 0x97f octets
EntityFramework.dll!System.Data.Entity.Core.Objects.ObjectQuery<WU.Site.Model.WUSiteObject>.GetResults.AnonymousMethod__6() + 0x54 octets
EntityFramework.dll!System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction<System.Data.Entity.Core.Objects.ObjectResult<WU.Site.Model.WUSiteObject>>(System.Func<System.Data.Entity.Core.Objects.ObjectResult<WU.Site.Model.WUSiteObject>> func, System.Data.Entity.Infrastructure.IDbExecutionStrategy executionStrategy, bool startLocalTransaction, bool releaseConnectionOnSuccess) + 0x165 octets
EntityFramework.dll!System.Data.Entity.Core.Objects.ObjectQuery<WU.Site.Model.WUSiteObject>.GetResults.AnonymousMethod__5() + 0x10f octets
EntityFramework.dll!System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute<System.Data.Entity.Core.Objects.ObjectResult<WU.Site.Model.WUSiteObject>>(System.Func<System.Data.Entity.Core.Objects.ObjectResult<WU.Site.Model.WUSiteObject>> operation) + 0x2a octets
EntityFramework.dll!System.Data.Entity.Core.Objects.ObjectQuery<WU.Site.Model.WUSiteObject>.GetResults(System.Data.Entity.Core.Objects.MergeOption? forMergeOption) + 0x286 octets
EntityFramework.dll!System.Data.Entity.Core.Objects.ObjectQuery<WU.Site.Model.WUSiteObject>.System.Collections.Generic.IEnumerable<T>.GetEnumerator.AnonymousMethod__0() + 0x45 octets
EntityFramework.dll!System.Data.Entity.Internal.LazyEnumerator<WU.Site.Model.WUSiteObject>.MoveNext() + 0x45 octets
System.Core.dll!System.Linq.Enumerable.FirstOrDefault<WU.Site.Model.WUSiteObject>(System.Collections.Generic.IEnumerable<WU.Site.Model.WUSiteObject> source) + 0xa5 octets
EntityFramework.dll!System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.GetElementFunction.AnonymousMethod__1<WU.Site.Model.WUSiteObject>(System.Collections.Generic.IEnumerable<WU.Site.Model.WUSiteObject> sequence) + 0x54 octets
EntityFramework.dll!System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.ExecuteSingle<WU.Site.Model.WUSiteObject>(System.Collections.Generic.IEnumerable<WU.Site.Model.WUSiteObject> query, System.Linq.Expressions.Expression queryRoot) + 0x6c octets
EntityFramework.dll!System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute<WU.Site.Model.WUSiteObject>(System.Linq.Expressions.Expression expression) + 0xc6 octets
EntityFramework.dll!System.Data.Entity.Internal.Linq.DbQueryProvider.Execute<WU.Site.Model.WUSiteObject>(System.Linq.Expressions.Expression expression) + 0x9c octets
System.Core.dll!System.Linq.Queryable.FirstOrDefault<WU.Site.Model.WUSiteObject>(System.Linq.IQueryable<WU.Site.Model.WUSiteObject> source) + 0xfc octets
> WUDataContexts.dll!WU.Data.Contexts.WUSiteProvider.GetWithRelated(string id) Ligne 193 + 0x328e octets C#
WUDataContexts.Test.dll!WU.Data.Contexts.TestCases.WUSiteProviderMySQLTest.MySqlGetSiteWithRelated() Ligne 111 + 0x24 octets C#
[Transition Natif à Managé]
nunit.core.dll!NUnit.Core.Reflect.InvokeMethod(System.Reflection.MethodInfo method, object fixture, object[] args) + 0x68 octets
nunit.core.dll!NUnit.Core.TestMethod.RunTestMethod() + 0x86 octets
nunit.core.dll!NUnit.Core.TestMethod.RunTestCase(NUnit.Core.TestResult testResult) + 0x4a octets
nunit.core.dll!NUnit.Core.TestMethod.RunTest() + 0xf1 octets
nunit.core.dll!NUnit.Core.NUnitTestMethod.RunTest() + 0x36 octets
nunit.core.dll!NUnit.Core.TestMethod.RunRepeatedTest() + 0xdc octets
nunit.core.dll!NUnit.Core.TestMethod.RunTestInContext() + 0x584 octets
nunit.core.dll!NUnit.Core.TestMethod.Run(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0x118 octets
nunit.core.dll!NUnit.Core.TestSuite.RunAllTests(NUnit.Core.TestResult suiteResult, NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0x350 octets
nunit.core.dll!NUnit.Core.TestSuite.RunSuite(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0x4b7 octets
nunit.core.dll!NUnit.Core.TestSuite.RunSuiteInContext(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0x74 octets
nunit.core.dll!NUnit.Core.TestSuite.Run(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0xd9 octets
nunit.core.dll!NUnit.Core.TestFixture.Run(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0x92 octets
nunit.core.dll!NUnit.Core.TestSuite.RunAllTests(NUnit.Core.TestResult suiteResult, NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0x350 octets
nunit.core.dll!NUnit.Core.TestSuite.RunSuite(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0x4b7 octets
nunit.core.dll!NUnit.Core.TestSuite.RunSuiteInContext(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0x74 octets
nunit.core.dll!NUnit.Core.TestSuite.Run(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0xd9 octets
nunit.core.dll!NUnit.Core.SetUpFixture.Run(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0x92 octets
nunit.core.dll!NUnit.Core.TestSuite.RunAllTests(NUnit.Core.TestResult suiteResult, NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0x350 octets
nunit.core.dll!NUnit.Core.TestSuite.RunSuite(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0x4b7 octets
nunit.core.dll!NUnit.Core.TestSuite.RunSuiteInContext(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0x74 octets
nunit.core.dll!NUnit.Core.TestSuite.Run(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0xd9 octets
nunit.core.dll!NUnit.Core.TestSuite.RunAllTests(NUnit.Core.TestResult suiteResult, NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0x350 octets
nunit.core.dll!NUnit.Core.TestSuite.RunSuite(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0x4b7 octets
nunit.core.dll!NUnit.Core.TestSuite.RunSuiteInContext(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0x74 octets
nunit.core.dll!NUnit.Core.TestSuite.Run(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0xd9 octets
nunit.core.dll!NUnit.Core.TestSuite.RunAllTests(NUnit.Core.TestResult suiteResult, NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0x350 octets
nunit.core.dll!NUnit.Core.TestSuite.RunSuite(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0x4b7 octets
nunit.core.dll!NUnit.Core.TestSuite.RunSuiteInContext(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0x74 octets
nunit.core.dll!NUnit.Core.TestSuite.Run(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0xd9 octets
nunit.core.dll!NUnit.Core.TestSuite.RunAllTests(NUnit.Core.TestResult suiteResult, NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0x350 octets
nunit.core.dll!NUnit.Core.TestSuite.RunSuite(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0x4b7 octets
nunit.core.dll!NUnit.Core.TestSuite.RunSuiteInContext(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0x74 octets
nunit.core.dll!NUnit.Core.TestSuite.Run(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter) + 0xd9 octets
nunit.core.dll!NUnit.Core.SimpleTestRunner.Run(NUnit.Core.EventListener listener, NUnit.Core.ITestFilter filter, bool tracing, NUnit.Core.LoggingThreshold logLevel) + 0xd7 octets
nunit.core.dll!NUnit.Core.TestRunnerThread.TestRunnerThreadProc() + 0x97 octets
mscorlib.dll!System.Threading.ThreadHelper.ThreadStart_Context(object state) + 0x6f octets
mscorlib.dll!System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext executionContext, System.Threading.ContextCallback callback, object state, bool preserveSyncCtx) + 0xa7 octets
mscorlib.dll!System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext executionContext, System.Threading.ContextCallback callback, object state, bool preserveSyncCtx) + 0x16 octets
mscorlib.dll!System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext executionContext, System.Threading.ContextCallback callback, object state) + 0x41 octets
mscorlib.dll!System.Threading.ThreadHelper.ThreadStart() + 0x44 octets
[Transition Natif à Managé]
[Transition Appdomain]
[Transition Natif à Managé]
Suggested fix:
Implement the method.