var edge = require('edge');
var getProduct = edge.func('sql', function () {/*
select * from Products
where ProductId = @myProductId
*/});
getProduct({ myProductId: 10 }, function (error, result) {
if (error) throw error;
console.log(result);
});
This Code works well but I feel uncomfortable with setting the ConnectionString as ENVIROMENT_VARIALBE!
set EDGE_SQL_CONNECTION_STRING=Data Source=localhost;Initial Catalog=Northwind;Integrated Security=True
But I can´t find a different way to do this! Even on GitHub I can´t find another way on how to set ConnectionString! So I wonder is it even possible in OOB edge-sql.js to set the ConnectionString in Code?
After looking at the SourceCode of edge-sql, I was able to find out how it works, I wonder why on GitHub it is described with an EnviromentVariable?
Anyway here is the Code to set the ConnectionString in node.js :-)
var edge = require('edge');
var params = {
connectionString: "Data Source=localhost;Initial Catalog=ITSM_604;Integrated Security=True",
source: "select top 1 last_name from account_contact"
};
var getContacts = edge.func('sql', params);
getContacts(null, function(error, result){
if (error) throw error;
console.log(result);
});
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With