Hi,

I am using MySQL database and using Nhibernate to connect to database from 
my web application.  My application is hosted in Amazon server, it is 
working fine. Now to maintain Load balancing we hosted application in 
Amazon Cloud . we took separate instances for Database and  web application.

i can connect to database and execute queries using my local MySQL 
Application  and also using C# code .

var conn = "Server=xxxx.xxx-east-1.rds.amazonaws.com; Port=3306; 
Database=DBName; user=UserName; password=....";   
           
                bool result = false;
                MySqlConnection connection = new MySqlConnection(conn);
              
                    connection.Open();

                    MySqlCommand cmd = connection.CreateCommand();
                    cmd.CommandText = "SELECT * FROM ihealthuser";
                    MySqlDataAdapter da = new MySqlDataAdapter();
                    da.SelectCommand = cmd;
                    DataSet ds = new DataSet();
                    
                    da.Fill(ds);


Issue is i was unable to Execute Queries using Nhibernate. Nhibernate is 
connecting to database by creating session , showing connection status 
open, but after that it was not executing any queries. Showing Error as

"Database_Name.Table_Name  does not Exist".

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"nhibernate-development" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to nhibernate-development+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to