linq to entity 查看生成的SQL语句

       
可以利用ObjectQuery的ToTraceString查看生成的SQL语句：

public IQueryable<T_Bas_PlanInfo> GetT_Bas_PlanInfoByCondition(string industryId)
        {
            var list = this.ObjectContext.T_Bas_EnterpriseProductionData
                .Where(e => e.region.Equals(industryId))
                .Select(e => e.latitude.Trim())
                .Distinct();

            var results = this.ObjectContext.T_Bas_PlanInfo
                .Where(e => list.Any(e2 => e.plangeneral.Contains(e2)));

             var sql = (results as ObjectQuery<T_Bas_PlanInfo>).ToTraceString();

            return results;
        }