asp.net中的高性能数据库访问层

时间:2020-12-23 04:14:20

I am developing a applicatin which are having more than 5000 users once upon time. I using ASP.NET 3.5 framework for developement. I want to develope a high performance DAL Layer using latest technolgies like linq,ADO.NET Entity,ADO.NET Data services. I also want to make sure that it shuld be generic to all the future developement. Can any one pleasae Let me know which pattern i should use to develope that Database Access Layer. I am also want to use microsoft enterprise library for that.

我正在开发一个应用程序,一次有超过5000个用户。我使用ASP.NET 3.5框架进行开发。我想使用linq,ADO.NET Entity,ADO.NET Data services等最新技术开发高性能DAL层。我还想确保它对所有未来的发展都是通用的。可以任何一个请求让我知道我应该使用哪种模式来开发数据库访问层。我也想使用微软企业库。

2 个解决方案

#1


I think you should look at NHibernate and Fluent NHibernate.

我想你应该看看NHibernate和Fluent NHibernate。

You could save yourself a lot of time by not writing your own DAL. Only you know your non-functional requirements around perf and whether you're optimizing for reads, updates or something else, so write some tests, prototype, and see how it goes.

不写自己的DAL可以节省很多时间。只有你知道围绕perf的非功能性要求,以及你是否正在优化读取,更新或其他东西,所以写一些测试,原型,看看它是如何进行的。

My personaly opinion is that Microsoft Ent Lib and perf aren't best buddies, but again you should prototype and prove this early in your dev cycle.

我个人认为,Microsoft Ent Lib和perf并不是最好的伙伴,但是你应该在你的开发周期中尽早制作原型并证明这一点。

#2


You can use Linq to SQL.

您可以使用Linq to SQL。

You can also take a look at this article series for creating an actual DAL using the same technology.

您还可以查看本系列文章,了解如何使用相同的技术创建实际的DAL。

#1


I think you should look at NHibernate and Fluent NHibernate.

我想你应该看看NHibernate和Fluent NHibernate。

You could save yourself a lot of time by not writing your own DAL. Only you know your non-functional requirements around perf and whether you're optimizing for reads, updates or something else, so write some tests, prototype, and see how it goes.

不写自己的DAL可以节省很多时间。只有你知道围绕perf的非功能性要求,以及你是否正在优化读取,更新或其他东西,所以写一些测试,原型,看看它是如何进行的。

My personaly opinion is that Microsoft Ent Lib and perf aren't best buddies, but again you should prototype and prove this early in your dev cycle.

我个人认为,Microsoft Ent Lib和perf并不是最好的伙伴,但是你应该在你的开发周期中尽早制作原型并证明这一点。

#2


You can use Linq to SQL.

您可以使用Linq to SQL。

You can also take a look at this article series for creating an actual DAL using the same technology.

您还可以查看本系列文章,了解如何使用相同的技术创建实际的DAL。