1:
2:
3:
4:
5:
6:
7:
8:
9:

DataSet ds = new DataSet();

// Read schema
using (StreamReader schemaStream = new StreamReader(path))
{
   ds.ReadXmlSchema(schemaStream);

   ds.ReadXml(tempFilename);
}					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:

            SqlConnection sc = new SqlConnection(
                @"Data Source=.\SQLEXPRESS;" +
                @"Integrated Security=True;");
            sc.Open();

            Server server = new Server(new ServerConnection(sc));
            Database db = server.Databases["Test"];

            if (db != null)
            {
                db.Drop();
                db = null;
            }

            if (db == null)
            {
                db = new Database(server, "Test");
            }

            db.Create();

            DataSet ds = new DataSet();

            ds.ReadXmlSchema(@"C:\result.xsd");
            ds.ReadXml(@"C:\clean_result.xml");

            foreach (DataTable table in ds.Tables)
            {
                Table testTable = new Table(db, table.TableName);

                foreach (DataColumn column in table.Columns)
                {
                    Column c = new Column(testTable, column.ColumnName);

                    c.DataType = DataSetHelper.GetSqlServerDataType(DataSetHelper.GetSqlDBTypeFromType(column.DataType), int.MaxValue, 4);
                    c.Nullable = column.AllowDBNull;
                    c.Identity = column.Unique;
                    testTable.Columns.Add(c);
                }

                testTable.Create();
            }

            SqlBulkCopy bulkCopy = new SqlBulkCopy(sc);

            foreach (DataTable sourceTable in ds.Tables)
            {
                bulkCopy.DestinationTableName = sourceTable.TableName;
                bulkCopy.WriteToServer(sourceTable);
            }					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:

       private static void CreateDatabaseStructur(Database database, DataSet structur)
        {
            foreach (DataTable table in structur.Tables)
            {
                Table testTable = new Table(database, table.TableName);

                // add columns to new table
                foreach (DataColumn column in table.Columns)
                {
                    Column c = new Column(testTable, column.ColumnName);

                    c.DataType = DataSetHelper.GetSqlServerDataType(DataSetHelper.GetSqlDBTypeFromType(column.DataType), int.MaxValue, 4);
                    c.Nullable = column.AllowDBNull;


                    testTable.Columns.Add(c);
                }

                testTable.Create();

                // add primary keys
                foreach (var primaryKey in table.PrimaryKey)
                {
                    Index index = new Index(testTable, primaryKey.ColumnName);
                    index.IndexKeyType = IndexKeyType.DriPrimaryKey;
                    index.IndexedColumns.Add(new IndexedColumn(index, primaryKey.ColumnName));

                    testTable.Indexes.Add(index);
                    index.Create();
                }

                // add foreign keys
                foreach (DataRelation relation in table.ParentRelations)
                {
                    ForeignKey fk = new ForeignKey(testTable, relation.RelationName);

                    for (int i = 0; i < relation.ChildColumns.Length; i++)
                    {
                        fk.Columns.Add(new ForeignKeyColumn(
                            fk,
                            relation.ChildColumns[i].ColumnName,
                            relation.ParentColumns[i].ColumnName));
                    }

                    fk.ReferencedTable = relation.ParentTable.TableName;
                    fk.Create();
                }
            }
        }					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:

        private static void FillDatabase(SqlConnection sqlConnection, DataSet pluginResult)
        {
            SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConnection);

            foreach (DataTable sourceTable in pluginResult.Tables)
            {
                bulkCopy.DestinationTableName = sourceTable.TableName;
                bulkCopy.WriteToServer(sourceTable);
            }
        }					

1:
2:
3:
4:

<root>
  <child/>
  <child/>
</root>