Пример #1
0
        public DbTableConstraintColumn AddReference(string col, DbTable refTable, string refColumn, int ord, int pos)
        {
            DbTableConstraintColumn c = constraintColumns.ContainsKey(col) ? constraintColumns[col] :
                                        constraintColumns.Add(col, new DbTableConstraintColumn(this, dbTable.columns[col]));

            referencedTable = refTable;
            refTable.references.Add(this);
            c.ordinalPosition            = ord;
            c.positionInUniqueConstraint = pos;
            c.referencedColumn           = refTable.columns[refColumn];
            refTable.columns[refColumn].references.Add(c);
            return(c);
        }
Пример #2
0
        public DbTableConstraintColumn AddColumn(DbColumn cInfo, int seq = -1,
                                                 bool non = false, int card = -1)
        {
            DbTableConstraintColumn c = constraintColumns.ContainsKey(cInfo.objectName) ?
                                        constraintColumns[cInfo.objectName] : constraintColumns.Add(cInfo.objectName, new DbTableConstraintColumn(this, cInfo));

            c.seqInIndex  = seq;
            c.nonUnique   = non;
            c.cardinality = card;
            cInfo.constraints.Add(c);

            return(c);
        }
Пример #3
0
        public DbTableConstraintColumn AddInferredRelationship(string col, DbTable refTable, DbColumn refColumn)
        {
            DbTableConstraintColumn c = constraintColumns.ContainsKey(col) ? constraintColumns[col] :
                                        constraintColumns.Add(col, new DbTableConstraintColumn(this, dbTable.columns[col]));

            referencedTable = refTable;
            refTable.references.Add(this);
            if (refColumn != null)
            {
                c.referencedColumn = refColumn;
                refColumn.references.Add(c);
            }
            return(c);
        }