如果使用Nhibernate，可以在数据库之间切换而不更改Nhibernate代码吗? [英] if I use Nhibernate can I Switch between databases and not change the Nhibernate code?

问题描述

我想做的是将我的整个应用程序从ADO.NET转换为nhibernate，并使用不同的数据库对其进行测试.我知道nhibernate支持许多不同的数据库，所以我可以在不更改任何应用程序或nhibernate代码的情况下在不同的数据库之间切换吗?

What I want to do is convert my whole application to nhibernate from ADO.NET and test it using different databases. i know nhibernate supports many different databases so can i switch between different databases without changing any of my application or nhibernate code?

推荐答案

只要您不编写针对特定DMBS的任何特定查询(可以使用NHiberate( ISession.CreateSqlQuery )，我会说这是可能的.

As long as you do not write any specific queries targetted for a specific DMBS (which is possible using NHiberate (ISession.CreateSqlQuery), I would say that it is possible.

但是，使用hql或ICriteria API编写的查询应该在其他DBMS上开箱即用.(提供NHibernate支持这些DBMS).

But, queries that have been written using hql or ICriteria API should work out of the box on other DBMS'es. (Provided that NHibernate supports those DBMS).

尽管如此，可能有必要更改某些配置设置(

Although, it might be necessary to change some config settings (http://fgheysels.blogspot.com/2007/07/nhibernate-ms-access-problems-with.html for instance).

这篇关于如果使用Nhibernate，可以在数据库之间切换而不更改Nhibernate代码吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！