in doc-architect/doc-architect-core/src/main/java/com/docarchitect/core/scanner/impl/dotnet/EntityFrameworkScanner.java [774:795]
private String mapCSharpTypeToSql(String csharpType) {
// Remove nullable modifier
csharpType = csharpType.replace("?", "");
return switch (csharpType.toLowerCase()) {
case "int", "int32" -> "INTEGER";
case "long", "int64" -> "BIGINT";
case "short", "int16" -> "SMALLINT";
case "byte" -> "TINYINT";
case "bool", "boolean" -> "BOOLEAN";
case "string" -> "NVARCHAR";
case "datetime" -> "DATETIME";
case "datetimeoffset" -> "DATETIMEOFFSET";
case "decimal" -> "DECIMAL";
case "double" -> "FLOAT";
case "float", "single" -> "REAL";
case "guid" -> "UNIQUEIDENTIFIER";
case "byte[]" -> "VARBINARY";
case "timespan" -> "TIME";
default -> csharpType.toUpperCase();
};
}