public void TestCreateSqlStatementFromDataTableWithPrimaryKey() { const string Target = "CREATE TABLE [TempTable] (\n[RowID] INT,\n[Col1] VARCHAR(255),\n[Col2] INT\nCONSTRAINT [PK_TempTable] PRIMARY KEY CLUSTERED ([RowID]))\n"; // create the datatable and add some columns var dataTable = new DataTable(); var rowIdColumn = new DataColumn() { DataType = System.Type.GetType("System.Int32"), ColumnName = "RowID", AutoIncrement = true }; dataTable.Columns.Add(rowIdColumn); dataTable.Columns.Add( new DataColumn() { DataType = System.Type.GetType("System.String"), ColumnName = "Col1" }); dataTable.Columns.Add( new DataColumn() { DataType = System.Type.GetType("System.Int32"), ColumnName = "Col2" }); DataColumn[] keys = new DataColumn[1]; keys[0] = rowIdColumn; dataTable.PrimaryKey = keys; string result = SqlTableBuilder.CreateSqlStatementFromDataTable("TempTable", dataTable); Assert.AreEqual(result, Target); }
public void TestCreateSqlStatementFromDataTableSimple() { const string Target = "CREATE TABLE [TempTable] (\n[RowID] INT,\n[Col1] VARCHAR(255),\n[Col2] INT\n)"; // create the datatable and add some columns var dataTable = new DataTable(); dataTable.Columns.Add( new DataColumn() { DataType = System.Type.GetType("System.Int32"), ColumnName = "RowID", AutoIncrement = true }); dataTable.Columns.Add( new DataColumn() { DataType = System.Type.GetType("System.String"), ColumnName = "Col1" }); dataTable.Columns.Add( new DataColumn() { DataType = System.Type.GetType("System.Int32"), ColumnName = "Col2" }); string result = SqlTableBuilder.CreateSqlStatementFromDataTable("TempTable", dataTable); Assert.AreEqual(result, Target); }