Can dotConnect be used with ormLite or Simple.Data without installing Oracle client?
Posted: Mon 11 Nov 2013 12:06
Hello,
We are using dotConnect Entity Framework provider for Oracle, and now in addition to that we need to manage a small database where use of Entity Framework is an overkill. What we have in mind is to use one of so called microORMs, such Simple.Data or ServiceStack OrmLite. I tried to compile a small test with OrmLite, but the fails with the following message:
System.Exception : System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
This is understandable since I don't have Oracle client installed on my machine and would like to avoid that (we have to manage several machines, so not fiddling with Oracle clients on each of them gives us great advantage, and dotConnect has been good in releasing us from it). My connection code looks like this:
var connectionString = ConfigurationManager.ConnectionStrings["OracleConnection"];
var dbFactory = new OrmLiteConnectionFactory(connectionString.ConnectionString, OracleDialect.Provider);
And here's a connection string:
<connectionStrings>
<add name="OracleConnection" connectionString="User Id=XXX;Password=XXX;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XXX)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XXX)));Persist Security Info=True" providerName="Devart.Data.Oracle"/>
</connectionStrings>
So the question is whether it's possible at all to replace Oracle client with dotConnect with such ORMs. Has anyone succeeded or there is no way to use these microORMs with dotConnect for Oracle?
Thanks in advance.
We are using dotConnect Entity Framework provider for Oracle, and now in addition to that we need to manage a small database where use of Entity Framework is an overkill. What we have in mind is to use one of so called microORMs, such Simple.Data or ServiceStack OrmLite. I tried to compile a small test with OrmLite, but the fails with the following message:
System.Exception : System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
This is understandable since I don't have Oracle client installed on my machine and would like to avoid that (we have to manage several machines, so not fiddling with Oracle clients on each of them gives us great advantage, and dotConnect has been good in releasing us from it). My connection code looks like this:
var connectionString = ConfigurationManager.ConnectionStrings["OracleConnection"];
var dbFactory = new OrmLiteConnectionFactory(connectionString.ConnectionString, OracleDialect.Provider);
And here's a connection string:
<connectionStrings>
<add name="OracleConnection" connectionString="User Id=XXX;Password=XXX;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XXX)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XXX)));Persist Security Info=True" providerName="Devart.Data.Oracle"/>
</connectionStrings>
So the question is whether it's possible at all to replace Oracle client with dotConnect with such ORMs. Has anyone succeeded or there is no way to use these microORMs with dotConnect for Oracle?
Thanks in advance.