Table Name if doesn't exist

bool bFirst = true; public object DoWork() { object o = null; if (bFirst) { // only for the first row bFirst = false; // get the WRITE Adapter DatabaseAdapter adapter = (DatabaseAdapter)AdapterWrite; string sql = String.Format("select count(*) from {0}", adapter.SQL); // check whether the table exists try { o = adapter.Execute(sql, true); // Table already exists, no more to do. return null; } catch(Exception) { // nothing :-) } // create sql create statement sql = String.Format("create table {0} (", adapter.SQL); int len = 0; int count = 0; foreach(Field f in adapter.Fields) { DatabaseAdapterField field = (DatabaseAdapterField)f; if (count > 0) sql += ", "; sql += "[" + field.Name + "] "; switch(field.DataType) { case DataType.String: len = field.Length; if (len == 0) len = 100; // default length //SQL data type for strings sql += "varchar(" + len.ToString() + ")"; break; case DataType.Date: case DataType.Time: case DataType.DateTime: //SQL data type for datetime sql += "datetime"; break; case DataType.Boolean: //SQL data type for Bool: for MYSQL use boolean! sql += "bit"; break; case DataType.Integer: //SQL data type for Int sql += "Integer"; break; case DataType.Double: case DataType.Decimal: case DataType.Currency: //SQL data type for Double and Currency, also posible numeric(18,2) ... sql += "Float"; break; } if (field.AutoIncrement) sql += " identity(1,1)"; if (field.PrimaryKey) sql += " not null"; count++; } sql += " );"; // for debug write the SQL statement to file // File.WriteAllText("C:\\Temp\\sql.txt", sql); // create table adapter.Execute(sql); } return null; }