DirectMode with Devart and FluentNHibernate and Oracle 10g
本文关键字:and Oracle 10g FluentNHibernate DirectMode Devart with | 更新日期: 2023-09-27 18:19:04
我有一个Windows x64安装在我的机器上,当然Oracle没有在 Oracle10g
中使用他们的客户端驱动程序,这对我来说似乎是一个巨大的问题(停止抱怨)....
So i actually have to connect to DB with Direct Mode.
它是这样工作的:
OracleConnectionStringBuilder oraCsb = new OracleConnectionStringBuilder {
Direct = true,
Server = "xxx",
Port = 1521,
Sid = "xxx",
UserId = "xxx",
Password = "xxx"
};
OracleConnection myConnection = new OracleConnection(oraCsb.ConnectionString);
myConnection.Open();
const string myInsertQuery = "SELECT * FROM MEMBERS WHERE ID = 1";
OracleCommand myCommand = new OracleCommand(myInsertQuery) { Connection = myConnection };
myConnection.Open();
try {
var source = myCommand.ExecuteReader();
} finally {
myConnection.Close();
}
实际上是这样的
但这是我的问题如何集成到FluentNHibernate?
在这里怎么用?
_configuration = Fluently.Configure().Database(OracleClientConfiguration.Oracle10 .ConnectionString(@"server=xxx;user id=xxx;password=xxx;SID=xxx;port=1521;Direct=True;")
.UseReflectionOptimizer()
.AdoNetBatchSize(5000)
.ShowSql().FormatSql())
如何使其工作没有 OracleClient (for 10g)
?
NHibernate运行时支持和直接模式功能包含在Oracle的专业版dotConnect中。下面是一个编译NHibernate源代码来添加dotConnect provider支持的例子:http://blogs.devart.com/dotconnect/nhibernate_and_oracle.html.
我们还建议您注意支持ADO的NHibernate(和Professional)的Entity Developer。. NET提供程序创建NHibernate模型并为它们生成类和映射