c# - Unable to cast object of type 'Oracle.DataAccess.Client.OracleConnection' to type 'System.Data.Common.DbConnection' -


i trying setup nhibernate first time , struggling! using oracle database , have following

app.config:

    <?xml version="1.0" encoding="utf-8" ?> <configuration>   <configsections>     <section name="hibernate-configuration" type="nhibernate.cfg.configurationsectionhandler, nhibernate"/>   </configsections>   <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">     <session-factory>       <property name="connection.provider">         nhibernate.connection.driverconnectionprovider       </property>       <property name="dialect">         nhibernate.dialect.oracle10gdialect       </property>       <property name="connection.driver_class">         nhibernate.driver.oracledataclientdriver       </property>       <property name="connection.connection_string">         data source=ctir;persist security info=true;user id=****;password=*****;       </property>       <property name="show_sql">         true       </property>     </session-factory>   </hibernate-configuration> </configuration>

and following form1.cs:

namespace testnhibernate {   public partial class form1 : form {     private configuration myconfig;     private isessionfactory mysessionfactory;     private isession mysession;     public form1()     {         initializecomponent();     }      private void form1_load(object sender, eventargs e)     {         myconfig = new configuration();         myconfig.configure();         schemametadataupdater.quotetableandcolumns(myconfig); <-- here execption         mysessionfactory = myconfig.buildsessionfactory();         mysession = mysessionfactory.opensession();          using (mysession.begintransaction())         {             agenter agent = new agenter {fornavn = "marc", initialer = "mrcr212", id = 999, efternavn = "rasmussen" };             mysession.save(agent);             mysession.transaction.commit();         }     } }

when run in debug mode following error:

unable cast object of type 'oracle.dataaccess.client.oracleconnection' type 'system.data.common.dbconnection'.

can tell me im doing wrong?

** update**

according question: stack question

i should add following line:

 <property name="hbm2ddl.keywords">none</property>

however did not solve issue


Comments

Post a Comment

Popular posts from this blog

android - Inheriting from Theme.AppCompat* -

currently working on migrating actionbar in support libraries. trying migrate old themes inherit theme.appcompat.light.darkactionbar isn't going smoothly. it fine if apply theme in manifest such: <activity android:name="com.fitsby.loginactivity" android:screenorientation="portrait" android:theme="@style/theme.appcompat.light.darkactionbar" > </activity> but runtime error, stating loginactivity(subclass of actionbaractivity) must have theme inherits theme.appcompat, when following: in styles.xml: <style name="apptheme" parent="@style/theme.appcompat.light.darkactionbar"> <item name="android:typeface">sans</item> </style> and in manifest: <activity android:name="com.fitsby.loginactivity" android:screenorientation="portrait" android:theme="@style/apptheme" > </activity> any ideas why happening? not...
Read more

broadcastreceiver - android BOOT_COMPLETED not received if not activity intent-filter -

Image
i set simple app. wan't hide drawer , want add boot receiver launch service. to hide application, read had remove manifest <intent-filter> <action android:name="android.intent.action.main" /> <category android:name="android.intent.category.launcher" /> </intent-filter> but when remove it, boot receiver doesn't work anymore. i added permission under manifest tag <uses-permission android:name="android.permission.receive_boot_completed" /> and receiver under application <receiver android:name="com.example.receiver.bootreceiver" > <intent-filter> <action android:name="android.intent.action.boot_completed" /> </intent-filter> </receiver> and in receiver code, there toast public class bootreceiver extends broadcastreceiver { @override public void onreceive(context context, intent intent) { toast.maketext(context,...
Read more

basic authentication with http post params android -

i doing basic authentication passing username , password , using basicnamevaluepair sending post params response service. my method: public stringbuilder callservicehttppost(string username, string password, string type) { // create new httpclient , post header httpclient httpclient = new defaulthttpclient(); httppost httppost = new httppost(webservice + type); httpresponse response = null; stringbuilder total = new stringbuilder(); try { url url = new url(webservice + type); /*string base64encodedcredentials = base64.encodetostring((username + ":" + password).getbytes(), base64.url_safe | base64.no_wrap);*/ string base64encodedcredentials = "basic " + base64.encodetostring( (username + ":" + password).getbytes(), base64.no_wrap); httppost.setheader("auth...
Read more