Constructeur FileGroup (Database, String, Boolean)
Initialise une nouvelle instance de la classe FileGroup sur la base de données spécifiée, avec le nom spécifié. Facultativement, permet la création d'un groupe de fichiers FILESTREAM.
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
Public Sub New ( _
database As Database, _
name As String, _
isFileStream As Boolean _
)
'Utilisation
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
)
Paramètres
- database
Type : Microsoft.SqlServer.Management.Smo. . :: . .Database
Valeur de l'objet Database qui représente la base de données qui stocke les fichiers dans le groupe de fichiers.
- name
Type : System. . :: . .String
Valeur String qui représente le nom du groupe de fichiers.
- isFileStream
Type : System. . :: . .Boolean
Valeur Boolean. Si (true) l'instance sera initialisée afin que les groupes de fichiers de type FILESTREAM puissent être créés.
Exemples
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();
}
}
}