title: Entity Framework: Specified method is not supported
body: <p>Code:</p>
  
  <pre class="lang-cs prettyprint-override"><code>List&lt;MemberClass&gt; Members = myEntity.users
  .Where(xXx =&gt; xXx.Status == m_Status &amp;&amp; xXx.CompanyRef != m_CompanyRef 
      &amp;&amp; xXx.userconfigs.FirstOrDefault().IsPublicProfile == true)
  .Select(xXx =&gt; new MemberClass { 
      Username = xXx.Username, 
      FullName = xXx.Name + " " + xXx.Surname, 
      Name = xXx.Name, 
      Surname = xXx.Surname, 
      AccessName = xXx.useraccess.Name, 
      RID = xXx.RID, 
      Email = xXx.Email }).ToList();
  </code></pre>
  
  <p>Exception:</p>
  
  <pre class="lang-none prettyprint-override"><code>System.Data.EntityCommandCompilationException was unhandled by user code HResult=-2146232005 Message=An error occurred while preparing the command definition. See the inner exception for details.
  Source=System.Data.Entity StackTrace:
   at System.Data.EntityClient.EntityCommandDefinition..ctor(DbProviderFactory storeProviderFactory, DbCommandTree commandTree)
   at System.Data.EntityClient.EntityProviderServices.CreateCommandDefinition(DbProviderFactory storeProviderFactory, DbCommandTree commandTree)
   at System.Data.EntityClient.EntityProviderServices.CreateDbCommandDefinition(DbProviderManifest providerManifest, DbCommandTree commandTree)
   at System.Data.Common.DbProviderServices.CreateCommandDefinition(DbCommandTree commandTree)
   at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Prepare(ObjectContext context, DbQueryCommandTree tree, Type elementType, MergeOption mergeOption, Span span, ReadOnlyCollection1 compiledQueryParameters, AliasGenerator aliasGenerator)
   at System.Data.Objects.ELinq.ELinqQueryState.GetExecutionPlan(Nullable1 forMergeOption)
   at System.Data.Objects.ObjectQuery1.GetResults(Nullable1 forMergeOption)
   at System.Data.Objects.ObjectQuery1.System.Collections.Generic.IEnumerable&lt;T&gt;.GetEnumerator()
   at System.Collections.Generic.List1..ctor(IEnumerable1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source)
   at MemberHelper.MemberHelperDB.getExternalMemberList(Decimal m_CompanyRef, Decimal m_Status) in c:\Users\Dreamcatcher\Documents\Visual Studio 2010\SVN Projects\OZTranV4\OZTranV4\App_Code\Helper\MemberHelperDB.cs:line 54
   at popup_AddMemberToWork2.gridExternalUser_NeedDataSource(Object sender, GridNeedDataSourceEventArgs e) in c:\Users\Dreamcatcher\Documents\Visual Studio 2010\SVN Projects\OZTranV4\OZTranV4\popup\AddMemberToWork2.aspx.cs:line 157
   at Telerik.Web.UI.RadGrid.OnNeedDataSource(GridNeedDataSourceEventArgs e)
   at Telerik.Web.UI.RadGrid.ObtainDataSource(GridRebindReason rebindReason, Boolean IsBoundUsingDataSourceId)
   at Telerik.Web.UI.RadGrid.AutoDataBind(GridRebindReason rebindReason)
   at Telerik.Web.UI.RadGrid.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
  InnerException: System.NotSupportedException HResult=-2146233067 Message=Specified method is not supported. Source=MySql.Data.Entity StackTrace:
   at MySql.Data.Entity.SqlGenerator.Visit(DbApplyExpression expression)
   at System.Data.Common.CommandTrees.DbApplyExpression.Accept[TResultType](DbExpressionVisitor1 visitor)
   at MySql.Data.Entity.SqlGenerator.VisitInputExpression(DbExpression e, String name, TypeUsage type)
   at MySql.Data.Entity.SelectGenerator.HandleJoinExpression(DbExpressionBinding left, DbExpressionBinding right, DbExpressionKind joinType, DbExpression joinCondition)
   at MySql.Data.Entity.SelectGenerator.Visit(DbJoinExpression expression)
   at System.Data.Common.CommandTrees.DbJoinExpression.Accept[TResultType](DbExpressionVisitor1 visitor)
   at MySql.Data.Entity.SqlGenerator.VisitInputExpression(DbExpression e, String name, TypeUsage type)
   at MySql.Data.Entity.SelectGenerator.VisitInputExpressionEnsureSelect(DbExpression e, String name, TypeUsage type)
   at MySql.Data.Entity.SelectGenerator.Visit(DbFilterExpression expression)
   at System.Data.Common.CommandTrees.DbFilterExpression.Accept[TResultType](DbExpressionVisitor1 visitor)
   at MySql.Data.Entity.SqlGenerator.VisitInputExpression(DbExpression e, String name, TypeUsage type)
   at MySql.Data.Entity.SelectGenerator.VisitInputExpressionEnsureSelect(DbExpression e, String name, TypeUsage type)
   at MySql.Data.Entity.SelectGenerator.Visit(DbProjectExpression expression)
   at System.Data.Common.CommandTrees.DbProjectExpression.Accept[TResultType](DbExpressionVisitor1 visitor)
   at MySql.Data.Entity.SelectGenerator.GenerateSQL(DbCommandTree tree)
   at MySql.Data.MySqlClient.MySqlProviderServices.CreateDbCommandDefinition(DbProviderManifest providerManifest, DbCommandTree commandTree)
   at System.Data.Common.DbProviderServices.CreateCommandDefinition(DbCommandTree commandTree)
   at System.Data.EntityClient.EntityCommandDefinition..ctor(DbProviderFactory storeProviderFactory, DbCommandTree commandTree)
  </code></pre>
  
  <p>This code was working before formatted my computer. I use MySQL 5.5.12, MySQL .NET Connector Version 6.5.4. only Netframework version might be change, i have done all windows updates and when install Visual Studio 2012, automatically .Net 4.5 installed.</p>
  
  <p>How can i fix that?</p>