This question is locked. New answers and comments are not allowed.
I have a need to identify computed columns, but I haven't been able to figure out how. Below is what I have so far and I have set the Kind property on the column to Calculated, but I can't find that property anywhere on the column at runtime. It doesn't appear to even be in the MetaDataProperties collection. How can I find these columns?
Thanks!
Thanks!
//determine if this scope already exists on the server and if not go ahead and provision
foreach
(MetaTable table
in
scope.OpenAccessMetaData.Tables)
{
Collection<
string
> syncColumns =
new
Collection<
string
>();
foreach
(MetaColumn column
in
table.Columns)
{
if
(column.Name !=
"DisguisedSSN"
)
{
syncColumns.Add(column.Name);
}
}
//add the approrpiate tables to this scope
scope.ScopeDescription.Tables.Add(SqlSyncDescriptionBuilder.GetDescriptionForTable(table.Name, syncColumns, (System.Data.SqlClient.SqlConnection)remoteProvider.Connection));
}