private static string GetDataTypeForField(Type fieldType)
 {
     //Make sure we use text for string instead of varchar.
     if (fieldType == typeof(String))
     {
         return("text");
     }
     else
     {
         return(provider.GetColumnTypeDefinition(fieldType));
     }
 }