fsprojects / FSharp.Linq.ComposableQuery

Compositional Query Framework for F# Queries, based on "A Practical Theory of Language-Integrated Query"
http://fsprojects.github.io/FSharp.Linq.ComposableQuery/
MIT License
67 stars 13 forks source link

Use a variable for the database name in the creation SQL scripts. #11

Closed philderbeast closed 5 years ago

philderbeast commented 9 years ago

Instead of repeating the name of the database throughout the creation script, use SQLCMD mode to name the database. I suggest using a common prefix for FSharp.Linq.ComposableQuery to avoid name collisions with existing databases and instead of a missing db.config, set a config file that defaults to use the default instance of SQL on the local machine and uses databases with prefixed names. Prefer the use code page 1252 when saving these scripts so that diffs can be seen using source control tooling. Only people.sql has been saved in unicode. In github for windows, this shows a diff as 'binary files differ'.

:setvar DatabaseName "FCQ-People" :setvar DatabaseName "FCQ-Org" :setvar DatabaseName "FCQ-Xml" :setvar DatabaseName "FCQ-Simple"