取得connectionStrings属性

取得Web config文件连接数据库字符各个属性。

代码

  public   string  GetConnectionValue( string  Keyword, string  connectionString)
        {
             string [] aa  =  Keyword.Split( ' , ' );           
             string [] bb  =  connectionString.Split( ' ; ' );
             string  strTempValue  =   string .Empty;
             foreach  ( string  b  in  bb)
            {
                 foreach  ( string  a  in  aa)
                {
                     if  (b.IndexOf( " = " )  <   0 )  continue ;  
                     if  (b.StartsWith(a, StringComparison.OrdinalIgnoreCase))
                        strTempValue  =  b.Substring(b.IndexOf( " = " )  +   1 );
                }
            }
             return  strTempValue;
        }

 

代码

         public   string  GetServerName()
        {
             string  key  =   " Data Source,Server,Address,Addr,Network Address " ;
             return  GetConnectionValue(key);
        }

         public   string  GetDataBaseName()
        {
             string  key  =   " Initial Catalog,Database " ;
             return  GetConnectionValue(key);
        }

         public   string  GetPassword()
        {
             string  key  =   " Password,Pwd " ;
             return  GetConnectionValue(key);
        }

         public   string  GetUserId()
        {
             string  key  =   " User ID,uid " ;
             return  GetConnectionValue(key);
        }

         public   string  GetPacketSize()
        {
             string  key  =   " Packet Size " ;
             return  GetConnectionValue(key);
        }

         public   string  GetPooling()
        {
             string  key  =   " Pooling " ;
             return  GetConnectionValue(key);
        }

         public   string  GetMaxPoolSize()
        {
             string  key  =   " Max Pool Size " ;
             return  GetConnectionValue(key);
        }

         public   string  GetTrustedSecurity()
        {
             string  key  =   " Integrated Security,Trusted_Connection " ;
             return  GetConnectionValue(key);
        }

         public   bool  IsTrustedSecurityConnection()
        {
             string  sScty  =  GetTrustedSecurity();
             return  (sScty  ==   " SSPI "   ||  sScty  ==   " True " );
        }

         public   bool  IsAtLocalMachine()
        {
             string  sName  =  GetServerName();
             return  (sName  ==   " 127.0.0.1 "   ||  sName  ==   " localhost " );
        }