C# (CSharp) DBDatabase.GetCreationQuery示例

示例#1

        private void CreateBackupFile(DBDatabase database, string pathToFile)
        {
            var curDate = DateTime.Now;

            using (var sqlFile = new StreamWriter(pathToFile))
            {
                sqlFile.WriteLine(database.GetCreationQuery());
                sqlFile.WriteLine();
                sqlFile.WriteLine($"USE [{database.Name}]");
                sqlFile.WriteLine("GO");
                sqlFile.WriteLine();

                this.WriteSchemas(database.Schemas, sqlFile);
                sqlFile.WriteLine();

                this.WriteTablesCreation(database.Tables, sqlFile);
                sqlFile.WriteLine();

                this.WriteViews(database.Views, sqlFile);
                sqlFile.WriteLine();

                this.WriteSynonyms(database.Synonyms, sqlFile);
                sqlFile.WriteLine();

                this.WriteProcedures(database.Procedures, sqlFile);
                sqlFile.WriteLine();

                this.WriteFunctions(database.Functions, sqlFile);
                sqlFile.WriteLine();

                this.WriteSequences(database.Sequences, sqlFile);
                sqlFile.WriteLine();

                this.WriteTableData(database.Tables, sqlFile);
                sqlFile.WriteLine();

                this.WriteConstraints(database.Constraints, sqlFile);
                sqlFile.WriteLine();

                this.WriteTriggers(database.Tables, sqlFile);
                sqlFile.WriteLine();
            }
        }