4 ms·
I like this, but am trying to figure out whether this is an option/possible: 1. Utilize an abstraction to connect to the database or what connection string is
by dmarlow 8y ago
I like this, but am trying to figure out whether this is an option/possible:
1. Utilize an abstraction to connect to the database or what connection string is used. For example, using AAD vs shared credentials when connecting to the DB.
2. Centered around Stored Procedures. I'd like to have everyone focused on creating the SP and then having the model created automatically from that SP.
- bbsimonbb 8y agoAt design time, we use the connection string specified in the qfconfig.json file, or the one you specify in the .sql file. At run time, you supply the method that creates the connection, so you should be able to do whatever you want. Stored procedures are automatically supported. It's just SQL. We can discover the return type and create the wrapper just as we can for a query. But SQL in it's own file feels so much like stored procedures, you might prefer to store and version your SQL with your app code rather than create procedures that live in the database.