OracleConnectionStringBuilder.IntegratedSecurity 属性

定义

命名空间:

System.Data.OracleClient

程序集:

System.Data.OracleClient.dll

获取或设置一个值，该值指示连接中是否指定了“User ID”和“Password”（当为 false 时），或者是否使用当前的 Windows 帐户凭据进行身份验证（当为 true 时）。

public:
 property bool IntegratedSecurity { bool get(); void set(bool value); };

public bool IntegratedSecurity { get; set; }

member this.IntegratedSecurity : bool with get, set

Public Property IntegratedSecurity As Boolean

属性值

Boolean

IntegratedSecurity 属性的值；如果未提供任何值，则为 false。

示例

以下示例将现有连接字符串从使用 Windows 身份验证转换为使用集成安全性。 该示例通过以下方式来完成此工作：从连接字符串中移除用户名和密码，然后设置 IntegratedSecurity 对象的 OracleConnectionStringBuilder 属性。

注意

该示例包括一个密码以演示 OracleConnectionStringBuilder 如何使用连接字符串。 在您的应用程序中，建议使用 Windows 身份验证。 如果必须使用密码，请不要在你的应用程序中包括硬编码的密码。

// You may need to set a reference to the System.Data.OracleClient
// assembly before you can run this sample.
using System.Data.OracleClient;

class Program
{
    static void Main()
    {
        try
        {
            string connectString =
                "Data Source=OracleSample;User ID=Mary;Password=*****;";

            OracleConnectionStringBuilder builder =
                new OracleConnectionStringBuilder(connectString);
            Console.WriteLine("Original: " + builder.ConnectionString);

            // Use the Remove method
            // in order to reset the user ID and password back to their
            // default (empty string) values. Simply setting the
            // associated property values to an empty string will not
            // remove them from the connection string; you must
            // call the Remove method.
            builder.Remove("User ID");
            builder.Remove("Password");

            // Turn on integrated security.
            builder.IntegratedSecurity = true;

            Console.WriteLine("Modified: " + builder.ConnectionString);
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }

        Console.WriteLine("Press any key to finish.");
        Console.ReadLine();
    }
}

' You may need to set a reference to the System.Data.OracleClient
' assembly before you can run this example. 
Imports System.Data.OracleClient

Module Module1

  Sub Main()
    Try
      Dim connectString As String = _
       "Data Source=OracleSample;User ID=Mary;Password=*****;"

      Dim builder As New OracleConnectionStringBuilder(connectString)
      Console.WriteLine("Original: " & builder.ConnectionString)

      ' Use the Remove method
      ' in order to reset the user ID and password back to their
      ' default (empty string) values. Simply setting the 
      ' associated property values to an empty string will not
      ' remove them from the connection string; you must
      ' call the Remove method.
      builder.Remove("User ID")
      builder.Remove("Password")

      ' Turn on integrated security.
      builder.IntegratedSecurity = True

      Console.WriteLine("Modified: " & builder.ConnectionString)

    Catch ex As Exception
      Console.WriteLine(ex.Message)
    End Try

    Console.WriteLine("Press any key to finish.")
    Console.ReadLine()
  End Sub
End Module

注解

此属性对应于连接字符串中的“集成安全性”键。

另请参阅

• 生成连接字符串