I am new to Node (coming from C#) and subsequently new to Edge.Js
I am trying to do a simple 'SELECT' statement from my database using Edge.
Can someone help me? I feel that I've copied the format according to Edge.Js' website, but i still get nothing.
var edge = require('edge');
var results = edge.func(function(){/*
# "edge-cs.dll"
using System.Data.OleDb;
using System.Threading.Tasks;
public class DB{
public async Task<object> Invoke (object input) {
string conn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\atrts04\drived\Applications\ATRAbstractingDB\Development\mtaylor\ABStest_be.accdb");
string query = "SELECT * FROM Orders WHERE OrderNumber = '" + OrderNumber + "';";
using (OleDbConnection connection = new OleDbConnection(conn))
{
OleDbCommand command = new OleDbCommand(query, connection);
connection.Open();
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
console.log(reader.GetInt32(0) + ", " + reader.GetString(1));
}
reader.Close();
}
return query;
}
}
*/});
results('55190369', function(error, result) {
if(error) throw error;
console.log("RESULTS: " + result);
});
router.get('/typing', function(req, res) {
results();
res.render('typing', { title: 'Page Title'});
});
module.exports = router;