Inheritance: SqlDbSchema
Exemple #1
0
        public static DataTable GetSchema(SqlConnection con, string collectionName, object[] restrictions)
        {
            var filter = String.Format("CollectionName = '{0}'", collectionName);

            var ds = GetMetaDataSet();

            var collection = ds.Tables[DbMetaDataCollectionNames.MetaDataCollections].Select(filter);

            if (collection.Length != 1)
                throw new NotSupportedException("Unsupported collection name.");

            if (restrictions != null && restrictions.Length > (int)collection[0]["NumberOfRestrictions"])
                throw new InvalidOperationException("The number of specified restrictions is not valid.");

            if (ds.Tables[DbMetaDataCollectionNames.Restrictions].Select(filter).Length !=
                (int)collection[0]["NumberOfRestrictions"])
                throw new InvalidOperationException("Incorrect restriction definition.");

            SqlDbSchema returnSchema;
            var sqlClauses = ds.Tables["SqlClauses"];
            switch (collectionName.ToLower(CultureInfo.CurrentCulture))
            {
                case "checkconstraints":
                    returnSchema = new SqlCheckConstraints();
                    break;
                case "columns":
                    returnSchema = new SqlColumns();
                    break;
                case "defaultconstraints":
                    returnSchema = new SqlDefaultConstraints();
                    break;
                case "foreignkeys":
                    returnSchema = new SqlForeignKeys();
                    break;
                case "indexes":
                    returnSchema = new SqlIndexes();
                    break;
                case "primarykeys":
                    returnSchema = new SqlPrimaryKeys();
                    break;
                case "tables":
                    returnSchema = new SqlTables();
                    break;
                case "triggers":
                    returnSchema = new SqlTriggers();
                    break;
                case "uniquekeys":
                    returnSchema = new SqlUniqueKeys();
                    break;
                default:
                    throw new NotSupportedException("The specified metadata collection is not supported.");
            }

            return returnSchema.GetSchema(con, collectionName, restrictions);
        }
Exemple #2
0
        public static DataTable GetSchema(SqlConnection con, string collectionName, object[] restrictions)
        {
            var filter = String.Format("CollectionName = '{0}'", collectionName);

            var ds = GetMetaDataSet();

            var collection = ds.Tables[DbMetaDataCollectionNames.MetaDataCollections].Select(filter);

            if (collection.Length != 1)
            {
                throw new NotSupportedException("Unsupported collection name.");
            }

            if (restrictions != null && restrictions.Length > (int)collection[0]["NumberOfRestrictions"])
            {
                throw new InvalidOperationException("The number of specified restrictions is not valid.");
            }

            if (ds.Tables[DbMetaDataCollectionNames.Restrictions].Select(filter).Length !=
                (int)collection[0]["NumberOfRestrictions"])
            {
                throw new InvalidOperationException("Incorrect restriction definition.");
            }

            SqlDbSchema returnSchema;
            var         sqlClauses = ds.Tables["SqlClauses"];

            switch (collectionName.ToLower(CultureInfo.CurrentCulture))
            {
            case "checkconstraints":
                returnSchema = new SqlCheckConstraints();
                break;

            case "columns":
                returnSchema = new SqlColumns();
                break;

            case "defaultconstraints":
                returnSchema = new SqlDefaultConstraints();
                break;

            case "foreignkeys":
                returnSchema = new SqlForeignKeys();
                break;

            case "indexes":
                returnSchema = new SqlIndexes();
                break;

            case "primarykeys":
                returnSchema = new SqlPrimaryKeys();
                break;

            case "tables":
                returnSchema = new SqlTables();
                break;

            case "triggers":
                returnSchema = new SqlTriggers();
                break;

            case "uniquekeys":
                returnSchema = new SqlUniqueKeys();
                break;

            default:
                throw new NotSupportedException("The specified metadata collection is not supported.");
            }

            return(returnSchema.GetSchema(con, collectionName, restrictions));
        }