Hi,

I have a method through which i am creating a Table in DB as shown below,

 

<div style="font-weight: inherit; font-style: inherit; font-family: inherit; outline-width: 0px; outline-style: initial; outline-color: initial; color: black; background-color: white; padding: 0px; margin: 0px; border: 0px initial initial;">

 public void CreateTable(List<string> columnNames, string tableName)
    {
      string connectionString = Utility.ReadDataFromConfig("ConnectionTest");

      using (var connection = new SqlConnection(connectionString))
      {
        var server = new Server(new ServerConnection(connection));
        var db = server.Databases["GlassLookUp"];
        var newTable = new Table(db, tableName);
        var idColumn = new Column(newTable, "ID") { DataType = DataType.Int, Nullable = false };
        newTable.Columns.Add(idColumn);
        foreach (var titleColumn in from temp in columnNames
                      where temp != string.Empty
                      select new Column(newTable, temp) { DataType = DataType.VarChar(500), Nullable = true })
        {
          newTable.Columns.Add(titleColumn);
        }
        newTable.Create();
      }
    }

</div>

 

I wanted the above method to be changed, so that Enterprise library is use. I have already used Enterprise library to execute stored procedures,but i dont know how to use Enterprise library to Create a Table.

Thanks