DevForce Community Forum : Long error on join with where... http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Long error on join with where... Tue, 21 Apr 2026 08:53:20 -700 Fri, 14 May 2010 19:28:05 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1793 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Long error on join with where... : Sweet! Thanks for letting us know.... http://www.ideablade.com/forum/forum_posts.asp?TID=1793&PID=6886#6886 Author: ting
Subject: 1793
Posted: 14-May-2010 at 7:28pm

Sweet!  Thanks for letting us know.]]> Fri, 14 May 2010 19:28:05 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1793&PID=6886#6886 Long error on join with where... : Works perfectly, thanks!Cheers,Jason ... http://www.ideablade.com/forum/forum_posts.asp?TID=1793&PID=6870#6870 Author: jsobell
Subject: 1793
Posted: 13-May-2010 at 7:27am

Works perfectly, thanks!

Cheers,
 Jason
]]> Thu, 13 May 2010 07:27:14 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1793&PID=6870#6870 Long error on join with where... : That would make sense. This was... http://www.ideablade.com/forum/forum_posts.asp?TID=1793&PID=6839#6839 Author: jsobell
Subject: 1793
Posted: 10-May-2010 at 6:16pm

That would make sense. This was in a project converted from WCF RIA.
I'll try it later today and let you know.

Thanks,
 Jason
]]> Mon, 10 May 2010 18:16:47 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1793&PID=6839#6839 Long error on join with where... : I believe this has to do with... http://www.ideablade.com/forum/forum_posts.asp?TID=1793&PID=6838#6838 Author: ting
Subject: 1793
Posted: 10-May-2010 at 5:10pm

I believe this has to do with a Silverlight assembly trust issue.  In order to get the original query syntax to work, the assembly containing the query must grant trust to System.Core.  We've modified the templates for DevForce 2010 to do this automatically, but if you didn't start from a DevForce 2010 template or you've created a new assembly, you will need to add this assembly level attribute to the AsssemblyInfo.cs file:
 
[assembly: InternalsVisibleTo("System.Core, PublicKey=00240000048000009400000006020000002400005253413100040000010001008d56c76f9e8649383049f383c44be0ec204181822a6c31cf5eb7ef486944d032188ea1d3920763712ccb12d75fb77e9811149e6148e5d32fbaab37611c1878ddc19e20ef135d0cb2cff2bfec3d115810c3d9069638fe4be215dbf795861920e5ab6f7db2e2ceef136ac23d5dd2bf031700aec232f6c6b1c785b4305c123b37ab")]
 
Let us know if that works!
 


Edited by ting - 10-May-2010 at 5:17pm]]> Mon, 10 May 2010 17:10:42 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1793&PID=6838#6838 Long error on join with where... : Ping! http://www.ideablade.com/forum/forum_posts.asp?TID=1793&PID=6832#6832 Author: jsobell
Subject: 1793
Posted: 10-May-2010 at 7:05am

Ping!]]> Mon, 10 May 2010 07:05:00 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1793&PID=6832#6832 Long error on join with where... : Trying a relatively simple query... http://www.ideablade.com/forum/forum_posts.asp?TID=1793&PID=6814#6814 Author: jsobell
Subject: 1793
Posted: 06-May-2010 at 4:12pm

Trying a relatively simple query with a join, but adding a Where clause causes a MethodAccessException:

            Guid gid = custacct.CustomerAccountID;
            IEntityQuery<UserProfile> query =
                from users in RepositoryDomainContext.UserProfiles
                join p in RepositoryDomainContext.Permissions
                on users.UserProfileId equals p.UserProfileId
                where p.ElementID == gid
                select users;

            RepositoryDomainContext.ExecuteQueryAsync(query, cb => callback(cb.Results), null);

this results in the exception below.
Removing the where works perfectly, as does restructuring the query:

            IEntityQuery<UserProfile> query =
                from users in RepositoryDomainContext.UserProfiles
                join p in RepositoryDomainContext.Permissions.Where(pp => pp.ElementID == gid)
                on users.UserProfileId equals p.UserProfileId
                select users;

Any suggestions?

Cheers,
 Jason

