ApplicationDatabaseOptions Class

Represents the database options for an application database.

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

语法

声明
Public NotInheritable Class ApplicationDatabaseOptions
    Inherits NamedSmoObject

public sealed class ApplicationDatabaseOptions : NamedSmoObject

public ref class ApplicationDatabaseOptions sealed : public NamedSmoObject

public final class ApplicationDatabaseOptions extends NamedSmoObject

public final class ApplicationDatabaseOptions extends NamedSmoObject

备注

Use the ApplicationDatabaseOptions class to configure the default filegroup and collation for the application database.

Specifying application database properties is optional. For more information about default values, see 定义应用程序数据库.

If you want to alter the application database after creating the application, use the SQL Server tools, such as SQL Server Management Studio.

Inheritance Hierarchy

System.Object
   Microsoft.SqlServer.Management.Smo.SmoObjectBase
     Microsoft.SqlServer.Management.Smo.SqlSmoObject
       Microsoft.SqlServer.Management.Smo.NamedSmoObject
        Microsoft.SqlServer.Management.Nmo.ApplicationDatabaseOptions

示例

The following examples show how to define application database options:

// Create ApplicationDatabaseOptions object
ApplicationDatabaseOptions adb = 
    new ApplicationDatabaseOptions(myApplication, "MyAppDB");

// 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 log file
ApplicationDatabaseLogFile adb_log = 
    new ApplicationDatabaseLogFile(adb, "MyApp_LogFile1");
adb_log.FileName = @"C:\NS\Full\MyApp_LogFile1.ldf";
adb_log.InitialSize = "5MB";
adb_log.MaxSize = "20MB";
adb_log.GrowthIncrement = "10%";
adb.ApplicationDatabaseLogFiles.Add(adb_log);


// Define database options
adb.CollationName = "Latin1_General_CS_AS";
adb.DefaultFileGroup = "PRIMARY";

// Assign options to ApplicationDatabaseOptions property
myApplication.ApplicationDatabaseOptions = adb;

' Create ApplicationDatabaseOptions object
Dim adb As ApplicationDatabaseOptions = _
    New ApplicationDatabaseOptions(myApplication, "MyAppDB")

' 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)

' Define and add a log file
Dim adb_log As ApplicationDatabaseLogFile = _
    New ApplicationDatabaseLogFile(adb, "MyApp_LogFile1")
adb_log.FileName = "C:\NS\Full\MyApp_LogFile1.ldf"
adb_log.InitialSize = "5MB"
adb_log.MaxSize = "20MB"
adb_log.GrowthIncrement = "10%"
adb.ApplicationDatabaseLogFiles.Add(adb_log)

' Define database options.
adb.CollationName = "Latin1_General_CS_AS"
adb.DefaultFileGroup = "PRIMARY"

' Assign options to the ApplicationDatabaseOptions property.
myApplication.ApplicationDatabaseOptions = adb

线程安全

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.

平台

开发平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

ApplicationDatabaseOptions Members
Microsoft.SqlServer.Management.Nmo Namespace

其他资源

定义应用程序数据库
CollationName Element (ADF)
DefaultFileGroup Element (ADF)