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)); } }