真爱无限的知识驿站

学习积累技术经验,提升自身能力

linq to Entities,将查询语句转换为普通的SQL语句

.Net Code:

            using (testEntities MyEntity = new testEntities())
            {
                #region linq to entities 内容练习3
                var result = from s in MyEntity.stuinfo
                             where s.username == "pkm"
                             select new
                             {
                                 username=s.username,
                                 age=s.age
                             };
                var psql = result.GetType().GetMethod("ToTraceString").Invoke(result, null);//得到原始sql语句
                
                Console.WriteLine(psql);
                #endregion
            }


<< 1 >>

Powered By Z-BlogPHP 1.7.3

Copyright 2024-2027 pukuimin Rights Reserved.
粤ICP备17100155号