public static System.Data.DataTable LoadDataStoreConfigurationSetting(string name = DataStore.DATA_STORE_CONFIG_TBLNAME)
        {
            if (string.IsNullOrWhiteSpace(name))
            {
                throw new System.ArgumentException($"{nameof( name )} is null, empty or whitespaces only.", nameof(name));
            }
            DataPhilosophiaeSection dps = System.Configuration.ConfigurationManager.GetSection(nameof(DataPhilosophiaeSection)) as DataPhilosophiaeSection;

            System.Configuration.ConnectionStringSettingsCollection css = System.Configuration.ConfigurationManager.ConnectionStrings;
            if (dps == null)
            {
                throw new System.Exception("[DataPhilosophiaeSection] section missing in app.config!!!");
            }
            if (css == null)
            {
                throw new System.Exception("[connectionStrings] section missing in app.config!!!");
            }
            System.Data.DataTable tbl = DataStore.CreateDataStoreConfigTable(name);
            {
                foreach (DataStoreElement dse in dps.DataStores)
                {
                    System.Configuration.ConnectionStringSettings cs = css[dse.ConnectionStringName];
                    DataStore ds = new DataStore(dps, dse, cs);
                    tbl.Rows.Add(ds.GetAsDataRow(tbl.NewRow( )));
                    f(ds);
                }
            }
            return(tbl);
        }
Пример #2
0
        private static void LoadDataStoreTable(string name)
        {
            if (string.IsNullOrWhiteSpace(name))
            {
                throw new System.ArgumentException($"{nameof( name )} is null, empty or whitespaces only.", nameof(name));
            }

            DataPhilosophiaeSection dps = System.Configuration.ConfigurationManager.GetSection(nameof(DataPhilosophiaeSection)) as DataPhilosophiaeSection;

            System.Configuration.ConnectionStringSettingsCollection css = System.Configuration.ConfigurationManager.ConnectionStrings;
            if (dps == null)
            {
                throw new System.Exception("[DataPhilosophiaeSection] section missing in app.config!!!");
            }
            if (css == null)
            {
                throw new System.Exception("[connectionStrings] section missing in app.config!!!");
            }
            System.Data.DataTable dscTbl = MyDataSet.Tables[name];
            foreach (DataStoreElement dse in dps.DataStores)
            {
                System.Configuration.ConnectionStringSettings cs = css[dse.ConnectionStringName];
                DataStore ds = new DataStore(dps, dse, cs);
                dscTbl.Rows.Add(ds.GetAsDataRow(dscTbl.NewRow( )));
            }
        }
Пример #3
0
        public static System.Configuration.ConnectionStringSettingsCollection GetAllConnectionStrings()
        {
            System.Configuration.ConnectionStringSettingsCollection objConns = new System.Configuration.ConnectionStringSettingsCollection();

            #region Get Suffix From MachineName
            string strSuffix = String.Empty;

            if (PickConnectionByDevLiveStage)
                strSuffix = "_" + General.Environment.Current.WhereAmI().ToString().ToLower();
            #endregion

            if (GlobalConfiguration.GetFromAppConfig)
            {
                foreach (System.Configuration.ConnectionStringSettings objConnString in System.Configuration.ConfigurationManager.ConnectionStrings)
                {
                    if (PickConnectionByDevLiveStage)
                    {
                        if (objConnString.Name.EndsWith(strSuffix))
                            objConns.Add(objConnString);
                    }
                    else
                    {
                        objConns.Add(objConnString);
                    }
                }

            }

            return objConns;
        }
