TransArticle 构造函数
定义
重要
一些信息与预发行产品相关,相应产品在发行之前可能会进行重大修改。 对于此处提供的信息,Microsoft 不作任何明示或暗示的担保。
创建类的新实例 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)
参数
- connectionContext
- ServerConnection
一个ServerConnection对象值,用于指定与 Publisher 的连接。