SqlConnectionStringBuilder.AttachDBFilename 屬性

public:
 property System::String ^ AttachDBFilename { System::String ^ get(); void set(System::String ^ value); };

public string AttachDBFilename { get; set; }

member this.AttachDBFilename : string with get, set

Public Property AttachDBFilename As String

屬性值

該房產的價值 AttachDBFilename ，或 String.Empty 是否尚未提供價值。

例外狀況

範例

以下範例建立一個新 SqlConnectionStringBuilder 實例，並設定 AttachDBFilename 屬性以指定附加資料檔案的名稱。

using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        try
        {
            string connectString =
                "Server=(local);" +
                "Integrated Security=true";
            SqlConnectionStringBuilder builder =
                new SqlConnectionStringBuilder(connectString);
            Console.WriteLine("Original: " + builder.ConnectionString);
            Console.WriteLine("AttachDBFileName={0}", builder.AttachDBFilename);

            builder.AttachDBFilename = @"C:\MyDatabase.mdf";
            Console.WriteLine("Modified: " + builder.ConnectionString);

            using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
            {
                connection.Open();
                // Now use the open connection.
                Console.WriteLine("Database = " + connection.Database);
            }
            Console.WriteLine("Press any key to finish.");
            Console.ReadLine();
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }
    }
}

Imports System.Data.SqlClient

Module Module1
    Sub Main()
        Try
            Dim connectString As String = _
             "Server=(local);" & _
             "Integrated Security=True"
            Dim builder As New SqlConnectionStringBuilder(connectString)
            Console.WriteLine("Original: " & builder.ConnectionString)
            Console.WriteLine("AttachDBFileName={0}", _
             builder.AttachDBFilename)
            builder.AttachDBFilename = "C:\MyDatabase.mdf"
            Console.WriteLine("Modified: " & builder.ConnectionString)

            Using connection As New SqlConnection(builder.ConnectionString)
                connection.Open()
                ' Now use the open connection.
                Console.WriteLine("Database = " & connection.Database)
            End Using

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

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

備註

此屬性對應於 連接字串 中的「AttachDBFilename」、「extended properties」及「initial file name」鍵。

AttachDBFilename 僅支援副檔名為 .mdf 的主要資料檔案。

若與資料檔案同目錄中有日誌檔，且附加主資料檔時使用「database」關鍵字，則會產生錯誤。 在這種情況下，移除日誌檔案。 資料庫連接後，會根據實體路徑自動產生新的日誌檔。

另請參閱

• ADO.NET 中的連接字串
• ADO.NET 概觀