search

cmeeren / Facil

Facil generates F# data access source code from SQL queries and stored procedures. Optimized for developer happiness.
MIT License
140 stars 7 forks source link

suggestion re: regular expressions case sensitivity #22

Closed costa100 closed 2 years ago

costa100 commented 2 years ago

Hi, One suggestion, in the yaml you might want to add a comment that the regular expressions used to match sql object names are case sensitive. It kind of took me by surprise, given that the database itself uses case insensitive comparisons, which is the out-of-the-box default for sql server.

You can include the following blurb: The regular expressions used to match sql object names are case sensitive. The regular expression can be prefixed with (?i) to make it case insensitive. Ex: (?i)(dbo\.SomeTableName1|dbo\.SomeTableName2) . Thanks

cmeeren commented 2 years ago

Thanks, I'll add something like that to the readme and reference YAML.