轻量级ORM数据访问框架SqlBuilder.NET的设计与实现
|
摘要
基于ORM思想,结合Nhibernate与NBear的优点,提出了一种轻量级ORM数据访问框架SqlBuilder.NET,旨在为通用数据访问提供完整的解决方案。Sqlbuilder.NET基于C#语言编写,主要由OracleSqlBuilder、DBOperation和SqlObjectMarker构成。Sqlbuilder.NET具有一个事务一个日志列表、特殊字符的编解码、查询结果多种类型输出和组件间的松耦合的特性,实现了数据新增、更新的对象化操作及对象化的复杂查询语句生成等功能。
In this paper, based on the method of ORM and combining with the advantages of Nhibernate and NBear. a lightweight ORM data access framework, SqlBuilder.NET is proposed to provide a complete solution for general data access. Sqlbuilder.NET adopts C# language, and mainly composed of Oracle SqlBuilder(SQL statement object generated component), DBOperation(database operation component), SqlObjectMarker(object generator tool). Sqlbuilder.NET has such characteristics as a transaction to a log list,special character codec, multiple output types of query results, and loose coupling among components. The functions are realized, such as object-oriented operation with data adding and updating, generation of objectified complex query statements and so on.
In this paper, based on the method of ORM and combining with the advantages of Nhibernate and NBear. a lightweight ORM data access framework, SqlBuilder.NET is proposed to provide a complete solution for general data access. Sqlbuilder.NET adopts C# language, and mainly composed of Oracle SqlBuilder(SQL statement object generated component), DBOperation(database operation component), SqlObjectMarker(object generator tool). Sqlbuilder.NET has such characteristics as a transaction to a log list,special character codec, multiple output types of query results, and loose coupling among components. The functions are realized, such as object-oriented operation with data adding and updating, generation of objectified complex query statements and so on.
引文
[1]李斌勇,李庆.基于NHibernate的ORM映射机制研究[J].计算机技术与发展,2009,19(7):32-34.
[2]潘立武,张建平.基于NBear企业级应用设计与开发[J].电脑编程技巧与维护,2009(13):28-33.
[3]欧勤坪,余建桥.基于Spring MVC+i BATIS框架的生物信息数据库的设计与实现[J].西南大学学报(自然科学版),2008,30(11):142-145.
[4]刘冬.NHibernate从入门到精通系列(1)[EB/OL].(2011/2/14)[2018-1-1].http://www.cnblogs.com/Good Helper/archive/2011/02/14/nhiberante_01.html.
[5]NBear Google Group.NBear常见问题集[EB/OL].(2006/12/13)[2018-1-1]https://www.cnblogs.com/fengmk2/archive/2006/12/13/590447.html.
[6]Patrick Liu.Net环境下比较流行的ORM框架对比[EB/OL].(2016/10/25)[2018-1-1].http://www.cnblogs.com/Patrick Liu/p/5995592.html.
[2]潘立武,张建平.基于NBear企业级应用设计与开发[J].电脑编程技巧与维护,2009(13):28-33.
[3]欧勤坪,余建桥.基于Spring MVC+i BATIS框架的生物信息数据库的设计与实现[J].西南大学学报(自然科学版),2008,30(11):142-145.
[4]刘冬.NHibernate从入门到精通系列(1)[EB/OL].(2011/2/14)[2018-1-1].http://www.cnblogs.com/Good Helper/archive/2011/02/14/nhiberante_01.html.
[5]NBear Google Group.NBear常见问题集[EB/OL].(2006/12/13)[2018-1-1]https://www.cnblogs.com/fengmk2/archive/2006/12/13/590447.html.
[6]Patrick Liu.Net环境下比较流行的ORM框架对比[EB/OL].(2016/10/25)[2018-1-1].http://www.cnblogs.com/Patrick Liu/p/5995592.html.