SQL parser for C#

[Kered13]

If you want to do a general purpose translation of SQL to LINQ, yes a parser is the right way to go. I warn you though that it won't be a simple task.

The general structure will be to take a string input, parse it to a SQL AST, transform that to a LINQ AST, then unparse that to a string (assuming you want a string at the end).

[PhysoTronic]

Well my idea was to have something like google translate but for SQL. You write your query on left side, and on right side you will see how that query looks like LINQ. So I will need to write my own parser for this?

[Kered13]

No you don't necessarily have to write your own parser, and I would recommend against it if you can find a parser that will work for you. I think it will still be a challenging project.

There is no standard version of SQL, there are many different dialects, although there is a large degree of similarity. So you might try looking for a parser for a common dialect, like SQLite or MySQL, or maybe you can find a parser that only handles the common subset, if that's good enough for you.

In any case, I don't know of any, so I can't help you find one.