linq2db / linq2db.LINQPad

linq2db.LINQPad is a driver for LINQPad.
MIT License
74 stars 23 forks source link

SQL vs C# Language differences in table and query names #90

Closed wesj1s closed 1 year ago

wesj1s commented 1 year ago

I have discovered after upgrading the Linq To DB driver to version 5 that all of my database queries that reference a table name or field name containing an underscore character are broken and require modification to work.

I have found that when displaying the table names and fields in the Database browser (left top panel in LINQPad) while the SQL Language option is chosen, the fields have the expected (unmodified) names. Selecting any language option other than SQL displays modified entity names.

This breaking change should be behind an option. Please provide the ability restore the original operationality, honoring the entity names as per defined the database schema.