获取linq生成的sql语句

命名空间：using System.Data.Objects; 

var query = db.TxtRes.Join(db.LangRes, a => new { id1 = a.ResID, id2 = a.ResID }, b => new { id1=b.ID,id2=b.ID }, (a, b) => new { a.ID, a.ResID, a.Lang, b.Key });

       var objectQuery = query as System.Data.Objects.ObjectQuery;
       return objectQuery.ToTraceString(); //获取sql语句

获取linq生成的sql语句

原文：http://www.cnblogs.com/tiancai/p/5035456.html