/// <summary> /// Run lynx.store_clr_dlls. /// </summary> public void RunClrDll() { try { Console.WriteLine("Running lynx.store_clr_dlls ..."); OracleAccessor oc = new OracleAccessor(); oc.ConnectToOracle(); oc.Transaction = oc.Connection.BeginTransaction(); OracleProcedureInput pic = new OracleProcedureInput(); pic.numberOfParameters = 0; pic.procedureName = "lynx.store_clr_dlls"; oc.NonQueryProcedure(pic); oc.Transaction.Commit(); oc.Connection.Close(); Console.WriteLine("Finished lynx.store_clr_dlls."); } catch (Exception e) { Console.WriteLine(e.Message); Console.WriteLine("lynx.store_clr_dlls Failed!"); } }
public MainViewModel(IWindowManager manager) { _manager = manager; _accessor = null; Connected = false; QueryTab = new QueryViewModel(_manager, this); QueryTab.RequireUpdate += UpdateHandler; Browser = new TableBrowserViewModel(_manager, this); Browser.RequireUpdate += UpdateHandler; }
public void LogIn( ) { try { Accessor = new OracleAccessor(DataSource, UserName, Password, Tablespace); } catch (Exception e) { MessageBox.Show(e.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); } TryClose( ); }
/// <summary> /// Test if the xml file is setup correctly for a database connection. /// </summary> static void TestDbConnection(string UserId, string Password, string Privilege) { Console.WriteLine("Testing Database Connection..."); try { OracleAccessor oc = new OracleAccessor(); oc.ConnectToOracle(UserId, Password, Privilege); oc.Connection.Close(); } catch { } }
public void LogIn( ) { AuthorizationViewModel authorization = new AuthorizationViewModel( ) { DisplayName = "Authorization" }; _manager.ShowDialog(authorization); _accessor = authorization.Accessor; if (_accessor != null) { Connected = true; } }
public static DbAccessor NewDbAccessor(string connectionString, string providerName) { DbAccessor dba = null; if (string.IsNullOrEmpty(providerName) || providerName == "System.Data.SqlClient" || providerName.ToLower() == DbProviderName.SqlServer.ToString().ToLower()) { dba = new SqlServerAccessor(connectionString); EvnValService.SetDbAccessorDbProviderName(dba, DbProviderName.SqlServer); } else if (providerName.ToLower() == DbProviderName.Oracle.ToString().ToLower()) { dba = new OracleAccessor(connectionString); EvnValService.SetDbAccessorDbProviderName(dba, DbProviderName.Oracle); } else if (providerName.ToLower() == DbProviderName.MySql.ToString().ToLower()) { dba = new MySqlAccessor(connectionString); EvnValService.SetDbAccessorDbProviderName(dba, DbProviderName.MySql); } else { Type tProviderName = Type.GetType(providerName); if (tProviderName == null) { throw new Exception(string.Format("ConnectionString({0})的ProviderName({1})找不到该类型!", connectionString, providerName)); } else if (!(tProviderName.IsSubclassOf(typeof(DbAccessor)))) { throw new Exception(string.Format("ConnectionString({0})的ProviderName({1})该类型不是DbAccessor的实现类!", connectionString, providerName)); } object oProviderName = Activator.CreateInstance(tProviderName, connectionString); dba = oProviderName as DbAccessor; } return(dba); }
public static void Main( ) { OracleConnectionStringBuilder builder = new OracleConnectionStringBuilder( ); builder.DataSource = @"10.4.0.119"; builder.Password = @"123456"; builder.UserID = @"12201"; builder.PersistSecurityInfo = true; using (OracleAccessor connector = new OracleAccessor("10.4.0.119", "12201", "123456", "USERS")) { using (var dataReader = connector.GetTableInfo("ROGOLEV_GOODS")) { //while ( dataReader.Read( ) ) //{ // string str = dataReader.GetString( dataReader.GetOrdinal( "table_name" ) ); // Console.WriteLine( dataReader[0].ToString( ) ); //} foreach (DbDataRecord row in dataReader) { for (int i = 0; i < row.FieldCount; ++i) { Console.WriteLine(row.GetValue(i)); } } } } //using ( OracleConnection connection = new OracleConnection( builder.ToString( ) ) ) //{ // connection.Open( ); // using ( OracleCommand command = connection.CreateCommand( ) ) // { // command.CommandText = @"select * from all_tables"; // DataTable table = connection.GetSchema( @"foreignKeyColumns" ); // foreach ( DataRow row in table.Rows ) // { // if ( !row["TABLE_NAME"].ToString( ).Contains( "ROGOLEV" ) ) // continue; // foreach ( DataColumn column in table.Columns ) // Console.WriteLine( "{0} = {1}", column.ColumnName, row[column] ); // Console.WriteLine( ); // } // //using ( var dataReader = command.ExecuteReader( ) ) // //{ // // while ( dataReader.Read( ) ) // // { // // string str = dataReader.GetString( dataReader.GetOrdinal( "table_name" ) ); // // //try // // //{ // // // str += " " + dataReader.GetString( dataReader.GetOrdinal( "tablespace_name" ) ); // // //} // // //catch ( InvalidCastException e ) // // //{ // // // str += " null"; // // //} // // Console.WriteLine( dataReader[0].ToString( ) ); // // } // //} // } //} // using ( dataReader ) // { // while ( dataReader.Read( ) ) // { // string str = dataReader.GetString( dataReader.GetOrdinal( "table_name" ) ); // //try // //{ // // str += " " + dataReader.GetString( dataReader.GetOrdinal( "tablespace_name" ) ); // //} // //catch ( InvalidCastException e ) // //{ // // str += " null"; // //} // Console.WriteLine( dataReader[0].ToString( ) ); // } // } //} Console.ReadKey( ); }
public AuthorizationViewModel( ) { DataSource = "10.4.0.119"; UserName = "******"; Accessor = null; }
public void LogOut( ) { _accessor.Dispose( ); _accessor = null; Connected = false; }