public string makeConstraint(string ReferencingTableNameName, string ReferencingColumnName, string ReferencedTableName, string ReferencedColumnName, bool AddDdData)
{
string ReturnVal = string.Empty;
_CswConstraintDdlOps.add(ReferencingTableNameName, ReferencingColumnName, ReferencedTableName, ReferencedColumnName, AddDdData);
_CswConstraintDdlOps.apply(ReferencingTableNameName, ReferencingColumnName);
ReturnVal = _CswConstraintDdlOps.getConstraintName(ReferencingTableNameName, ReferencingColumnName, ReferencedTableName, ReferencedColumnName);
if (string.Empty == ReturnVal)
{
throw (new CswDniException("A constraint name was not reported"));
}
Constraint AddedConstraint = new Constraint();
AddedConstraint.ReferencingTable = ReferencedTableName;
AddedConstraint.ReferencingColumn = ReferencedColumnName;
AddedConstraint.ConstraintName = ReturnVal;
_Cosntraints.Add(AddedConstraint);
return(ReturnVal);
}//makeConstraint()
}//DdlTableOpType
public void addColumn(string columnname, CswEnumDataDictionaryColumnType columntype, Int32 datatypesize, Int32 dblprecision,
string defaultvalue, string description, string foreignkeycolumn, string foreignkeytable, bool constrainfkref, bool isview,
string lowerrangevalue, bool lowerrangevalueinclusive, CswEnumDataDictionaryPortableDataType portabledatatype, bool ReadOnly,
bool Required, CswEnumDataDictionaryUniqueType uniquetype, bool uperrangevalueinclusive, string upperrangevalue)
//Int32 NodeTypePropId, string SubFieldName )
{
CswColumnDdlOp CswColumnDdlOp = new CswColumnDdlOp(columnname, CswEnumDdlColumnOpType.Add);
CswColumnDdlOp.columntype = columntype;
CswColumnDdlOp.datatypesize = datatypesize;
CswColumnDdlOp.dblprecision = dblprecision;
CswColumnDdlOp.defaultvalue = defaultvalue;
CswColumnDdlOp.description = description;
CswColumnDdlOp.isview = isview;
CswColumnDdlOp.lowerrangevalue = lowerrangevalue;
CswColumnDdlOp.lowerrangevalueinclusive = lowerrangevalueinclusive;
CswColumnDdlOp.portabledatatype = portabledatatype;
CswColumnDdlOp.ReadOnly = ReadOnly;
CswColumnDdlOp.Required = Required;
CswColumnDdlOp.uniquetype = uniquetype;
CswColumnDdlOp.uperrangevalueinclusive = uperrangevalueinclusive;
CswColumnDdlOp.upperrangevalue = upperrangevalue;
//CswColumnDdlOp.NodeTypePropId = NodeTypePropId;
//CswColumnDdlOp.SubFieldName = SubFieldName;
_Columns.Add(columnname, CswColumnDdlOp);
if (dbg_ManageConstraints)
{
if (constrainfkref && string.Empty != foreignkeycolumn && string.Empty != foreignkeytable)
{
_CswConstraintDdlOps.add(_TableName, CswColumnDdlOp.columnname, foreignkeytable, foreignkeycolumn, constrainfkref);
}
}
}//addColumn()
