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) ?

DirectMode with Devart and FluentNHibernate and Oracle 10g

NHibernate运行时支持和直接模式功能包含在Oracle的专业版dotConnect中。下面是一个编译NHibernate源代码来添加dotConnect provider支持的例子:http://blogs.devart.com/dotconnect/nhibernate_and_oracle.html.

我们还建议您注意支持ADO的NHibernate(和Professional)的Entity Developer。. NET提供程序创建NHibernate模型并为它们生成类和映射