Пример #4
0
 private SessionManagement()
 {
     try
     {
         string ConnectionName = "connection.connection_string";
         System.Configuration.ConnectionStringSettingsCollection configs = System.Configuration.ConfigurationManager.ConnectionStrings;
         List <string> dblist = new List <string>(Enum.GetNames(typeof(JDB.Database)));
         for (int i = 0; i < configs.Count; i++)
         {
             if (dblist.Contains(configs[i].Name))
             {
                 string ConnectionValue = System.Configuration.ConfigurationManager.ConnectionStrings[configs[i].Name].ToString();
                 foreach (var item in ConnectionValue.Split(';'))
                 {
                     if (item.StartsWith("PWD=") || item.StartsWith("UID="))
                     {
                         ConnectionValue = ConnectionValue.Replace(item.Substring(4), EncodeAndDecodeHelper.PasswordDecryption(item.Substring(4)));
                     }
                 }
                 Configuration config = new Configuration();
                 config.SetProperty(ConnectionName, ConnectionValue);
                 config.Configure();
                 _Factorys.Add(configs[i].Name, config.BuildSessionFactory());
             }
         }
     }
     catch (HibernateConfigException ex)
     {
         throw ex;
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 private void backgroundWorker_DoWork(object sender, DoWorkEventArgs e)
 {
     e.Cancel = true;
     this.backgroundWorker.ReportProgress(0);
     if (!this.backgroundWorker.CancellationPending)
     {
         System.Configuration.ConnectionStringSettingsCollection css  = System.Configuration.ConfigurationManager.ConnectionStrings;
         System.Collections.Generic.List <ConnectionString>      list = new System.Collections.Generic.List <ConnectionString>( );
         if (css != null)
         {
             for (int i = 0; i < css.Count; i++)
             {
                 if (!this.backgroundWorker.CancellationPending)
                 {
                     ConnectionString o = new ConnectionString( )
                     {
                         Name         = css[i].Name,
                         ProviderName = css[i].ProviderName,
                         String       = css[i].ConnectionString
                     };
                     list.Add(o);
                     int value = (i + 1) * (100 / css.Count);
                     this.backgroundWorker.ReportProgress(value, css.Count);
                 }
                 else
                 {
                     this.backgroundWorker.ReportProgress(0);
                     return;
                 }
             }
             e.Result = list;
             e.Cancel = false;
         }
     }
 }
Пример #6
0
        } // End Function BatchedInsert

        public static string GetConnectionString()
        {
            string strReturnValue = null;

            if (string.IsNullOrEmpty(m_staticConnectionString))
            {
                string strConnectionStringName = System.Environment.MachineName;

                if (string.IsNullOrEmpty(strConnectionStringName))
                {
                    strConnectionStringName = "LocalSqlServer";
                }

                System.Configuration.ConnectionStringSettingsCollection settings = System.Configuration.ConfigurationManager.ConnectionStrings;
                if ((settings != null))
                {
                    foreach (System.Configuration.ConnectionStringSettings cs in settings)
                    {
                        if (System.StringComparer.OrdinalIgnoreCase.Equals(cs.Name, strConnectionStringName))
                        {
                            strReturnValue           = cs.ConnectionString;
                            m_staticConnectionString = strReturnValue;
                            m_DataProvider           = cs.ProviderName;
                            break; // TODO: might not be correct. Was : Exit For
                        }
                    }
                }

                if (string.IsNullOrEmpty(strReturnValue))
                {
                    strConnectionStringName = "server";

                    System.Configuration.ConnectionStringSettings conString = System.Configuration.ConfigurationManager.ConnectionStrings[strConnectionStringName];

                    if (conString != null)
                    {
                        strReturnValue = conString.ConnectionString;
                    }
                }

                if (string.IsNullOrEmpty(strReturnValue))
                {
                    throw new System.ArgumentNullException("ConnectionString \"" + strConnectionStringName + "\" in file web.config.");
                }

                settings = null;
                strConnectionStringName = null;
            }
            else // of if (string.IsNullOrEmpty(strStaticConnectionString))
            {
                return(m_staticConnectionString);
            }

            return(strReturnValue);
        } // End Function GetConnectionString
Пример #7
0
 public string GetConnectionString(string _connectionStringsName)
 {
     System.Configuration.ConnectionStringSettingsCollection config = System.Configuration.ConfigurationManager.ConnectionStrings;
     for (int i = 0; i < config.Count; i++)
     {
         if (config[i].Name.Equals(_connectionStringsName, StringComparison.OrdinalIgnoreCase))
         {
             return(config[i].ToString());
         }
     }
     return(String.Empty);
 }
Пример #8
0
        /// <summary>
        /// 取得ConnectionStrings节点的配置
        /// </summary>
        /// <param name="key"></param>
        /// <returns></returns>
        public static string GetConnectionString(string key)
        {
            string returnVal = "";

            System.Configuration.ConnectionStringSettingsCollection connectionStrings = System.Configuration.ConfigurationManager.ConnectionStrings;
            if (null != connectionStrings[key])
            {
                returnVal = connectionStrings[key].ConnectionString;
            }
            connectionStrings = null;
            return(returnVal);
        }
        public DataCatalog()
        {
            ConfigurationSetting.DataPhilosophiaeSection            dps = System.Configuration.ConfigurationManager.GetSection("DataPhilosophiaeSection") as ConfigurationSetting.DataPhilosophiaeSection;
            System.Configuration.ConnectionStringSettingsCollection css = System.Configuration.ConfigurationManager.ConnectionStrings;
            if (dps == null)
            {
                throw new System.Exception("[DataPhilosophiaeSection] section missing in app.config!!!");
            }
            if (css == null)
            {
                throw new System.Exception("[connectionStrings] section missing in app.config!!!");
            }
            int i = 0;

            foreach (ConfigurationSetting.DataStoreElement dse in dps.DataStores)
            {
                System.Configuration.ConnectionStringSettings cs = css[dse.ConnectionStringName];
                {
                    System.Data.DataRow r = this.ds.NewRow( );
                    //r[ "ID" ] = i++;
                    r["Name"] = dse.Name;
                    r["ConnectionStringName"]    = dse.ConnectionStringName;
                    r["LoadDefaultDatabaseOnly"] = dse.LoadDefaultDatabaseOnly == 1 ? true : false;
                    r["LoadSystemObjects"]       = dse.LoadSystemObjects == 1 ? true : false;
                    r["WithFields"]   = dse.WithFields == 1 ? true : false;
                    r["StagePathDir"] = string.IsNullOrWhiteSpace(dse.PathDir)
               ? System.IO.Path.Combine(dps.Stage.PathDir, dse.Name)
               : dse.PathDir;
                    r["ConnectionString"] = cs != null ? cs.ConnectionString : null;
                    r["ProviderName"]     = cs != null ? cs.ProviderName : null;
                    //
                    System.IO.DirectoryInfo di = new System.IO.DirectoryInfo((string)r["StagePathDir"]);
                    r["IsValidStagePathDir"] = di.Exists;
                    r["IsValidProviderName"] = !string.IsNullOrWhiteSpace(cs != null ? cs.ProviderName : null);
                    //
                    this.ds.Rows.Add(r);
                    //
                    if (di.Exists)
                    {
                        System.IO.FileInfo[] files = di.GetFiles("*.aqb.config", System.IO.SearchOption.AllDirectories);
                        foreach (System.IO.FileInfo fi in files)
                        {
                            System.Data.DataRow rr = this.dss.NewRow( );
                            rr["Name"]         = dse.Name;
                            rr["IsActive"]     = false;
                            rr["SnapshotFile"] = fi.Name;
                            this.dss.Rows.Add(rr);
                        }
                    }
                }
            }
        }
Пример #10
0
        static string GetConnectionStrings()
        {
            System.Configuration.ConnectionStringSettingsCollection settings =
                System.Configuration.ConfigurationManager.ConnectionStrings;
            string con = "";

            if (settings != null)
            {
                con = System.Configuration.ConfigurationManager.ConnectionStrings["proveedores2ConnectionString"].ConnectionString;
                //con = settings[1].ConnectionString;
            }
            return(con);
        }
Пример #11
0
        public ClientConnection()
        {
            InitializeComponent();
            DataTable factories = System.Data.Common.DbProviderFactories.GetFactoryClasses();

            this.comboProvider.DataSource = factories.DefaultView;

            System.Configuration.ConnectionStringSettingsCollection constrings = System.Configuration.ConfigurationManager.ConnectionStrings;

            foreach (System.Configuration.ConnectionStringSettings constr in constrings)
            {
                this.comboConfig.Items.Add(constr.Name);
            }
        }
Пример #12
0
        static void GetConnectionStrings()
        {
            /*
             * Файл System.Configuration.dll не включается в проекты всех типов,
             * поэтому для использования классов конфигурации требуется добавить на него ссылку
             */
            Console.WriteLine("\nСписок всех строк соединения:");
            System.Configuration.ConnectionStringSettingsCollection settings =
                System.Configuration.ConfigurationManager.ConnectionStrings;

            if (settings != null)
            {
                foreach (System.Configuration.ConnectionStringSettings cs in settings)
                {
                    Console.WriteLine("___");
                    Console.WriteLine(cs.Name);
                    Console.WriteLine(cs.ProviderName);
                    Console.WriteLine(cs.ConnectionString);
                }
            }
        }
Пример #13
0
        public virtual string GetConnectionString(string initialCatalog)
        {
            string strReturnValue  = null;
            string strProviderName = null;


            if (initialCatalog == null && !string.IsNullOrEmpty(this.m_ConnectionString))
            {
                return(this.m_ConnectionString);
            }


            if (initialCatalog != null && !string.IsNullOrEmpty(this.m_ConnectionString))
            {
                System.Data.Common.DbConnectionStringBuilder sb = this.m_ProviderFactory.CreateConnectionStringBuilder();
                sb.ConnectionString = this.m_ConnectionString;
                sb["Database"]      = initialCatalog;
                strReturnValue      = sb.ConnectionString;
                sb = null;
                return(strReturnValue);
            }


            string strConnectionStringName = System.Environment.MachineName;

            if (string.IsNullOrEmpty(strConnectionStringName))
            {
                strConnectionStringName = "LocalSqlServer";
            }

            System.Configuration.ConnectionStringSettingsCollection settings = System.Configuration.ConfigurationManager.ConnectionStrings;
            if ((settings != null))
            {
                foreach (System.Configuration.ConnectionStringSettings cs in settings)
                {
                    if (System.StringComparer.OrdinalIgnoreCase.Equals(cs.Name, strConnectionStringName))
                    {
                        strReturnValue  = cs.ConnectionString;
                        strProviderName = cs.ProviderName;
                        break; // TODO: might not be correct. Was : Exit For
                    } // End if (System.StringComparer.OrdinalIgnoreCase.Equals(cs.Name, strConnectionStringName))
                } // Next cs
            } // End if ((settings != null))

            if (string.IsNullOrEmpty(strReturnValue))
            {
                strConnectionStringName = "server";

                System.Configuration.ConnectionStringSettings conString = System.Configuration.ConfigurationManager.ConnectionStrings[strConnectionStringName];

                if (conString != null)
                {
                    strReturnValue = conString.ConnectionString;
                } // End if (conString != null)
            }     // End if (string.IsNullOrEmpty(strReturnValue))

            if (string.IsNullOrEmpty(strReturnValue))
            {
                throw new System.ArgumentNullException("No connectionString \"" + strConnectionStringName + "\" in file web.config.");
            } // End if (string.IsNullOrEmpty(strReturnValue))

            settings = null;
            strConnectionStringName = null;

            // Got value from web.config at this point
            {
                System.Data.Common.DbConnectionStringBuilder sb = this.m_ProviderFactory.CreateConnectionStringBuilder();
                sb.ConnectionString = strReturnValue;


                if (string.IsNullOrEmpty(this.m_ConnectionString))
                {
                    if (!System.Convert.ToBoolean(sb["Integrated Security"]))
                    {
                        sb["Password"] = Cryptography.DES.DeCrypt(System.Convert.ToString(sb["Password"]));
                    }
                    strReturnValue          = sb.ConnectionString;
                    this.m_ConnectionString = strReturnValue;
                } // End if (string.IsNullOrEmpty(this.m_ConnectionString))

                if (!string.IsNullOrEmpty(initialCatalog))
                {
                    sb["Database"] = initialCatalog;
                    strReturnValue = sb.ConnectionString;
                }

                sb = null;
            }

            return(strReturnValue);
        } // End Function GetConnectionString
Пример #14
0
        private static void LoadConfiguration()
        {
            //
            // [Configuration files] are used to control and manage the behavior of a [desktop and web application].
            //
            //    [Machine.config] : [machine level configuration file]
            //    This is automatically installed when you install Visual Studio.Net. Only one [Machine.config] file exists on
            //    a server. This file is at the highest level in the configuration hierarchy.
            //
            //    [App.config] : [application level configuration file]
            //    This is automatically created when you create a [Desktop application] project. This file inherits setting
            //    from the [Machine.config]
            //
            //    [Web.config] : [web application level configuration file]
            //    This is automatically created when you create an [ASP.Net web application] project. This file inherits setting
            //    from the [Machine.config]
            //
            //    Difference between [(App|Web).config] and [Machine.config]:
            //
            //    The settings made in the [(App|Web).config] file are applied to that particular desktop/web application only,
            //    whereas the settings of [Machine.config] file are applied to the ALL Desktop or whole ASP.net application.
            //
            //    [(App|Web).config] file are settings of desktop/asp.net application project level. [Machine.config] are settings
            //    of server level.
            //
            //    [(App|Web).config] will be for that particular desktop/web application whereas the [Machine.config] will for
            //    the whole machine.
            //
            //    Every Desktop/ASP.NET application that you has a [(App|Web).config] file . The settings specified in this will
            //    imply only to that application. Whereas "Your System" will have a [Machine.config] file in folder:
            //    [[ Microsoft.NET\Framework\v1.1.4322\CONFIG ]]
            //    which contains specifications and settings at a system level.
            //
            //    [Web.config] file is to override the settings from the [Machine.config] file. [Machine.config] file settings are
            //    applied to all the web applications residing on the server while [Web.config] settings are application specific.
            //
            //    [Machine.config] is configuration file for all the application in the IIS. but [Web.config] is a configuration
            //    file for a application or folder.
            //
            //    [Machine.config] for machine level configuration.but [Web.config] for a application/folder level configuration.
            //
            // Add reference to : System.Configuration and System.ComponentModel.DataAnnotations
            //
            {
                // #1 WAY (App.config + Machine.config)
                System.Configuration.ConnectionStringSettingsCollection css = System.Configuration.ConfigurationManager.ConnectionStrings;
            }
            {
                // #2 WAY (App.config + Machine.config)
                string str = System.Configuration.ConfigurationManager.AppSettings["UrlToPing"].ToString( );
            }
            {
                // #3 WAY (App.config + Machine.config)
                DataPhilosophiaeSection dps = System.Configuration.ConfigurationManager.GetSection(nameof(DataPhilosophiaeSection)) as DataPhilosophiaeSection;
            }
            {
                // #4 WAY (Proprietary File)
                string configFilePath         = @"D:\TEMP\CS\";
                string configFileName         = @"dsConfig.xml";
                string configFileFullPathName = Path.Combine(configFilePath, configFileName);;
                {
                    XDocument dsCfgSample = DataStoreConfig.Sample( );
                    dsCfgSample.Save(configFileFullPathName, SaveOptions.None);
                }
                XDocument       xDoc  = XDocument.Load(configFileFullPathName, LoadOptions.None);
                DataStoreConfig dsCfg = DataStoreConfig.Deserialize(xDoc);
            }
            {
                //RegistryKey key = Registry.LocalMachine.OpenSubKey( "Software", true );
                //RegistryKey key = Registry.CurrentUser.OpenSubKey( "Software", true );

                //key.CreateSubKey( "AppName" );
                //key = key.OpenSubKey( "AppName", true );


                //key.CreateSubKey( "AppVersion" );
                //key = key.OpenSubKey( "AppVersion", true );

                //key.SetValue( "yourkey", "yourvalue" );
            }
        }
Пример #15
0
        public static void LoadDataStoreSnapshotFilesTable(System.Data.DataSet ds)
        {
            DataPhilosophiaeSection dps = System.Configuration.ConfigurationManager.GetSection("DataPhilosophiaeSection") as DataPhilosophiaeSection;

            System.Configuration.ConnectionStringSettingsCollection css = System.Configuration.ConfigurationManager.ConnectionStrings;
            if (dps == null)
            {
                throw new System.Exception("[DataPhilosophiaeSection] section missing in app.config!!!");
            }
            if (css == null)
            {
                throw new System.Exception("[connectionStrings] section missing in app.config!!!");
            }
            int       iii      = 0;
            DataTable dscTbl   = ds.Tables[DataStoreConfig_TblName];
            DataTable dsssfTbl = ds.Tables[DataStoreSnapshotFile_TblName];

            foreach (DataStoreElement dse in dps.DataStores)
            {
                System.Configuration.ConnectionStringSettings cs = css[dse.ConnectionStringName];
                {
                    System.Data.DataRow r = dscTbl.NewRow( );
                    //r[ "ID" ] = i++;
                    r["Name"] = dse.Name;
                    r["ConnectionStringName"]    = dse.ConnectionStringName;
                    r["LoadDefaultDatabaseOnly"] = dse.LoadDefaultDatabaseOnly == 1 ? true : false;
                    r["LoadSystemObjects"]       = dse.LoadSystemObjects == 1 ? true : false;
                    r["WithFields"]   = dse.WithFields == 1 ? true : false;
                    r["StagePathDir"] = string.IsNullOrWhiteSpace(dse.PathDir)
               ? System.IO.Path.Combine(dps.Stage.PathDir, dse.Name)
               : dse.PathDir;
                    r["ConnectionString"] = cs != null ? cs.ConnectionString : null;
                    r["ProviderName"]     = cs != null ? cs.ProviderName : null;
                    //
                    System.IO.DirectoryInfo di = new System.IO.DirectoryInfo((string)r["StagePathDir"]);
                    r[IsValidStagePathDir_ColName] = di.Exists;
                    r["IsValidProviderName"]       = !string.IsNullOrWhiteSpace(cs != null ? cs.ProviderName : null);
                    //
                    dscTbl.Rows.Add(r);
                    //
                    if (di.Exists)
                    {
                        System.IO.FileInfo[] files = GetFiles(di);
                        int ii = 0;
                        for (int i = 0; i < files.Length; i++)
                        {
                            System.Data.DataRow rr = dsssfTbl.NewRow( );
                            rr["Name"]             = dse.Name;
                            rr["IsActive"]         = false;
                            rr["LastWriteTimeUtc"] = files[i].LastWriteTimeUtc;
                            if (files[i].LastWriteTimeUtc > files[ii].LastWriteTimeUtc)
                            {
                                ii = i;
                            }
                            rr["SnapshotFile"] = files[i];
                            dsssfTbl.Rows.Add(rr);
                        }
                        if (files.Length > 0)
                        {
                            dsssfTbl.Rows[iii + ii]["IsActive"] = true;
                        }
                        iii += files.Length;
                    }
                }
            }
        }
Пример #16
0
        static void Main()
        {
            try
            {
                DataPhilosophiaeSection dps = cm.GetSection("DataPhilosophiaeSection") as DataPhilosophiaeSection;
                if (dps != null)
                {
                    System.Console.WriteLine(dps.Stage.PathDir);
                    foreach (DataStoreElement ds in dps.DataStores)
                    {
                        System.Console.WriteLine(ds.Name);
                        System.Console.WriteLine(ds.LoadDefaultDatabaseOnly);
                        System.Console.WriteLine(ds.LoadSystemObjects);
                        System.Console.WriteLine(ds.WithFields);
                        if (string.IsNullOrWhiteSpace(ds.PathDir))
                        {
                            ds.PathDir = System.IO.Path.Combine(dps.Stage.PathDir, ds.Name);
                            cm.Save(System.Configuration.ConfigurationSaveMode.Minimal, true);
                        }
                        System.Console.WriteLine(ds.PathDir);
                    }
                }
                //DataStoreElement dse = new DataStoreElement(  );
                //cm.Save( System.Configuration.ConfigurationSaveMode.Minimal, false );
            }
            catch (System.Configuration.ConfigurationErrorsException ex)
            {
                System.Console.WriteLine(ex.Message);
            }
            try
            {
                System.Configuration.ConnectionStringSettingsCollection settings = System.Configuration.ConfigurationManager.ConnectionStrings;
                if (settings != null)
                {
                    foreach (System.Configuration.ConnectionStringSettings cs in settings)
                    {
                        System.Console.WriteLine("            Name:" + cs.Name);
                        System.Console.WriteLine("    ProviderName:" + cs.ProviderName);
                        System.Console.WriteLine("ConnectionString:" + cs.ConnectionString);
                    }
                }
            }
            catch (System.Configuration.ConfigurationErrorsException ex)
            {
                System.Console.WriteLine(ex.Message);
            }
            {
                DataPhilosophiaeSection dps = cm.GetSection("DataPhilosophiaeSection") as DataPhilosophiaeSection;
                DataStoreElement        ds  = dps.DataStores[0];
                System.Configuration.ConnectionStringSettingsCollection settings = System.Configuration.ConfigurationManager.ConnectionStrings;
                System.Configuration.ConnectionStringSettings           cs       = settings[ds.ConnectionStringName];
                //

                ActiveQueryBuilder.Core.SyntaxProviderList syntaxProviderList = new ActiveQueryBuilder.Core.SyntaxProviderList( );
                ActiveQueryBuilder.Core.SQLContext         sc = new ActiveQueryBuilder.Core.SQLContext( )
                {
                    SyntaxProvider   = new ActiveQueryBuilder.Core.AutoSyntaxProvider( ),
                    MetadataProvider = new ActiveQueryBuilder.Core.OLEDBMetadataProvider
                    {
                        Connection = new System.Data.OleDb.OleDbConnection( )
                        {
                            ConnectionString = cs.ConnectionString
                        }
                    }
                };
            }
            {
                DataPhilosophiaeSection dps = cm.GetSection("DataPhilosophiaeSection") as DataPhilosophiaeSection;
                DataStoreElement        ds  = dps.DataStores[0];
                System.Configuration.ConnectionStringSettingsCollection settings = System.Configuration.ConfigurationManager.ConnectionStrings;
                System.Configuration.ConnectionStringSettings           cs       = settings[ds.ConnectionStringName];
                //
                ActiveQueryBuilder.Core.SyntaxProviderList syntaxProviderList = new ActiveQueryBuilder.Core.SyntaxProviderList( );
                ActiveQueryBuilder.Core.SQLContext         sc = new ActiveQueryBuilder.Core.SQLContext( )
                {
                    SyntaxProvider   = new ActiveQueryBuilder.Core.SQLiteSyntaxProvider( ),
                    MetadataProvider = new ActiveQueryBuilder.Core.SQLiteMetadataProvider( )
                    {
                        Connection = new System.Data.SQLite.SQLiteConnection( )
                        {
                            ConnectionString = cs.ConnectionString
                        }
                    }
                };
                ActiveQueryBuilder.Core.MetadataLoadingOptions loadingOptions = sc.MetadataContainer.LoadingOptions;
                loadingOptions.LoadDefaultDatabaseOnly = ds.LoadDefaultDatabaseOnly == 1 ? true : false;
                loadingOptions.LoadSystemObjects       = ds.LoadSystemObjects == 1 ? true : false;
                //loadingOptions.IncludeFilter.Types = MetadataType.Field;
                //loadingOptions.ExcludeFilter.Schemas.Add(“dbo”);
                sc.MetadataContainer.LoadAll(ds.WithFields == 1 ? true : false);
            }

            //TunnelSection ts = System.Configuration.ConfigurationManager.GetSection( "TunnelSection" ) as TunnelSection;
            TunnelSection       ts                = cm.GetSection("TunnelSection") as TunnelSection;
            int                 count1            = ts.Tunnels.Count;
            HostConfigElement   hc                = ts.Tunnels[0];
            string              sSHServerHostname = hc.SSHServerHostname;
            string              username          = hc.Username;
            TunnelCollection    tunnels           = hc.Tunnels;
            int                 count2            = tunnels.Count;
            TunnelConfigElement tce               = tunnels[0];
            string              name              = tce.Name;
            int                 localPort         = tce.LocalPort;

            //ProductSettings productSettings = System.Configuration.ConfigurationManager.GetSection( "ProductSettings" ) as ProductSettings;
            //ConfigurationClassLoader x = System.Configuration.ConfigurationManager.GetSection( "Plugins" ) as ConfigurationClassLoader;

            //
            System.Configuration.ConfigurationSectionGroup      a        = cm.GetSectionGroup("DataStoreGroup");
            System.Configuration.ConfigurationSectionCollection sections = a.Sections;
            int count = sections.Count;

            System.Configuration.ConfigurationSection get = sections.Get(0);

            //         NewMethod( );
            //
            System.Windows.Forms.Application.EnableVisualStyles( );
            System.Windows.Forms.Application.SetCompatibleTextRenderingDefault(false);
            System.Windows.Forms.Application.Run(new Form1( ));
        }
Пример #17
0
 private static string GetConnectionString()
 {
     System.Configuration.ConnectionStringSettingsCollection cssc = System.Configuration.ConfigurationManager.ConnectionStrings;
     return(cssc["Micajah.Common.ConnectionString"].ConnectionString);
 }