ApplicationDatabaseOptions Class
Represents the database options for an application database.
Espace de noms: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntaxe
'Déclaration
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
Notes
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 Définition de la base de données d'application.
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
Exemple
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
Sécurité des threads
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.
Plateformes
Plateformes de développement
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.
Plateformes cibles
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.
Voir aussi
Référence
ApplicationDatabaseOptions Members
Microsoft.SqlServer.Management.Nmo Namespace
Autres ressources
Définition de la base de données d'application
CollationName Element (ADF)
DefaultFileGroup Element (ADF)