Example #1
0
 private static void PopulateConstraints(ColumnInfo[] allColumns, ConstraintInfo[] allConstraints)
 {
     foreach (var c in allConstraints)
     {
         var column = allColumns.FirstOrDefault(p => p.Schema == c.Schema && p.TableName == c.TableName && c.ColumnName == p.ColumnName);
         if (column != null)
         {
             switch (c.Type)
             {
                 case ConstraintType.PrimaryKey:
                     column.IsPrimaryKey = true;
                     break;
                 case ConstraintType.Uniqule:
                     column.IsUniqule = true;
                     break;
                 case ConstraintType.Check:
                     column.IsCheck = true;
                     break;
             }
         }
     }
 }