MySQL version of SqlToCsharp.

A C# class generator from SQL CREATE TABLE Statements (MySQLs)

dotnet tool install --global MySQLToCsharp

There are 3 options to generate C# code from MySQL Create Table query.

1. input sql string and generate a class.
2. read sql file and generate a class.
3. read directory path and generate class for each *.sql file.

generate from query.

# query 
mysql2csharp --query -i "CREATE TABLE sercol1 (id INT, val INT);" -o bin/out -n MyNameSpace.Data

generate from file.

# file
dotnet mysql2csharp --file -i "./MySQLToCsharp.Tests/test_data/sql/create_table.sql" -o bin/out -n MyNameSpace.Data

read directory and generate for all *.sql

# dirctory
dotnet mysql2csharp --dir -i "./MySQLToCsharp.Tests/test_data/sql/" -o bin/out -n MyNameSpace.Data

run script to generate C# class files. it calls docker-compose up and generate lexer, parser, listener and visitor class.

# windows
gen.bat

# macos/linux
gen.sh

getting started

• antlr4/csharp-target.md at master · antlr/antlr4
• antlr4/runtime/CSharp at master · antlr/antlr4
• antlr4cs/Readme.md at master · sharwell/antlr4cs
• antlr-mega-tutorial/README.md at master · unosviluppatore/antlr-mega-tutorial
• antlr-mega-tutorial/antlr-csharp/antlr-csharp at master · unosviluppatore/antlr-mega-tutorial

good

• pyparsingをAntlr4で置き換えて性能を5倍にした - Qiita
• TreePatternTest in C#
• Antlr4 - Visitor vs Listener Pattern - Saumitra's blog
• java - Parsing mysql using ANTLR4 simple example - Stack Overflow

ANTLR4 repos

• JaCraig/SQLParser: An SQL Parser/Lexer for C#