我应该使用哪个DAL选择？ [英] Which DAL choice should I use?

问题描述

我正在进行一个小型项目。我有一个很大的SQL查询表达式，30多行，我希望在我的项目中使用。这个应用程序需要通过这些查询来提供对数据库的只读访问。

有很多数据层选择。 nHibernate，实体框架，LINQ to SQL，数据集，Castle ActiveRecord ...其他我不能命名我的头顶。我不想将这个查询重新编译到LINQ中，所以我认为这是出来的。如果我仍然可以将其复制到查询编辑器中，或者将其轻松地移植到其他框架中，我更愿意。

此项目是关于学习新技术。为了在我的腰带下有一个有用的技术，我应该使用哪个框架？我不会从这个应用程序更新数据库。

建议？

解决方案

NHibernate 获胜！

I'm working on a little side project. I've got a large SQL query expression, 30+ lines, that I wish to use in my project. This app needs to provide read-only access to the database through these queries.

There are so many data layer choices. nHibernate, Entity Framework, LINQ to SQL, Datasets, Castle ActiveRecord... others I can't name off the top of my head. I don't want to have to recode this query into LINQ, so I think that's out. I'd prefer it if I could still copy it into a query editor or easily port it to some other framework.

This project is about learning a new technology. For the purposes of having a useful tech under my belt, which framework should I use? I will not, ever, update the database from this app.

Advice?

解决方案

NHibernate for the win!

这篇关于我应该使用哪个DAL选择？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！