title: Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries
body: <p>I have action in my controller which calls the following method :</p>
  
  <pre><code>public IQueryable&lt;AaaUserContactInfo&gt; getcontactinfo(long[] id)
  {
      var organizationsiteids = from accountsitemapping in entities.AccountSiteMappings
                              where id.Any(accountid =&gt; accountsitemapping.ACCOUNTID == accountid)
                              select accountsitemapping.SITEID;
  
      var usersdepts = from userdept in entities.UserDepartments
                      join deptdefinition in entities.DepartmentDefinitions on userdept.DEPTID equals deptdefinition.DEPTID
                      where organizationsiteids.Any(accountid =&gt; deptdefinition.SITEID == accountid)
                      select userdept;
  
      var contactsinfos = from userdept in usersdepts
                      join contactinfo in entities.AaaUserContactInfoes on userdept.USERID equals contactinfo.USER_ID
                      select contactinfo;
  
      return  contactsinfos;
  }
  </code></pre>
  
  <p>But when I run the application and I navigate to the action method the folowing error will be raised on the view level:-</p>
  
  <pre><code>System.Data.EntityCommandExecutionException was unhandled by user code
    HResult=-2146232004
    Message=An error occurred while executing the command definition. See the inner exception for details.
    Source=System.Data.Entity
    StackTrace:
         at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
         at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
         at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
         at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable&lt;T&gt;.GetEnumerator()
         at System.Data.Entity.Internal.Linq.InternalQuery`1.GetEnumerator()
         at System.Data.Entity.Infrastructure.DbQuery`1.System.Collections.Generic.IEnumerable&lt;TResult&gt;.GetEnumerator()
         at System.Linq.Enumerable.Count[TSource](IEnumerable`1 source)
         at ASP._Page_Views_Home_CustomersDetails_cshtml.Execute() in c:\Users\Administrator\Desktop\new app DEMO2\MvcApplication4 - LATEST -\MvcApplication4\Views\Home\CustomersDetails.cshtml:line 6
         at System.Web.WebPages.WebPageBase.ExecutePageHierarchy()
         at System.Web.Mvc.WebViewPage.ExecutePageHierarchy()
         at System.Web.WebPages.StartPage.RunPage()
         at System.Web.WebPages.StartPage.ExecutePageHierarchy()
         at System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage)
         at System.Web.Mvc.RazorView.RenderView(ViewContext viewContext, TextWriter writer, Object instance)
         at System.Web.Mvc.BuildManagerCompiledView.Render(ViewContext viewContext, TextWriter writer)
         at System.Web.Mvc.ViewResultBase.ExecuteResult(ControllerContext context)
         at System.Web.Mvc.ControllerActionInvoker.InvokeActionResult(ControllerContext controllerContext, ActionResult actionResult)
         at System.Web.Mvc.ControllerActionInvoker.&lt;&gt;c__DisplayClass1c.&lt;InvokeActionResultWithFilters&gt;b__19()
         at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilter(IResultFilter filter, ResultExecutingContext preContext, Func`1 continuation)
    InnerException: System.Data.SqlClient.SqlException
         HResult=-2146232060
         Message=Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.
         Source=.Net SqlClient Data Provider
         ErrorCode=-2146232060
         Class=15
         LineNumber=105
         Number=191
         Procedure=""
         StackTrace:
              at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
              at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
              at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
              at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)
              at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
              at System.Data.SqlClient.SqlDataReader.get_MetaData()
              at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
              at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp; task, Boolean asyncWrite)
              at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean asyncWrite)
              at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
              at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
              at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
              at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
              at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
         InnerException:
  </code></pre>
  
  <p>So what is causing this error??</p>
  
  <p>UPDATED:-
  <img src="https://i.stack.imgur.com/qa0FG.jpg" alt="enter image description here"></p>