SqlSessionProvider, classe (Microsoft.Office.Server.ApplicationRegistry.Infrastructure)

Article
02/01/2010

Represents the SQL session provider to connect to the Shared Services Provider database.

Espace de noms : Microsoft.Office.Server.ApplicationRegistry.Infrastructure
Assembly : Microsoft.SharePoint.Portal (dans microsoft.sharepoint.portal.dll)

Syntaxe

'Déclaration
<SharePointPermissionAttribute(SecurityAction.LinkDemand, ObjectModel:=True)> _
Public NotInheritable Class SqlSessionProvider
'Utilisation
Dim instance As SqlSessionProvider

[SharePointPermissionAttribute(SecurityAction.LinkDemand, ObjectModel=true)] 
public sealed class SqlSessionProvider

Remarques

The SQLSessionProvider is a singleton that can be accessed through its Instance property.

Exemple

The Business Data Catalog is implemented as a Microsoft Office SharePoint Server 2007 shared service and is shared across a Shared Resource Provider. Therefore, before you can use the ApplicationRegistry object, you must reference the Shared Resource Provider associated with the Business Data Catalog.

The following code example shows how to set the default Shared Services Provider (SSP) in your local server farm for use with the Business Data Catalog, and how to display the names of the systems that are registered in the Business Data Catalog. Specifying the SSP is the first step in setting up a console application to work with the Business Data Catalog.

After you specify the Shared Resource Provider, you can use the ApplicationRegistry object to get the LobSystemInstance objects that are registered with the Business Data Catalog, as shown in the following example.

Prerequisites

Ensure a Shared Service Provider is already created.
Replace the constant value EnterYourSSPNameHere in the code with the name of your Shared Resource Provider.

Project References

Add the following Project References in your console application code project before running this sample:

Microsoft.SharePoint
Microsoft.SharePoint.Portal
Microsoft.Office.Server

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using Microsoft.Office.Server.ApplicationRegistry.MetadataModel;
using Microsoft.Office.Server.ApplicationRegistry.Runtime;
using Microsoft.Office.Server.ApplicationRegistry.SystemSpecific;
using Microsoft.Office.Server.ApplicationRegistry.Infrastructure;
using WSSAdmin = Microsoft.SharePoint.Administration;
using OSSAdmin = Microsoft.Office.Server.Administration;

namespace Microsoft.SDK.SharePointServer.Samples
{
    class GetStartedAndDisplaySystems
    {
        const string yourSSPName = "EnterYourSSPNameHere";

        static void Main(string[] args)
        {
            SetupBDC();
            DisplayLOBSystemsinBDC();
            Console.WriteLine("Press any key to exit...");
            Console.Read();
        }
        static void SetupBDC()
        {
            SqlSessionProvider.Instance().SetSharedResourceProviderToUse(yourSSPName);
        }
        static void DisplayLOBSystemsinBDC()
        {
            NamedLobSystemInstanceDictionary sysInstances = ApplicationRegistry.GetLobSystemInstances();
            Console.WriteLine("Listing system instances...");
            foreach (String name in sysInstances.Keys)
            {
                Console.WriteLine(name);
            }
        }
    }
}

Hiérarchie d'héritage

System.Object
Microsoft.Office.Server.ApplicationRegistry.Infrastructure.SqlSessionProvider

Sécurité des threads

Les membres statiques publics de ce type (Shared en Visual Basic) sont sécurisés au niveau des threads. Il n'est pas garanti que les membres d'instance soient sécurisés au niveau des threads.

Voir aussi

Référence

Membres SqlSessionProvider
Microsoft.Office.Server.ApplicationRegistry.Infrastructure, espace de noms

Partager via