SqlServices 类
定义
重要
一些信息与预发行产品相关，相应产品在发行之前可能会进行重大修改。 对于此处提供的信息，Microsoft 不作任何明示或暗示的担保。
支持安装和移除 ASP.NET 功能的 SQL Server 数据库元素。
public ref class SqlServices abstract sealedpublic static class SqlServicestype SqlServices = classPublic Class SqlServices- 继承
-
SqlServices
示例
下面的代码示例演示如何使用 SqlServices 类。
using System;
using System.Web.Management;
namespace UsingSQLServices
{
class UsingSqlServices
{
static void Main(string[] args)
{
try
{
// Values to use.
string server = "ASPFeatureServer";
string database = "ASPFeatureDB";
string connectionString =
"server=ASPFeatureServer, pooling=False, user=<user name>, password=<secure password>";
string user = "AspAdmin";
string password = "Secure Password"; // Use a sicure password.
// Install membership and personalization.
SqlServices.Install(database,
SqlFeatures.Membership &
SqlFeatures.Personalization,
connectionString);
// Remove membership and personalization.
SqlServices.Uninstall(database,
SqlFeatures.Membership &
SqlFeatures.Personalization,
connectionString);
// Install all features.
SqlServices.Install(server, database,
SqlFeatures.All);
// Remove all features.
SqlServices.Uninstall(server, database,
SqlFeatures.All);
// Install a custom session state database.
SqlServices.InstallSessionState(database,
SessionStateType.Custom,
connectionString);
// Remove a custom session state database.
SqlServices.UninstallSessionState(database,
SessionStateType.Custom,
connectionString);
// Install temporary session state.
SqlServices.InstallSessionState(server, null,
SessionStateType.Temporary);
// Remove temporary session state.
SqlServices.UninstallSessionState(server, null,
SessionStateType.Temporary);
// Install persisted session state.
SqlServices.InstallSessionState(server, user, password,
null, SessionStateType.Persisted);
// Remove persisted session state.
SqlServices.UninstallSessionState(server, user, password,
null, SessionStateType.Persisted);
}
catch (SqlExecutionException sqlExecutionException)
{
Console.WriteLine(
"An SQL execution exception occurred.");
Console.WriteLine();
Console.WriteLine(" Message: {0}",
sqlExecutionException.Message);
Console.WriteLine(" Server: {0}",
sqlExecutionException.Server);
Console.WriteLine(" Database: {0}",
sqlExecutionException.Database);
Console.WriteLine(" Commands: {0}",
sqlExecutionException.Commands);
Console.WriteLine(" SqlFile: {0}",
sqlExecutionException.SqlFile);
Console.WriteLine(" Inner Exception: {0}",
sqlExecutionException.Exception);
}
catch (Exception ex)
{
Console.WriteLine("An unknown exception occurred.");
Console.WriteLine();
Console.WriteLine(" Message: {0}", ex.Message);
}
}
}
}
Imports System.Web.Management
Module UsingSqlServices
Sub Main()
Try
' Values to use.
Dim server As String = "ASPFeatureServer"
Dim database As String = "ASPFeatureDB"
Dim connectionString As String = _
"server=ASPFeatureServer, pooling=False, user=<user name>, password=<secure password>"
Dim user As String = "AspAdmin"
Dim password As String = "Secure Password"
' Install membership and personalization.
SqlServices.Install(database, _
SqlFeatures.Membership And _
SqlFeatures.Personalization, _
connectionString)
' Remove membership and personalization.
SqlServices.Uninstall(database, _
SqlFeatures.Membership And _
SqlFeatures.Personalization, _
connectionString)
' Install all features.
SqlServices.Install(server, database, _
SqlFeatures.All)
' Remove all features.
SqlServices.Uninstall(server, database, _
SqlFeatures.All)
' Install a custom session state database.
SqlServices.InstallSessionState(database, _
SessionStateType.Custom, _
connectionString)
' Remove a custom session state database.
SqlServices.UninstallSessionState(database, _
SessionStateType.Custom, _
connectionString)
' Install temporary session state.
SqlServices.InstallSessionState(server, Nothing, _
SessionStateType.Temporary)
' Remove temporary session state.
SqlServices.UninstallSessionState(server, Nothing, _
SessionStateType.Temporary)
' Install persisted session state.
SqlServices.InstallSessionState(server, user, password, _
Nothing, SessionStateType.Persisted)
' Remove persisted session state.
SqlServices.UninstallSessionState(server, user, password, _
Nothing, SessionStateType.Persisted)
Catch sqlExecutionException As SqlExecutionException
Console.WriteLine( _
"An SQL execution exception occurred.")
Console.WriteLine()
Console.WriteLine(" Message: {0}", _
sqlExecutionException.Message)
Console.WriteLine(" Server: {0}", _
sqlExecutionException.Server)
Console.WriteLine(" Database: {0}", _
sqlExecutionException.Database)
Console.WriteLine(" Commands: {0}", _
sqlExecutionException.Commands)
Console.WriteLine(" SqlFile: {0}", _
sqlExecutionException.SqlFile)
Console.WriteLine(" Inner Exception: {0}", _
sqlExecutionException.Exception)
Catch ex As Exception
Console.WriteLine("An unknown exception occurred.")
Console.WriteLine()
Console.WriteLine(" Message: {0}", ex.Message)
End Try
End Sub
End Module
注解
可以使用 SQL Server 数据库来存储 ASP.NET 功能的信息，例如会话状态、成员身份、Web 部件个性化和角色管理。 这些功能要求在使用之前正确配置它们连接到的 SQL Server 数据库。 可以使用 ASP.NET Register SQL 工具 (aspnet_regsql.exe) 执行此操作，也可以直接从代码调用类公开的 SqlServices 静态方法。
注意
使用 aspnet_regsql.exe 工具或 SqlServices 类配置数据库只会设置提供程序将用于适当的表、触发器和存储过程的数据库。 以这种方式配置数据库不会修改配置文件以指定这些功能对这些服务使用 SQL 提供程序。
