语言

TransArticle 构造函数

定义

创建类的新实例 TransArticle 。

重载

名称 说明
TransArticle()

创建类的新实例 TransArticle 。

TransArticle(String, String, String, ServerConnection)

创建一个新的类实例TransArticle,具有所需的属性,并与 Microsoft SQL Server 实例有指定的连接。

注解

更新文本:2006年7月17日

下表显示了新实例的 TransArticle默认属性值。 表中未明确枚举的任何属性都被初始化为一个 null 值。

财产 默认值
CachePropertyChanges false
CommandFormat None对于CommandOptions
DatatypeMappingOptions Default对于ArticleDatatypeMappingOptions
DeleteCommand CALL sp_MSdel_table 1
IdentityRangeManagementOption Manual对于IdentityRangeManagementOption
InsertCommand CALL sp_MSins_table 1
IsExistingObject false
PreCreationMethod Drop对于PreCreationOption
SchemaOption PrimaryObject对于CreationScriptOptions
Type LogBased对于ArticleOptions
UpdateCommand SCALL sp_MSupd_table 1
VerticalPartition false

1 更多信息请参见 《交易型条目的变更如何传播 》以及sp_addarticle的 @del_cmd、 @ins_cmd和 @upd_cmd 参数( Transact-SQL)。

TransArticle()

创建类的新实例 TransArticle 。

public:
 TransArticle();
public TransArticle();
Public Sub New ()

示例

// Define the Publisher, publication, and article names.
string publisherName = publisherInstance;
string publicationName = "AdvWorksProductTran";
string publicationDbName = "AdventureWorks2012";
string articleName = "Product";
string schemaOwner = "Production";

TransArticle article;

// Create a connection to the Publisher.
ServerConnection conn = new ServerConnection(publisherName);

// Create a filtered transactional articles in the following steps:
// 1) Create the  article with a horizontal filter clause.
// 2) Add columns to or remove columns from the article.
try
{
    // Connect to the Publisher.
    conn.Connect();

    // Define a horizontally filtered, log-based table article.
    article = new TransArticle();
    article.ConnectionContext = conn;
    article.Name = articleName;
    article.DatabaseName = publicationDbName;
    article.SourceObjectName = articleName;
    article.SourceObjectOwner = schemaOwner;
    article.PublicationName = publicationName;
    article.Type = ArticleOptions.LogBased;
    article.FilterClause = "DiscontinuedDate IS NULL";

    // Ensure that we create the schema owner at the Subscriber.
    article.SchemaOption |= CreationScriptOptions.Schema;

    if (!article.IsExistingObject)
    {
        // Create the article.
        article.Create();
    }
    else
    {
        throw new ApplicationException(String.Format(
            "The article {0} already exists in publication {1}.",
            articleName, publicationName));
    }

    // Create an array of column names to remove from the article.
    String[] columns = new String[1];
    columns[0] = "DaysToManufacture";

    // Remove the column from the article.
    article.RemoveReplicatedColumns(columns);
}
catch (Exception ex)
{
    // Implement appropriate error handling here.
    throw new ApplicationException("The article could not be created.", ex);
}
finally
{
    conn.Disconnect();
}
' Define the Publisher, publication, and article names.
Dim publisherName As String = publisherInstance
Dim publicationName As String = "AdvWorksProductTran"
Dim publicationDbName As String = "AdventureWorks2012"
Dim articleName As String = "Product"
Dim schemaOwner As String = "Production"

Dim article As TransArticle

' Create a connection to the Publisher.
Dim conn As ServerConnection = New ServerConnection(publisherName)

' Create a filtered transactional articles in the following steps:
' 1) Create the  article with a horizontal filter clause.
' 2) Add columns to or remove columns from the article.
Try
    ' Connect to the Publisher.
    conn.Connect()

    ' Define a horizontally filtered, log-based table article.
    article = New TransArticle()
    article.ConnectionContext = conn
    article.Name = articleName
    article.DatabaseName = publicationDbName
    article.SourceObjectName = articleName
    article.SourceObjectOwner = schemaOwner
    article.PublicationName = publicationName
    article.Type = ArticleOptions.LogBased
    article.FilterClause = "DiscontinuedDate IS NULL"

    ' Ensure that we create the schema owner at the Subscriber.
    article.SchemaOption = article.SchemaOption Or _
    CreationScriptOptions.Schema

    If Not article.IsExistingObject Then
        ' Create the article.
        article.Create()
    Else
        Throw New ApplicationException(String.Format( _
         "The article {0} already exists in publication {1}.", _
         articleName, publicationName))
    End If

    ' Create an array of column names to remove from the article.
    Dim columns() As String = New String(0) {}
    columns(0) = "DaysToManufacture"

    ' Remove the column from the article.
    article.RemoveReplicatedColumns(columns)
Catch ex As Exception
    ' Implement appropriate error handling here.
    Throw New ApplicationException("The article could not be created.", ex)
Finally
    conn.Disconnect()
End Try

注解

默认构造函数会将任何字段初始化为其默认值。

适用于

TransArticle(String, String, String, ServerConnection)

创建一个新的类实例TransArticle,具有所需的属性,并与 Microsoft SQL Server 实例有指定的连接。

public:
 TransArticle(System::String ^ name, System::String ^ publicationName, System::String ^ databaseName, Microsoft::SqlServer::Management::Common::ServerConnection ^ connectionContext);
public TransArticle(string name, string publicationName, string databaseName, Microsoft.SqlServer.Management.Common.ServerConnection connectionContext);
new Microsoft.SqlServer.Replication.TransArticle : string * string * string * Microsoft.SqlServer.Management.Common.ServerConnection -> Microsoft.SqlServer.Replication.TransArticle
Public Sub New (name As String, publicationName As String, databaseName As String, connectionContext As ServerConnection)

参数

name
String

一个 String 指定文章名称的值。

publicationName
String

一个 String 指定事务性或快照发布名称的值。

databaseName
String

一个 String 指定发表数据库名称的值。

connectionContext
ServerConnection

一个ServerConnection对象值,用于指定与 Publisher 的连接。

适用于