中小型.NET应用程序的数据库(和ORM)选择 [英] Database (and ORM) choice for an small-medium size .NET Application

问题描述

我需要开发一个基于.NET的应用程序，其数据需求可能会超过SQL 2005 Express Edition的4 gig限制.

I have a requirement to develop a .NET-based application whose data requirements are likely to exceed the 4 gig limit of SQL 2005 Express Edition.

由于内部DBA的专业知识，将来可能会有同一应用程序的其他客户需要使用特定的数据库平台(例如Oracle或SQL Server).

There may be other customers of the same application (in the future) with a requirement to use a specific DB platform (such as Oracle or SQL Server) due to in-house DBA expertise.

1. 你们会推荐什么RDBMS?从外观上看，主要选择是PostGreSQL，MySQL或FireBird.我从中只获得了MYSQL的经验.

1. What RDBMS would you guys recommend? From the looks of it the major choices are PostGreSQL, MySQL or FireBird. I've only got experience of MYSQL from these.

您会建议使用哪个ORM工具(如果有)-理想情况下可以在数据库平台之间轻松交换的工具?我喜欢实体框架的外观，但是不确定在何种程度上支持SQL Server以外的平台.如果有帮助，我们将使用框架的3.5版本.我对使用诸如NHibernate这样的工具的想法持开放态度.另一方面，如果要变得更简单，我很乐意编写自己的存储过程/DAL代码-不会有太多的表(也许30-35).

Which ORM tool (if any) would you recommend using - ideally one that can be swapped out between DB platforms with minimal effort? I like the look of the entity framework but unsure as to the degree to which platforms other than SQL Server are supported. If it helps, we'll be using the 3.5 version of the Framework. I'm open to the idea of using a tool such as NHibernate. On the other hand, if it's going to be easier, I'm happy to write my own stored procedures / DAL code - there won't be that many tables (perhaps 30-35).

推荐答案

我建议在PostgreSQL中使用NHibernate.

I suggest using NHibernate with postgres.

您可以在sqlite上进行所有测试和开发，因此您无需在自己的开发机上运行postgres实例.

You can do all your testing and development on sqlite so you don't need to have an instance of postgres running on your dev machine.

如果不确定是否要使用mysql或postgres，建议将它们都尝试一下. Postgres更加合规，但是如果您对mysql感到满意(并且正在使用ORM)，则应该使用它.

If you aren't sure if you want to use mysql or postgres, I suggest trying them both out. Postgres is more compliant, but if you're comfortable with mysql (and you're using an ORM), you should probably use that.

这篇关于中小型.NET应用程序的数据库(和ORM)选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！