ApplicationDatabaseFileCollection.Add Method

2008-12-15

Adds an ApplicationDatabaseFile to the collection.

命名空间: Microsoft.SqlServer.Management.Nmo
程序集: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

语法

声明
Public Sub Add ( _
    applicationDatabaseFiles As ApplicationDatabaseFile _
)

public void Add (
    ApplicationDatabaseFile applicationDatabaseFiles
)

public:
void Add (
    ApplicationDatabaseFile^ applicationDatabaseFiles
)

public void Add (
    ApplicationDatabaseFile applicationDatabaseFiles
)

public function Add (
    applicationDatabaseFiles : ApplicationDatabaseFile
)

参数

applicationDatabaseFiles
The ApplicationDatabaseFile to be added.

示例

The following examples show how to define an application database file and then add it to the ApplicationDatabaseOptions object using this Add method.

// Define and add a filegroup
ApplicationDatabaseFileGroup adb_fg = 
    new ApplicationDatabaseFileGroup(adb, "PRIMARY");
adb.ApplicationDatabaseFileGroups.Add(adb_fg);

// Define and add a database file
ApplicationDatabaseFile adb_file1 = 
    new ApplicationDatabaseFile(adb_fg, "MyApp_PrimaryFile1");
adb_file1.FileName = @"C:\NS\Full\MyApp_PrimaryFile1.mdf";
adb_file1.InitialSize = "10MB";
adb_file1.MaxSize = "50MB";
adb_file1.GrowthIncrement = "10%";
adb_fg.ApplicationDatabaseFiles.Add(adb_file1);

' Define and add a filegroup
Dim adb_fg As ApplicationDatabaseFileGroup = _
    New ApplicationDatabaseFileGroup(adb, "PRIMARY")
adb.ApplicationDatabaseFileGroups.Add(adb_fg)

' Define and add a database file
Dim adb_file1 As ApplicationDatabaseFile = _
    New ApplicationDatabaseFile(adb_fg, "MyApp_PrimaryFile1")
adb_file1.FileName = "C:\NS\Full\MyApp_PrimaryFile1.mdf"
adb_file1.InitialSize = "10MB"
adb_file1.MaxSize = "50MB"
adb_file1.GrowthIncrement = "10%"
adb_fg.ApplicationDatabaseFiles.Add(adb_file1)

线程安全

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.