Пример #1
0
        /// <summary>
        ///     Executes the query.
        /// </summary>
        /// <returns>
        ///     The number of rows affected.
        /// </returns>
        public override int ExecuteNonQuery()
        {
            // Source:
            //// http://regexadvice.com/forums/thread/55175.aspx

            Regex regex = new Regex(@"CREATE *SCHEMA *\((.*)\)");

            var matches = regex.Matches(this.CommandText.Trim());

            if (matches.Count != 1)
            {
                throw new NotSupportedException();
            }

            string keyString = matches[0].Groups[1].Value;

            DbSchemaKey key    = DbSchemaKey.FromString(keyString);
            DbSchema    schema = DbSchemaStore.GetDbSchema(key);

            DbContainer container = this.EffortConnection.DbContainer;

            container.Initialize(schema);

            return(0);
        }
Пример #2
0
        /// <summary>
        ///     Generates a data definition language (DDL0 script that creates schema objects
        ///     (tables, primary keys, foreign keys) based on the contents of the
        ///     <see cref="T:System.Data.Metadata.Edm.StoreItemCollection" /> parameter and
        ///     targeted for the version of the database corresponding to the provider manifest
        ///     token.
        /// </summary>
        /// <param name="providerManifestToken">
        ///     The provider manifest token identifying the target version.
        /// </param>
        /// <param name="storeItemCollection">
        ///     The structure of the database.
        /// </param>
        /// <returns>
        ///     A DDL script that creates schema objects based on the contents of the
        ///     <see cref="T:System.Data.Metadata.Edm.StoreItemCollection" /> parameter and
        ///     targeted for the version of the database corresponding to the provider manifest
        ///     token.
        /// </returns>
        protected override string DbCreateDatabaseScript(
            string providerManifestToken,
            StoreItemCollection storeItemCollection)
        {
            DbSchemaKey key = new DbSchemaKey(storeItemCollection);

            // Initialize schema
            DbSchemaStore.GetDbSchema(storeItemCollection, DbSchemaFactory.CreateDbSchema);

            return(string.Format("CREATE SCHEMA ({0})", key));
        }
Пример #3
0
 /// <summary>
 ///     Returns a <see cref="DbSchema"/> object that is associated to the specified
 ///     DbSchemaKey.
 /// </summary>
 /// <param name="schemaKey"> The DbSchemaKey object. </param>
 /// <returns> The DbSchema object. </returns>
 public static DbSchema GetDbSchema(DbSchemaKey schemaKey)
 {
     return store.Get(schemaKey);
 }