TOPIC: 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;
}