基于LINQ及表达式树的组合查询设计  

Design on a Combination Query Based on LINQ and Expression Tree

作　　者：黄红伟[1] 谭鹏[1] 李俊[1] 卢云涛[1] HUANG Hong-Wei TAN Peng LI Jun LU Yun-tao(Yunan Academy of Scientific ＆ Technical Information, Kunming Yunnan 650051, China)

机构地区：[1]云南省科学技术情报研究院,云南昆明650051

出　　处：《计算机与网络》2017年第17期62-65,共4页Computer & Network

摘　　要：对当前信息系统中应用动态拼接SQL语句、QueryObject模式等实现数据组合查询功能的主要方案进行比较,分析2种方案的不足及存在的问题,综合利用.NET环境下的LINQ、Lambda及表达式树等技术手段,结合策略模式,设计实现一个消除其他数据组合查询方案缺陷的简单、易扩展及能满足开闭原则的组合查询功能。该方案在云南省科技人才管理信息系统中实际应用,满足了科技人才管理人员对科技人才数据的各种组合查询需求。This paper compares the solutions of implementing data combination query function m the present infonuation system, such as dynamic stitching SQL or QueryObject, and analyzes the shortcomings and problems of the two solutions. By using such technical methods as LINQ, Lalnbda and expression tree and combining strategy mode, a combination query function is designed and implemented, which is simple and extensible, and can eliminate the shortcomings ofnther data combination query solutions and meet the open-closed principle. The solution has been applied in Yunnan scientific and technological talents management information system, and has satisfied the demand of various combinations query for scientific and technical personnel data.

关 键 词：.NET LINQ LAMBDA 表达式树 组合查询 

分 类 号：TP311.1[自动化与计算机技术—计算机软件与理论]