C# (CSharp) KeyConstraint.GetQueryObjectName示例

示例#1

文件： SqlServerDataSource.cs 项目： pj-martins/PaJaMa.Database

        internal override string GetKeyConstraintCreateScript(KeyConstraint keyConstraint)
        {
            return(string.Format(@"CONSTRAINT {0}
{1}
{2}
({3})", keyConstraint.GetQueryObjectName(this), keyConstraint.IsPrimaryKey ? "PRIMARY KEY" : "UNIQUE", keyConstraint.ClusteredNonClustered, string.Join(", ",
                                                                                                                                                        keyConstraint.Columns.OrderBy(c => c.Ordinal).Select(c => string.Format("{0} {1}", this.GetConvertedObjectName(c.ColumnName), c.Descending ? "DESC" : "ASC")))));
        }

示例#2

        internal virtual string GetKeyConstraintCreateScript(KeyConstraint keyConstraint)
        {
            return(string.Format(@"CONSTRAINT {0}
{1}
({2})",
                                 keyConstraint.GetQueryObjectName(this),
                                 keyConstraint.IsPrimaryKey ? "PRIMARY KEY" : "UNIQUE",
                                 string.Join(", ",
                                             keyConstraint.Columns.OrderBy(c => c.Ordinal).Select(c => this.GetConvertedObjectName(c.ColumnName)
                                                                                                  ))));
        }