FileGroup-Konstruktor (Database, String, Boolean)
Initialisiert eine neue Instanz der FileGroup-Klasse für die angegebene Datenbank unter Verwendung des angegebenen Namens. Optional kann eine FILESTREAM-Dateigruppe erstellt werden.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Sub New ( _
database As Database, _
name As String, _
isFileStream As Boolean _
)
'Usage
Dim database As Database
Dim name As String
Dim isFileStream As Boolean
Dim instance As New FileGroup(database, _
name, isFileStream)
public FileGroup(
Database database,
string name,
bool isFileStream
)
public:
FileGroup(
Database^ database,
String^ name,
bool isFileStream
)
new :
database:Database *
name:string *
isFileStream:bool -> FileGroup
public function FileGroup(
database : Database,
name : String,
isFileStream : boolean
)
Parameter
- database
Typ: Microsoft.SqlServer.Management.Smo. . :: . .Database
Ein Database-Objektwert, der die Datenbank darstellt, die Dateien in der Dateigruppe speichert.
- name
Typ: System. . :: . .String
Ein String-Wert, der den Namen der Dateigruppe darstellt.
- isFileStream
Typ: System. . :: . .Boolean
Ein Boolean-Wert. Wenn der Wert True ist, wird die Instanz initialisiert, damit Dateigruppen des FILESTREAM-Typs erstellt werden können.
Beispiele
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Management.Smo
Module Module1
Sub Main()
'Connect to the local, default instance of SQL Server.
Dim svr As New Server()
'Define a Database object instance by supplying the server
'and the database name arguments in the constructor.
Dim db As New Database(svr, "MyPhotos")
'Create the database on the instance of SQL Server.
db.Create()
'Define a FileGroup object instance for creation of FILESTREAM
'groups by supplying the database, group name, and supplying
'true for the isFileStream parameters.
Dim myFileGroup As New FileGroup(db, "MyPhotoGroup", True)
If myFileGroup.IsFileStream = True Then
Console.WriteLine("MyPhotoGroup is enabled for the creation of a FILESTREAM file group.")
End If
'Remove the database to clean up.
db.Drop()
End Sub
End Module
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Management.Smo;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
//Connect to the local, default instance of SQL Server.
Server svr = new Server();
//Define a Database object instance by supplying the server
//and the database name arguments in the constructor.
Database db = new Database(svr, "MyPhotos");
//Create the database on the instance of SQL Server.
db.Create();
//Define a FileGroup object instance for creation of FILESTREAM
//groups by supplying the database, group name, and supplying
//true for the isFileStream parameters.
FileGroup myFileGroup = new FileGroup(db, "MyPhotoGroup", true);
if (myFileGroup.IsFileStream == true)
Console.WriteLine("MyPhotoGroup is enabled for the creation of a FILESTREAM file group.");
//Remove the database to clean up.
db.Drop();
}
}
}