Exception:
{System.MethodAccessException: Attempt by method 'System.Linq.Expressions.Expression.CreateLambda(System.Type, System.Linq.Expressions.Expression, System.String, Boolean, System.Collections.ObjectModel.ReadOnlyCollection`1<System.Linq.Expressions.ParameterExpression>)' to access method 'System.Linq.Expressions.Expression`1<System.Func`2<<>f__AnonymousType0`2<QuestMetrics.Manager.Model.Data.UserProfile,QuestMetrics.Manager.Model.Data.Permission>,System.Boolean>>.Create(System.Linq.Expressions.Expression, System.String, Boolean, System.Collections.ObjectModel.ReadOnlyCollection`1<System.Linq.Expressions.ParameterExpression>)' failed.
   at System.RuntimeMethodHandle.PerformSecurityCheck(Object obj, RuntimeMethodHandleInternal method, RuntimeType parent, UInt32 invocationFlags)
   at System.RuntimeMethodHandle.PerformSecurityCheck(Object obj, IRuntimeMethodInfo method, RuntimeType parent, UInt32 invocationFlags)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.Linq.Expressions.Expression.CreateLambda(Type delegateType, Expression body, String name, Boolean tailCall, ReadOnlyCollection`1 parameters)
   at System.Linq.Expressions.Expression.Lambda(Type delegateType, Expression body, String name, Boolean tailCall, IEnumerable`1 parameters)
   at System.Linq.Expressions.Expression.Lambda(Type delegateType, Expression body, ParameterExpression[] parameters)
   at IdeaBlade.Linq.TransformExpressionVisitor.VisitLambda(LambdaExpression le, Expression bodyExpr, IEnumerable`1 parameterExpressions)
   at IdeaBlade.Linq.ExpressionVisitor.VisitExpressionCore(Expression e)
   at IdeaBlade.Linq.TransformExpressionVisitor.VisitExpressionCore(Expression expr)
   at IdeaBlade.Linq.LocalizingExpressionVisitor.VisitExpressionCore(Expression expr)
   at IdeaBlade.Linq.ExpressionVisitor.VisitExpression(Expression expr)
   at IdeaBlade.Linq.ExpressionVisitor.VisitExpressionCore(Expression e)
   at IdeaBlade.Linq.TransformExpressionVisitor.VisitExpressionCore(Expression expr)
   at IdeaBlade.Linq.LocalizingExpressionVisitor.VisitExpressionCore(Expression expr)
   at IdeaBlade.Linq.ExpressionVisitor.VisitExpression(Expression expr)
   at IdeaBlade.Linq.ExpressionVisitor.<VisitExpressions>b__0(Expression e)
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
   at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
   at IdeaBlade.Linq.ExpressionVisitor.VisitExpressions(IEnumerable`1 expressions)
   at IdeaBlade.Linq.ExpressionVisitor.VisitExpressionCore(Expression e)
   at IdeaBlade.Linq.TransformExpressionVisitor.VisitExpressionCore(Expression expr)
   at IdeaBlade.Linq.LocalizingExpressionVisitor.VisitExpressionCore(Expression expr)
   at IdeaBlade.Linq.ExpressionVisitor.VisitExpression(Expression expr)
   at IdeaBlade.Linq.ExpressionVisitor.<VisitExpressions>b__0(Expression e)
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
   at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
   at IdeaBlade.Linq.ExpressionVisitor.VisitExpressions(IEnumerable`1 expressions)
   at IdeaBlade.Linq.ExpressionVisitor.VisitExpressionCore(Expression e)
   at IdeaBlade.Linq.TransformExpressionVisitor.VisitExpressionCore(Expression expr)
   at IdeaBlade.Linq.LocalizingExpressionVisitor.VisitExpressionCore(Expression expr)
   at IdeaBlade.Linq.ExpressionVisitor.VisitExpression(Expression expr)
   at IdeaBlade.Linq.ExpressionVisitor.Visit(Expression expr)
   at IdeaBlade.Linq.LocalizingExpressionVisitor.Visit(Expression expr)
   at IdeaBlade.EntityModel.ServerEntityQuery..ctor(EntityQuery query)
   at IdeaBlade.EntityModel.EntityQuery`1.GetServerQuery()
   at IdeaBlade.EntityModel.EntityQueryFinder.get_ServerQuery()
   at IdeaBlade.EntityModel.EntityQueryFinder.Execute()
   at IdeaBlade.EntityModel.EntityManager.ExecuteQueryCore(IEntityQuery query, Boolean isAsync)
   at IdeaBlade.EntityModel.EntityManager.<ExecuteQueryAsyncCore>b__4c[T](EntityQueryOperation`1 op)
   at IdeaBlade.EntityModel.AsyncProcessor`1.Execute()
   at IdeaBlade.EntityModel.EntityManager.ExecuteQueryAsyncCore[T](AsyncProcessor`1 processor)
   at IdeaBlade.EntityModel.EntityManager.ExecuteQueryAsync[T](IEntityQuery`1 query, Action`1 userCallback, Object userState)
   at QuestMetrics.Manager.DataModel.Repositories.PermissionRepository.GetUserProfilesWithPermissions(CustomerAccount custacct, Action`1 callback, Expression`1 filter)}


Edited by jsobell - 06-May-2010 at 4:13pm]]> Thu, 06 May 2010 16:12:46 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1793&PID=6814#6814