11.10. Creating a Database Table from a DataTable Schema

You need to create a table in a database from an existing DataTable schema.

Use the CreateDdlFromDataTable() method shown in this solution.

The sample code contains creates a DataTable containing the schema from the Sales.SalesOrder table in the AdventureWorks sample database. The method CreateDdlFromDataTable() in the sample code is called which generates the T-SQL DDL to create the table from the DataTable schema. The NetType2SqlType() method is called by the CreateDdlFromDataTable() to map .NET data types to SQL Server types when building the DDL statement.

The C# code in Program.cs in the project CreateTableDdlFromDataTable is shown in Example 11-10.

using System;
using System.Data;
using System.Data.SqlClient;
using System.Text;
using