C# (CSharp) Sys.Data TableName.GenerateCreateTableClause Beispiele

Beispiel #1

Datei: DataTableExtension.cs Projekt: fjiang2/sqlcon

        public static int WriteSql(this DataTable dt, TextWriter writer, TableName tname)
        {
            TableSchemaManager.SetTableSchema(tname, dt);
            string SQL = tname.GenerateCreateTableClause(appendGO: true);

            writer.WriteLine(SQL);

            TableSchema         schema = new TableSchema(tname);
            SqlScriptGeneration gen    = new SqlScriptGeneration(SqlScriptType.INSERT, schema);

            return(gen.GenerateByDbTable(dt, writer));
        }