Edge.js: run .NET and Node.js in-process on Windows, Mac OS, and Linux
npm install electron-edgeelectron-edge
=============
Run .NET and Node.js code in-process on Electron. forked from Edge.js.
It is currently compatible with Electron-v1.6.2 (until node.js v7.4.0)
The usage is same as Edge.js. just replace require('edge') with require('electron-edge'):
``diff
-var edge = require('edge');
+var edge = require('electron-edge');
var helloWorld = edge.func(function () {/*
async (input) => {
return ".NET Welcomes " + input.ToString();
}
*/});
`
?can't load Edge.js module in electron.
because, electron use different version of node.js
you need to install same version of node.js and rebuild edge.js
electron-edge is precompiled edge.js for Electron.
please read this issue: https://github.com/kexplo/electron-edge/issues/2
You must install Visual Studio 2015 redist and .NET framework 4.5.
----
Edge.js: .NET and Node.js in-process 
====
NEW Edge.js is now on Slack at https://edgejs.slack.com. Join here.
An edge connects two nodes. This edge connects Node.js and .NET. V8 and CLR/.NET Core/Mono - in process. On Windows, MacOS, and Linux.
You can script C# from a Node.js process:
ES5
`javascript
var edge = require('edge');
var helloWorld = edge.func(function () {/*
async (input) => {
return ".NET Welcomes " + input.ToString();
}
*/});
helloWorld('JavaScript', function (error, result) {
if (error) throw error;
console.log(result);
});
`
ES6
In ES6 you can use template strings to write multiline C# code.
`javascript
var edge = require('edge');
var helloWorld = edge.func(
async (input) => {
return ".NET Welcomes " + input.ToString();
});
helloWorld('JavaScript', function (error, result) {
if (error) throw error;
console.log(result);
});
`
You can also script Node.js from C#:
`c#
using System;
using System.Threading.Tasks;
using EdgeJs;
class Program
{
public static async Task Start()
{
var func = Edge.Func(@"
return function (data, callback) {
callback(null, 'Node.js welcomes ' + data);
}
");
Console.WriteLine(await func(".NET"));
}
static void Main(string[] args)
{
Start().Wait();
}
}
`
> Ah, whatever problem you have. If you have this problem, this solves it.
--Scott Hanselman (@shanselman)
See the Edge.js overview.
Read the Edge.js introduction on InfoQ.
Listen to the Edge.js podcast on Herdingcode.
Introduction
Scripting CLR from Node.js
What you need
Windows
Linux
OSX
Docker
How to: C# hello, world
How to: integrate C# code into Node.js code
How to: specify additional CLR assembly references in C# code
How to: marshal data between C# and Node.js
How to: call Node.js from C#
How to: export C# function to Node.js
How to: script Python in a Node.js application
How to: script PowerShell in a Node.js application
How to: script F# in a Node.js application
How to: script Lisp in a Node.js application
How to: script T-SQL in a Node.js application
How to: support for other CLR languages
How to: exceptions
How to: app.config
How to: debugging
Performance
Building on Windows
Building on OSX
Building on Linux
Running tests
Scripting Node.js from CLR
What you need
How to: Node.js hello, world
How to: integrate Node.js into CLR code
How to: use Node.js built-in modules
How to: use external Node.js modules
How to: handle Node.js events in .NET
How to: expose Node.js state to .NET
How to: use Node.js in ASP.NET application
How to: debug Node.js code running in a CLR application
Building Edge.js NuGet package
Running tests of scripting Node.js in C#
Use cases and other resources
Contribution and derived work
Edge.js allows you to run Node.js and .NET code in one process on Windows, MacOS, and Linux.
You can call .NET functions from Node.js and Node.js functions from .NET. Edge.js takes care of marshalling data between CLR and V8. Edge.js also reconciles threading models of single threaded V8 and multi-threaded CLR. Edge.js ensures correct lifetime of objects on V8 and CLR heaps. The CLR code can be pre-compiled or specified as C#, F#, Python, or PowerShell source: Edge.js can compile CLR scripts at runtime. Edge can be extended to support other CLR languages or DSLs.
Edge.js provides an asynchronous, in-process mechanism for interoperability between Node.js and .NET. You can use this mechanism to:
* script Node.js from a .NET application (console app, ASP.NET, etc.)
* script C# from a Node.js application on Windows, MacOS, and Linux
* access MS SQL from Node.js using ADO.NET more...
* use CLR multi-threading from Node.js for CPU intensive work more...
* write native extensions to Node.js in C# instead of C/C++
* integrate existing .NET components into Node.js applications
Read more about the background and motivations of the project here.
Follow @tjanczuk for updates related to the module.
If you are writing a Node.js application, this section explains how you include and run CLR code in your app. It works on Windows, MacOS, and Linux.
Edge.js runs on Windows, Linux, and OSX and requires Node.js 6.x, 5.x, 4.x, 0.12.x, 0.10.x, or 0.8.x, as well as .NET Framework 4.5 (Windows), Mono 4.2.4 (OSX, Linux), or .NET Core 1.0.0 Preview 2 (Windows, OSX, Linux).
NOTE there is a known issue with Mono after 4.2.4 that will be addressed in Mono 4.6.
#### Windows
* Node.js 6.x, 5.x, 4.x, 0.12.x, 0.10.x, or 0.8.x
* .NET 4.5 and/or .NET Core
* to use Python, you also need IronPython 2.7.3 or later
* to use F#, read Dave Thomas blog post
If you have both desktop CLR and .NET Core installed, read using .NET Core for how to configure Edge to use one or the other.
#### Linux
* Node.js 6.x, 5.x, 4.x, 0.12.x, 0.10.x, or 0.8.x
* Mono 4.2.4 x64 and/or .NET Core
* Follow Linux setup instructions
#### OSX
* Node.js 6.x, 5.x, 4.x, 0.12.x, 0.10.x, or 0.8.x
* Mono 4.2.4 x64 and/or .NET Core
* Follow OSX setup instructions
#### Docker
Edge.js is available as a Docker image on the tjanczuk/edgejs repository on Docker Hub. The image is based on Debian Trusty, and contains Node.js 6.3.0 x64, Mono 4.2.4 x64, .NET Core 1.0.0 Preview 2 x64 (dotnet-dev-1.0.0-preview2-003121), and Edge.js 6.5.1:
By default Edge uses Mono to execute CLR code:
`
> docker run -it tjanczuk/edgejs:6.5.1
> cd samples
> node 101_hello_lambda.js
.NET welcomes Node.js
Specify the EDGE_USE_CORECLR=1 environment variable to use .NET Core instead:
`
> docker run -it tjanczuk/edgejs:6.5.1
> cd samples
> EDGE_USE_CORECLR=1 node 101_hello_lambda.js
.NET welcomes Node.js
Alternatively, you can also specify EDGE_USE_CORECLR when starting the container:
`
> docker run -it -e EDGE_USE_CORECLR=1 tjanczuk/edgejs:6.5.1
Follow setup instructions for your platform.
Install edge:
`
npm install edge
In your server.js:
`javascript
var edge = require('edge');
var helloWorld = edge.func(function () {/*
async (input) => {
return ".NET Welcomes " + input.ToString();
}
*/});
helloWorld('JavaScript', function (error, result) {
if (error) throw error;
console.log(result);
});
`
Run and enjoy:
`
$>node server.js
.NET welcomes JavaScript
If you want to use .NET Core as your runtime and are running in a dual runtime environment (i.e. Windows with .NET 4.5 installed as well or Linux with Mono installed), you will need to tell edge to use .NET Core by setting the EDGE_USE_CORECLR environment variable:
`
$>EDGE_USE_CORECLR=1 node server.js
.NET Welcomes JavaScript
Edge provides several ways to integrate C# code into a Node.js application. Regardless of the way you choose, the entry point into the .NET code is normalized to a Func delegate. This allows Node.js code to call .NET asynchronously and avoid blocking the Node.js event loop.
Edge provides a function that accepts a reference to C# code in one of the supported representations, and returns a Node.js function which acts as a JavaScript proxy to the Func .NET delegate:
`javascript
var edge = require('edge');
var myFunction = edge.func(...);
`
The function proxy can then be called from Node.js like any asynchronous function:
`javascript`
myFunction('Some input', function (error, result) {
//...
});
Alternatively, if you know the C# implementation will complete synchronously given the circumstances, you can call this function as any synchronous JavaScript function as follows:
`javascript`
var result = myFunction('Some input', true);
The true parameter instead of a callback indicates that Node.js expects the C# implementation to complete synchronously. If the CLR function implementation does not complete synchronously, the call above will result in an exception.
One representation of CLR code that Edge.js accepts is C# source code. You can embed C# literal representing a .NET async lambda expression implementing the Func delegate directly inside Node.js code:
`javascript`
var add7 = edge.func('async (input) => { return (int)input + 7; }');
In another representation, you can embed multi-line C# source code by providing a function with a body containing a multi-line comment. Edge extracts the C# code from the function body using regular expressions:
`javascript`
var add7 = edge.func(function() {/*
async (input) => {
return (int)input + 7;
}
*/});
Or if you use ES6 you can use template strings to define a multiline string:
`javascript
var add7 = edge.func(
async (input) => {
return (int)input + 7;
});`
If your C# code is more involved than a simple lambda, you can specify entire class definition. By convention, the class must be named Startup and it must have an Invoke method that matches the Func delegate signature. This method is useful if you need to factor your code into multiple methods:
`javascript
var add7 = edge.func(function() {/*
using System.Threading.Tasks;
public class Startup
{
public async Task
static class Helper
{
public static int AddSeven(int v)
{
return v + 7;
}
}
*/});
`
If your C# code grows substantially, it is useful to keep it in a separate file. You can save it to a file with .csx or .cs extension, and then reference from your Node.js application:
`javascript`
var add7 = edge.func(require('path').join(__dirname, 'add7.csx'));
If you integrate C# code into your Node.js application by specifying C# source using one of the methods above, edge will compile the code on the fly. If you prefer to pre-compile your C# sources to a CLR assembly, or if your C# component is already pre-compiled, you can reference a CLR assembly from your Node.js code. In the most generic form, you can specify the assembly file name, the type name, and the method name when creating a Node.js proxy to a .NET method:
`javascript`
var clrMethod = edge.func({
assemblyFile: 'My.Edge.Samples.dll',
typeName: 'Samples.FooBar.MyType',
methodName: 'MyMethod' // This must be Func
});
If you don't specify methodName, Invoke is assumed. If you don't specify typeName, a type name is constructed by assuming the class called Startup in the namespace equal to the assembly file name (without the .dll). In the example above, if typeName was not specified, it would default to My.Edge.Samples.Startup.
The assemblyFile is relative to the working directory. If you want to locate your assembly in a fixed location relative to your Node.js application, it is useful to construct the assemblyFile using __dirname. If you are using .NET Core, assemblyFile can also be a project name or NuGet package name that is specified in your project.json or .deps.json dependency manifest.
You can also create Node.js proxies to .NET functions specifying just the assembly name as a parameter:
`javascript`
var clrMethod = edge.func('My.Edge.Samples.dll');
In that case the default typeName of My.Edge.Samples.Startup and methodName of Invoke is assumed as explained above.
When you provide C# source code and let edge compile it for you at runtime, edge will by default reference only mscorlib.dll and System.dll assemblies. If you're using .NET Core, we automatically reference the most recent versions of the System.Runtime, System.Threading.Tasks, System.Dynamic.Runtime, and the compiler language packages, like Microsoft.CSharp. In applications that require additional assemblies you can specify them in C# code using a special hash pattern, similar to Roslyn. For example, to use ADO.NET you must reference System.Data.dll:
`javascript
var add7 = edge.func(function() {/*
#r "System.Data.dll"
using System.Data;
using System.Threading.Tasks;
public class Startup
{
public async Task
If you prefer, instead of using comments you can specify references by providing options to the edge.func call:
`javascript
var add7 = edge.func({
source: function() {/*
using System.Data;
using System.Threading.Tasks;
public class Startup
{
public async Task
If you are using .NET Core and are using the .NET Core SDK and CLI, you must have a project.json file (specification here) that specifies the dependencies for the application. This list of dependencies must also include the Edge.js runtime package and, if you need to be able to dynamically compile your code, the package(s) for the compilers that you plan to use, like Edge.js.CSharp. You must have run the dotnet restore (to restore the dependencies) and dotnet build (to build your project and generate the dependency manifest) commands in that project's directory to generate a .deps.json file under bin/[configuration]/[framework], i.e. bin/Release/netstandard1.6/MyProject.deps.json. This .deps.json file must either be in the current working directory that node is executed in or you must specify its directory by setting the EDGE_APP_ROOT environment variable. For example, if for a netstandard1.6 project in the c:\DotNet\MyProject directory, you would run something like:
`
set EDGE_APP_ROOT=c:\DotNet\MyProject\bin\Release\netstandard1.6
node app.js
Edge.js also supports running published .NET Core applications on servers that do not have the .NET Core SDK and CLI installed, which is a common scenario in production environments. To do so, the project.json for your application should meet the following requirements:
1. It should target the netcoreapp1.0 framework moniker.Microsoft.NETCore.DotNetHost
2. It should reference and Microsoft.NETCore.DotNetHostPolicy. This is required so that the publish process can provide all the native libraries required to create a completely standalone version of your application."emitEntryPoint": true
3. should be present under buildOptions. You can add an empty Main() implementation to your project to accomodate it; this method will not be called, but is just a requirement in order for dotnet publish to generate a completely standalone app.
On your development machine, you would run dotnet publish -r [target runtime for your production server] (i.e. dotnet publish -r ubuntu.14.04-x64) to aggregate the package assemblies and native libraries necessary to run your application. You can copy the contents of the publish directory up to your SDK- and CLI-less server and use them directly in Edge.js by setting the EDGE_APP_ROOT environment variable to the directory on the server that you copied the published application to.
Edge.js can marshal any JSON-serializable value between .NET and Node.js (although JSON serialization is not used in the process). Edge also supports marshalling between Node.js Buffer instance and a CLR byte[] array to help you efficiently pass binary data.
You can call .NET from Node.js and pass in a complex JavaScript object as follows:
`javascript
var dotNetFunction = edge.func('Edge.Sample.dll');
var payload = {
anInteger: 1,
aNumber: 3.1415,
aString: 'foo',
aBoolean: true,
aBuffer: new Buffer(10),
anArray: [ 1, 'foo' ],
anObject: { a: 'foo', b: 12 }
};
dotNetFunction(payload, function (error, result) { });
`
In .NET, JavaScript objects are represented as dynamics (which can be cast to IDictionary if desired), JavaScript arrays as object[], and JavaScript Buffer as byte[]. Scalar JavaScript values have their corresponding .NET types (int, double, bool, string). Here is how you can access the data in .NET:
`c#
using System.Threading.Tasks;
public class Startup
{
public async Task
return null;
}
}
`
Similar type marshalling is applied when .NET code passes data back to Node.js code. In .NET code you can provide an instance of any CLR type that would normally be JSON serializable, including domain specific types like Person or anonymous objects. For example:
`c#
using System.Threading.Tasks;
public class Person
{
public int anInteger = 1;
public double aNumber = 3.1415;
public string aString = "foo";
public bool aBoolean = true;
public byte[] aBuffer = new byte[10];
public object[] anArray = new object[] { 1, "foo" };
public object anObject = new { a = "foo", b = 12 };
}
public class Startup
{
public async Task
In your Node.js code that invokes this .NET method you can display the result object that the callback method receives:
`javascript
var edge = require('edge');
var getPerson = edge.func(function () {/*
using System.Threading.Tasks;
public class Person
{
public int anInteger = 1;
public double aNumber = 3.1415;
public string aString = "foo";
public bool aBoolean = true;
public byte[] aBuffer = new byte[10];
public object[] anArray = new object[] { 1, "foo" };
public object anObject = new { a = "foo", b = 12 };
}
public class Startup
{
public async Task
getPerson(null, function (error, result) {
if (error) throw error;
console.log(result);
});
`
Passing this .NET object to Node.js generates a JavaScript object as follows:
`
$>node sample.js
{ anInteger: 1,
aNumber: 3.1415,
aString: 'foo',
aBoolean: true,
aBuffer:
anArray: [ 1, 'foo' ],
anObject: { a: 'foo', b: 12 } }
When data is marshalled from .NET to Node.js, no checks for circular references are made. They will typically result in stack overflows. Make sure the object graph you are passing from .NET to Node.js is a tree and does not contain any cycles.
WINDOWS ONLY When marshalling strongly typed objects (e.g. Person) from .NET to Node.js, you can optionally tell Edge.js to observe the System.Web.Script.Serialization.ScriptIgnoreAttribute. You opt in to this behavior by setting the EDGE_ENABLE_SCRIPTIGNOREATTRIBUTE environment variable:
`
set EDGE_ENABLE_SCRIPTIGNOREATTRIBUTE=1
Edge.js by default does not observe the ScriptIgnoreAttribute to avoid the associated performance cost.
In addition to marshalling data, edge can marshal proxies to JavaScript functions when invoking .NET code from Node.js. This allows .NET code to call back into Node.js.
Suppose the Node.js application passes an add function to the .NET code as a property of an object. The function receives two numbers and returns the sum of them via the provided callback:
`javascript
var edge = require('edge');
var addAndMultiplyBy2 = edge.func(function () {/*
async (dynamic input) => {
var add = (Func
var twoNumbers = new { a = (int)input.a, b = (int)input.b };
var addResult = (int)await add(twoNumbers);
return addResult * 2;
}
*/});
var payload = {
a: 2,
b: 3,
add: function (data, callback) {
callback(null, data.a + data.b);
}
};
addAndMultiplyBy2(payload, function (error, result) {
if (error) throw error;
console.log(result);
});
`
The .NET code implements the addAndMultiplyBy2 function. It extracts the two numbers passed from Node.js, calls back into the add function exported from Node.js to add them, multiplies the result by 2 in .NET, and returns the result back to Node.js:
`
$>node sample.js
10
The Node.js function exported from Node.js to .NET must follow the prescriptive async pattern of accepting two parameters: payload and a callback. The callback function accepts two parameters. The first one is the error, if any, and the second the result of the operation:
`javascript
function (payload, callback) {
var error; // must be null or undefined in the absence of error
var result;
// do something
callback(error, result);
}
`
The proxy to that function in .NET has the following signature:
`c#`
Func
Using TPL in CLR to provide a proxy to an asynchronous Node.js function allows the .NET code to use the convenience of the await keyword when invoking the Node.js functionality. The example above shows the use of the await keyword when calling the proxy of the Node.js add method.
Similarly to marshalling functions from Node.js to .NET, Edge.js can also marshal functions from .NET to Node.js. The .NET code can export a Func delegate to Node.js as part of the return value of a .NET method invocation. For example:
`javascript
var createHello = edge.func(function () {/*
async (input) =>
{
return (Func
Console.WriteLine("Hello from .NET");
return null;
});
}
*/});
var hello = createHello(null, true);
hello(null, true); // prints out "Hello from .NET"
`
This mechanism in conjunction with a closure can be used to expose CLR class instances or CLR state in general to JavaScript. For example:
`javascript
var createCounter = edge.func(function () {/*
async (input) =>
{
var k = (int)input;
return (Func
}
*/});
var counter = createCounter(12, true); // create counter with 12 as initial state
console.log(counter(null, true)); // prints 13
console.log(counter(null, true)); // prints 14
`
NOTE This functionality requires IronPython and has been tested on Windows only.
Edge.js enables you to run Python and Node.js in-process.
In addition to platform specific prerequisites you need IronPython 2.7.3 to proceed.
#### Hello, world
Install edge and edge-py modules:
`
npm install edge
npm install edge-py
In your server.js:
`javascript
var edge = require('edge');
var hello = edge.func('py', function () {/*
def hello(input):
return "Python welcomes " + input
lambda x: hello(x)
*/});
hello('Node.js', function (error, result) {
if (error) throw error;
console.log(result);
});
`
Run and enjoy:
`
$>node py.js
Python welcomes Node.js
#### The interop model
Your Python script must evaluate to a lambda expression that accepts a single parameter. The parameter represents marshalled input from the Node.js code. The return value of the lambda expression is passed back as the result to Node.js code. The Python script can contain constructs (e.g. Python functions) that are used in the closure of the lambda expression. The instance of the script with associated state is created when edge.func is called in Node.js. Each call to the function referes to that instance.
The simplest echo Python script you can embed in Node.js looks like this:
`python`
lambda x: x
To say hello, you can use something like this:
`python`
lambda: x: "Hello, " + x
To maintain a running sum of numbers:
`python
current = 0
def add(x):
global current
current = current + x
return current
lambda x: add(x)
`
#### Python in its own file
You can reference Python script stored in a *.py file instead of embedding Python code in a Node.js script.
In your hello.py file:
`python
def hello(input):
return "Python welcomes " + input
lambda x: hello(x)
`
In your hello.js file:
`javascript
var edge = require('edge');
var hello = edge.func('py', 'hello.py');
hello('Node.js', function (error, result) {
if (error) throw error;
console.log(result);
});
`
Run and enjoy:
`
$>node hello.js
Python welcomes Node.js
#### To sync or to async, that is the question
In the examples above Python script was executing asynchronously on its own thread without blocking the singleton V8 thread on which the Node.js event loop runs. This means your Node.js application remains responsive while the Python code executes in the background.
If you know your Python code is non-blocking, or if you know what you are doing, you can tell Edge.js to execute Python code on the singleton V8 thread. This will improve performance for non-blocking Python scripts embedded in a Node.js application:
`javascript
var edge = require('edge');
var hello = edge.func('py', {
source: function () {/*
def hello(input):
return "Python welcomes " + input
lambda x: hello(x)
*/},
sync: true
});
console.log(hello('Node.js', true));
`
The sync: true property in the call to edge.func tells Edge.js to execute Python code on the V8 thread as opposed to creating a new thread to run Python script on. The true parameter in the call to hello requests that Edge.js does in fact call the hello function synchronously, i.e. return the result as opposed to calling a callback function.
NOTE This functionality only works on Windows.
Edge.js enables you to run PowerShell and Node.js in-process on Windows. Edge-PS connects the PowerShell ecosystem with Node.js.
You need Windows, Node.js, .NET 4.5, and PowerShell 3.0 to proceed.
Install edge and edge-ps modules:
` `
npm install edge
npm install edge-ps
In your server.js:
`javascript
var edge = require('edge');
var hello = edge.func('ps', function () {/*
"PowerShell welcomes $inputFromJS on $(Get-Date)"
*/});
hello('Node.js', function (error, result) {
if (error) throw error;
console.log(result[0]);
});
`
Run and enjoy:
`
C:\testEdgeps>node server
PowerShell welcomes Node.js on 05/04/2013 09:38:40
#### Tapping into PowerShell's ecosystem
Rather than embedding PowerShell directly, you can use PowerShell files, dot source them and even use Import-Module.
What you can do in native PowerShell works in Node.js.
#### Interop PowerShell and Python
Here you can reach out to IronPython from PowerShell from within Node.js on Windows. This holds true for working with JavaScript frameworks and C#.
`javascript
var edge = require('edge');
var helloPowerShell = edge.func('ps', function () {/*
"PowerShell welcomes $inputFromJS"
*/});
var helloPython = edge.func('py', function () {/*
def hello(input):
return "Python welcomes " + input
lambda x: hello(x)
*/});
helloPython('Node.js', function(error, result){
if(error) throw error;
helloPowerShell(result, function(error, result){
if(error) throw error;
console.log(result[0]);
});
});
`
NOTE This functionality has not been tested on non-Windows platforms.
This section is coming up. In the meantime please refer to Dave Thomas blog post. This has been validated on Windows only.
`javascript
var edge = require('edge');
var helloFs = edge.func('fs', function () {/*
fun input -> async {
return "F# welcomes " + input.ToString()
}
*/});
helloFs('Node.js', function (error, result) {
if (error) throw error;
console.log(result);
});
`
NOTE This functionality has not been tested on non-Windows platforms.
The edge-lsharp extension uses LSharp to compile and run Lisp to .NET.
Install edge and edge-lsharp modules:
`
npm install edge
npm install edge-lsharp
In your server.js:
`javascript
var edge = require('edge');
var fact = edge.func('lsharp', function(){/*
;; Factorial
(def fact(n)
(if (is n 0) 1 (* n (fact (- n 1)))))
*/});
fact([5], function(err, answer){
console.log(answer);
// = 120
});
`
An LSharp filename can be passed in instead of the Lisp string/comment:
`js
var edge = require('edge');
var lisp = edge.func('lsharp', 'lisp-func.ls');
lisp(['arg1', 'arg2'], function(err, result){
});
`
In Lisp you can specify either a function (as shown in the first example) or just return a value:
`js
var edge = require('edge');
var lisp = edge.func('lsharp', '(+ 2 3)');
lisp([], function(err, answer){
console.log(answer);
// = 5
});
`
NOTE This functionality has only been tested on Windows. Although ADO.NET exist in Mono, your mileage can vary.
The edge-sql extension of Edge.js allows for accessing MS SQL databases by scripting T-SQL inside the Node.js application. The edge-sql extension uses async ADO.NET SQL client to access MS SQL.
You need Windows, Node.js, and .NET 4.5. To run the sample code below you also need a connection string to the sample Northwind database that ships with MS SQL.
#### Hello, world
Install edge and edge-sql modules:
`
npm install edge
npm install edge-sql
Set the connection string as an environment variable (your connection string may be different):
`
set EDGE_SQL_CONNECTION_STRING=Data Source=localhost;Initial Catalog=Northwind;Integrated Security=True
In your server.js:
`javascript
var edge = require('edge');
var getTop10Products = edge.func('sql', function () {/*
select top 10 * from Products
*/});
getTop10Products(null, function (error, result) {
if (error) throw error;
console.log(result);
console.log(result[0].ProductName);
console.log(result[1].ReorderLevel);
});
`
Run and enjoy:
`
C:\projects\edge\samples>node server.js
[ { ProductID: 10,
ProductName: 'New Ikura',
SupplierID: 4,
CategoryID: 8,
QuantityPerUnit: '12 - 200 ml jars',
UnitPrice: '31.000',
UnitsInStock: 31,
UnitsOnOrder: 0,
ReorderLevel: 0,
Discontinued: false },
...
]
New Ikura
12
#### Parameterized queries
You can construct a parameterized query once and provide parameter values on a per-call basis:
`javascript
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);
});
`
#### Basic CRUD support: select, update, insert, delete
The four basic CRUD operations are supported. For example, here is how an update can look like:
`javascript
var edge = require('edge');
var updateProductName = edge.func('sql', function () {/*
update Products
set ProductName = @newName
where ProductId = @myProductId
*/});
updateProductName({ myProductId: 10, newName: 'New Ikura' }, function (error, result) {
if (error) throw error;
console.log(result);
});
`
Edge.js can work with any pre-compiled CLR assembly that contains the Func delegate. Out of the box, Edge.js also allows you to embed C# source code in a Node.js application and compile it on the fly.
To enable compilation of other CLR languages (e.g. F#) at runtime, or to support domain specific languages (DSLs) like T-SQL, you can use the compiler composability model provided by Edge.js. Please read the add support for a CLR language guide to get started.
Edge.js marshals Node.js errors and exceptions to .NET as well as .NET exceptions to Node.js.
CLR exceptions thrown in .NET code invoked from Node.js are marshalled as the error parameter to the Node.js callback function. Consider this example:
`javascript
var edge = require('edge');
var clrFunc = edge.func(function () {/*
async (dynamic input) => {
throw new Exception("Sample exception");
}
*/});
clrFunc(null, function (error, result) {
if (error) {
console.log('Is Error?', error instanceof Error);
console.log('-----------------');
console.log(util.inspect(error, showHidden=true, depth=99, colorize=false));
return;
}
});
`
Running this Node.js application shows that the CLR exception was indeed received by the Node.js callback. The error parameter contains an Error object having most of the properties of the Exceptions copied over:`
Is Error? true
-----------------
{ [System.AggregateException: One or more errors occurred.]
message: 'One or more errors occurred.',
name: 'System.AggregateException',
InnerExceptions: 'System.Collections.ObjectModel.ReadOnlyCollection
Message: 'One or more errors occurred.',
Data: 'System.Collections.ListDictionaryInternal',
InnerException:
{ [System.Exception: Sample exception]
message: 'Sample exception',
name: 'System.Exception',
Message: 'Sample exception',
Data: 'System.Collections.ListDictionaryInternal',
TargetSite: 'System.Reflection.RuntimeMethodInfo',
StackTrace: ' at Startup.<1.GetResult()\r\n at Startup.`
Source: 'cp2luegt',
HResult: -2146233088 },
HResult: -2146233088 }
The exception is copied back as Error object like every normal result object from the .NET world to JavaScript.
Therefore all properties and their values are available on the Error object.
Additionally, the following happens during the mapping:
* To represent the Exception type, its full name is stored as name.Message
* To follow the JavaScript convention for Errors, the is also stored as the property message.System::Reflection::RuntimeMethodInfo
* s are not copied to avoid stack overflows
`
$>node sample.js
Edge.js:58
edge.callClrFunc(appId, data, callback);
^
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
---> System.Exception: Sample exception
at Startup.Invoke(Object input) in sample.cs:line 12
`
JavaScript exceptions thrown in Node.js code invoked from .NET are wrapped in a CLR exception and cause the asynchronous Task
`javascript
var edge = require('edge');
var multiplyBy2 = edge.func(function () {/*
async (dynamic input) => {
var aFunctionThatThrows = (Func
try {
var aResult = await aFunctionThatThrows(null);
}
catch(Exception e)
{
Console.WriteLine(e);
}
return null;
}
*/});
var payload = {
someParameter: 'arbitrary parameter',
aFunctionThatThrows: function (data, callback) {
throw new Error('Sample JavaScript error');
}
};
multiplyBy2(payload, function (error, result) {
if (error) throw error;
console.log(result);
});
`
Running the code shows the .NET code receiving a CLR exception as a result of the Node.js function throwing a JavaScript error. The exception shows the complete stack trace, including the part that executed in the Node.js code:
`
$>node sample.js
System.Exception: Error: Sample JavaScript error
at payload.aFunctionThatThrows (sample.js:7:11)
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Edge.Sample.Startup.
When running C# code within Node.js app, the app config file is node.exe.config and should be located right next to the node.exe file.
NOTE This is Windows-only functionality.
On Windows, you can debug the .NET code running as part of your Node.js application by attaching a managed code debugger (e.g. Visual Studio) to node.exe. You can debug .NET code in a pre-compiled CLR assembly as well C# literals embedded in the application and compiled by Edge.js at runtime.
#### Debugging pre-compiled .NET code
If you have integrated .NET code into a Node.js application using a pre-compiled CLR assembly like this:
`javascript`
var hello = edge.func('My.Assembly.dll');
then the best way to debug your .NET code is to attach a managed code debugger (e.g. Visual Studio) to the node.exe process. Since the node.exe process runs both native and managed code, make sure to select managed code type as target:
From there, you can set breakpoints in your .NET code and the debugger will stop when they are reached.
#### Debugging embedded C# code
Debugging embedded C# code (on Windows) requires that EDGE_CS_DEBUG environment variable is set in the environment of the node.exe process:
`
set EDGE_CS_DEBUG=1
Without this setting (the default), Edge.js will not generate debugging information when compiling embedded C# code.
You can debug C# code embedded into a Node.js application using a reference to a .cs or .csx file:
`javascript`
var hello = edge.func('MyClass.cs');
You can also debug C# code embedded directly into a *.js file using the function comment syntax:
`javscript`
var hello = edge.func(function () {/*
async (input) =>
{
System.Diagnostics.Debugger.Break();
var result = ".NET welcomes " + input.ToString();
return result;
}
*/});
You cannot debug C# code embedded as a simple string literal:
`javascript`
var hello = edge.func('async (input) => { return 2 * (int)input; }');
After setting EDGE_CS_DEBUG=1 environment variable before starting node.exe and attaching the managed debugger to the node.exe process, you can set breakpoints in C# code (which may appear as a JavaScript comment), or use System.Diagnostics.Debugger.Break() to break into the debugger from .NET code.
Read more about performance of Edge.js on the wiki. Here is the gist of the latency (smaller is better):
You must have Visual Studio 2015 toolset, Python 2.7.x, and node-gyp installed for building.
To build and test the project against all supported versions of Node.js in x86 and x64 flavors, run the following:
`
tools\buildall.bat
test\testall.bat
npm run jshint
To build one of the versions of Node.js officially released by Node.js, do the following:
`
cd tools
build.bat release 6.4.0
Note: the Node.js version number you provide must be version number corresponding to one of the subdirectories of http://nodejs.org/dist. The command will build both x32 and x64 architectures (assuming you use x64 machine). The command will also copy the edge\_\.node executables to appropriate locations under lib\native directory where they are looked up from at runtime. The npm install step copies the C standard library shared DLL to the location of the edge\_\.node files for the component to be ready to go.
To build the C++\CLI native extension using the version of Node.js installed on your machine, issue the following command:
`
npm install -g node-gyp
node-gyp configure --msvs_version=2015
node-gyp build -debug
You can then set the EDGE_NATIVE environment variable to the fully qualified file name of the built edge_\*.node binary (edge\_nativeclr.node if you're using the native CLR runtime or edge\_coreclr.node if you're using .NET Core). It is useful during development, for example:
`
set EDGE_NATIVE=C:\projects\edge\build\Debug\edge_nativeclr.node
You can also set the EDGE_DEBUG environment variable to 1 to have the edge module generate debug traces to the console when it runs.
You must have mocha installed on the system. Then:
`
npm test
or, from the root of the enlistment:
`
mocha -R spec
NOTE in environments with both desktop CLR/Mono and .NET Core installed, tests will by default use desktop CLR/Mono. To run tests against .NET Core, use:
`
EDGE_USE_CORECLR=1 npm test
#### Node.js version targeting on Windows
NOTE this is Windows only functionality.
If you want to run tests after building against a specific version of Node.js that one of the previous builds used, issue the following command:
`
cd test
test.bat ia32 0.10.0
Which will run the tests using Node.js x86 v0.10.0. Similarly:
`
cd test
test.bat x64 0.8.22
Would run tests against Node.js 0.8.22 on x64 architecture.
Lastly, you can run jshint on the project with:
`
npm run jshint
Prerequisities:
* Homebrew
* Mono x64 and/or .NET Core - see below
* Node.js x64 (tested with v4.1.1)
You can use Edge.js on OSX with either Mono or .NET Core installed, or both.
If you choose to install Mono, select the universal installer to make sure you get the x64 version. Edge.js requires Mono x64. If you choose to install .NET Core, follow the steps here
Then install and build Edge.js:
`bash`
brew install pkg-config
npm install edge
NOTE if the build process complains about being unable to locate Mono libraries, you may need to specify the search path explicitly. This may be installation dependent, but in most cases will look like:
`bash`
PKG_CONFIG_PATH=/Library/Frameworks/Mono.framework/Versions/Current/lib/pkgconfig \
npm install edge
If you installed both Mono and .NET Core, by default Edge will use Mono. You opt in to using .NET Core with the EDGE_USE_CORECLR environment variable:
`bash`
EDGE_USE_CORECLR=1 node myapp.js
#### Building on OSX (advanced)
To build edge from a clone of the repository or source code:
`bash`
node-gyp configure build
To build a debug build instead of release, you need to:
`bash`
node-gyp configure build -debug
export EDGE_NATIVE=/Users/tomek/edge/build/Debug/edge_nativeclr.node
For a normative set of steps to set up Edge.js on Linux with both Mono and CoreCLR please refer to the Dockerfile. You can also use the ready-made Docker image.
If you have only .NET Core installed on your system and not Mono, you can run Edge with no changes. However, if you have both runtimes installed, Edge will automatically use Mono unless directed otherwise. To use .NET Core in a dual-runtime environment, set the EDGE_USE_CORECLR=1 environment variable when starting node, i.e.
`bash`
EDGE_USE_CORECLR=1 node sample.js
Edge will try to find the .NET Core runtime in the following locations:
* The path in the CORECLR_DIR environment variable, if providededge_.node
* The current directory
The directory containing
* Directories in the environment variable. Once a directory containing the dotnet executable is located, we then do the following to decide which version of the framework (you can have several installed at once) to loadCORECLR_VERSION
* If the environment variable was specified, we try to load that versionMicrosoft.NETCore.App
Else, if the project.json/.deps.json has a reference to , indicating that it was built for a specific framework version, we try to load that versionCORECLR_DIR
* Otherwise, we pick the maximum installed version
So, if the CLR is another location or you want to use a version of the CLR other than the default that you've set, the best way to specify that is through the or CORECLR_VERSION environment variables, i.e.
`bash`
EDGE_USE_CORECLR=1 \
CORECLR_DIR=/usr/share/dotnet/dnx-coreclr-linux-x64.1.0.0-beta6-11944 \
node sample.js
If you are writing a CLR application (e.g. a C# console application or ASP.NET web app), this section explains how you include and run Node.js code in your app. Currently it works on Windows using desktop CLR, but support for MacOS, and Linux as well as .NET Core is coming soon.
You need Windows with:
* .NET 4.5
* Edge.js NuGet package
* Node.js (optional, if you want to use additional NPM packages)
Edge.js support for scripting Node.js ships as a NuGet Package called Edge.js. It comes with everything you need to get started writing applications for x86 and x64 architectures. However, if you want to use additional Node.js packages from NPM, you must separately install Node.js runtime to access the NPM package manager. Edge.js NuGet package has been developed and tested with Node.js v6.5.0. Older Edge.js packages exist for prior versions of Node.js. If you choose a different version of Node.js to install NPM packages, your mileage can vary.
NOTE you cannot use native Node.js extensions when scripting Node.js from CLR using Edge.
You can install the Edge.js NuGet package using the Visual Studio built-in NuGet package management functionality or using the stand-alone NuGet client.
Create a .NET 4.5 Console Application in Visual Studio. Add the Edge.js NuGet package to the project. Then in your code:
`c#
using System;
using System.Threading.Tasks;
using EdgeJs;
class Program
{
public static async Task Start()
{
var func = Edge.Func(@"
return function (data, callback) {
callback(null, 'Node.js welcomes ' + data);
}
");
Console.WriteLine(await func(".NET"));
}
static void Main(string[] args)
{
Start().Wait();
}
}
`
Compile and run:
`
C:\project\sample\bin\Debug> sample.exe
Node.js welcomes .NET
The Edge.js NuGet package contains a single managed assembly EdgeJs.dll with a single class EdgeJs.Edge exposing a single static function Func. The function accepts a string containing code in Node.js that constructs and returns a JavaScript function. The JavaScript function must have the signature required by Edge.js's prescriptive interop pattern: it must accept one parameter and a callback, and the callback must be called with an error and one return value:
`c#`
var func = Edge.Func(@"
return function (data, callback) {
callback(null, 'Hello, ' + data);
}
");
Edge.js creates a Func delegate in CLR that allows .NET code to call the Node.js function asynchronously. You can use the standard TPL mechanisms or the async/await keywords to conveniently await completion of the asynchornous Node.js function:
`c#`
var result = await func(".NET");
// result == "Hello, .NET"
Note that the Node.js code snippet is not a function definition. Instead it must create and return a function instance. This allows you to initialize and maintain encapsulated Node.js state associated with the instance of the created function. The initialization code will execute only once when you call Edge.Func. Conceptually this is similar to defining a Node.js module that exports a single function (by returning it to the caller). For example:
`c#
var increment = Edge.Func(@"
var current = 0;
return function (data, callback) {
current += data;
callback(null, current);
}
");
Console.WriteLine(await increment(4)); // outputs 4
Console.WriteLine(await increment(7)); // outputs 11
`
Using multiline C# string literals is convenient for short Node.js code snippets, but you may want to store larger Node.js code in its own *.js file or files.
One pattern is to store your Node.js code in a myfunc.js file:
`javascript`
return function (data, callback) {
callback(null, 'Node.js welcomes ' + data);
}
And then load such file into memory with File:
`c#`
var func = Edge.Func(File.ReadAllText("myfunc.js"));
Another pattern is to define a Node.js module that itself is a function:
`javascript`
module.exports = function (data, callback) {
callback(null, 'Node.js welcomes ' + data);
};
And then load and return this module with a short snippet of Node.js:
`c#`
var func = Edge.Func(@"return require('./../myfunc.js')");
(Note the relative location of the file).
You can use Node.js built-in modules out of the box. For example, you can set up a Node.js HTTP server hosted in a .NET application and call it from C#:
`c#
var createHttpServer = Edge.Func(@"
var http = require('http');
return function (port, cb) {
var server = http.createServer(function (req, res) {
res.end('Hello, world! ' + new Date());
}).listen(port, cb);
};
");
await createHttpServer(8080);
Console.WriteLine(await new WebClient().DownloadStringTaskAsync("http://localhost:8080"));
`
You can use external Node.js modules, for example modules installed from NPM.
Note: Most Node.js modules are written in JavaScript and will execute in Edge as-is. However, some Node.js external modules are native binary modules, rebuilt by NPM on module installation to suit your local execution environment. Native binary modules will not run in Edge unless they are rebuilt to link against the NodeJS dll that Edge uses.
To install modules from NPM, you must first install Node.js on your machine and use the npm package manager that comes with the Node.js installation. NPM modules must be installed in the directory where your build system places the Edge.js NuGet package (most likely the same location as the rest of your application binaries), or any ancestor directory. Alternatively, you can install NPM modules globally on the machine using npm install -g:
`
C:\projects\websockets> npm install ws
...
ws@0.4.31 node_modules\ws
├── tinycolor@0.0.1
├── options@0.0.5
├── nan@0.3.2
└── commander@0.6.1
You can then use the installed ws module to create a WebSocket server inside of a .NET application:
`c#
class Program
{
public static async void Start()
{
var createWebSocketServer = Edge.Func(@"
var WebSocketServer = require('ws').Server;
return function (port, cb) {
var wss = new WebSocketServer({ port: port });
wss.on('connection', function (ws) {
ws.on('message', function (message) {
ws.send(message.toUpperCase());
});
ws.send('Hello!');
});
cb();
};
");
await createWebSocketServer(8080);
}
static void Main(string[] args)
{
Task.Run((Action)Start);
new ManualResetEvent(false).WaitOne();
}
}
`
This WebSocket server sends a Hello message to the client when a new connection is established, and then echos a capitalized version of every message it receives back to the client. You can test this webserver with the wscat tool included with the ws module. To make it convenient to use, first install the ws module globally:
`
npm install ws -g
Then start the .NET application conatining the WebSocket server and establish a connection to it with wscat:
`
C:\projects\websockets> wscat -c ws://localhost:8080/
connected (press CTRL+C to quit)
< Hello!
> foo
< FOO
> bar
< BAR
`
A self-contained Node.js WebSocket server, even if running within a .NET application, is rather unexciting. After all, the same could be accomplished with a stand-alone Node.js process. Ideally you could extablish a WebSocket server in Node.js, but handle the messages in .NET. Let's do it - read on.
It is often useful to handle certain events raised by the Node.js code within .NET. For example, you may want to establish a WebSocket server in Node.js, and handle the incoming messages in the .NET part of your application. This can be accomplished by passig a .NET callback function to Node.js when the the WebSocket server is created:
`c#
class Program
{
public static async void Start()
{
// Define an event handler to be called for every message from the client
var onMessage = (Func
{
return "Received string of length " + ((string)message).Length;
});
// The WebSocket server delegates handling of messages from clients
// to the supplied .NET handler
var createWebSocketServer = Edge.Func(@"
var WebSocketServer = require('ws').Server;
return function (options, cb) {
var wss = new WebSocketServer({ port: options.port });
wss.on('connection', function (ws) {
ws.on('message', function (message) {
options.onMessage(message, function (error, result) {
if (error) throw error;
ws.send(result);
});
});
ws.send('Hello!');
});
cb();
};
");
// Create a WebSocket server on a specific TCP port and using the .NET event handler
await createWebSocketServer(new
{
port = 8080,
onMessage = onMessage
});
}
static void Main(string[] args)
{
Task.Run((Action)Start);
new ManualResetEvent(false).WaitOne();
}
}
`
Using wscat, you can verify the .NET handler is indeed invoked for every websocket message:
`
C:\projects\websockets> wscat -c ws://localhost:8080/
connected (press CTRL+C to quit)
< Hello!
> Foo
< Received string of length 3
> FooBar
< Received string of length 6
`
This example shows how Edge.js can create JavaScript proxies to .NET functions and marshal calls across the V8/CLR boundary in-process. Read more about data marshaling between Node.js and CLR.
In the previous example a Node.js HTTP server was created and started from .NET. Suppose at some point you want to stop the HTTP server from your .NET code. Given that all references to it are embedded within Node.js code, it is not possible. However, just as Edge.js can pass a .NET function to Node.js, it also can export a Node.js function to .NET. Moreover, that function can be implemented as a closure over Node.js state. This is how it would work:
`c#
var createHttpServer = Edge.Func(@"
var http = require('http');
return function (port, cb) {
var server = http.createServer(function (req, res) {
res.end('Hello, world! ' + new Date());
}).listen(port, function (error) {
cb(error, function (data, cb) {
server.close();
cb();
});
});
};
");
var closeHttpServer = (Func
Console.WriteLine(await new WebClient().DownloadStringTaskAsync("http://localhost:8080"));
await closeHttpServer(null);
`
Notice how the createHttpServer function, in addition to starting an HTTP server in Node.js, is also returning a .NET proxy to a JavaScript function that allows that server to be stopped.
Using Node.js via Edge.js in ASP.NET web applications is no different than in a .NET console application. The Edge.js NuGet package must be referenced in your ASP.NET web application. If you are using any external Node.js modules, the entire node_modules subdirectory structure must be binplaced to the bin folder of you web application, and deployed that way to the server.
The EDGE_NODE_PARAMS environment variable allows you to specify any options that are normally passed via command line to the node executable. This includes the --debug options necessary to use node-inspector to debug Node.js code.
Note This mechanism requires hardening, expect the road ahead to be bumpy.
These are unstructions for building the Edge.js NuGet package on Windows. The package will support running apps in both x86 and x64 architectures using a selected version of Node.js. The resulting NuGet package is all-inclusive with the only dependency being .NET 4.5.
Preprequisties:
* Visual Studio 2015
* Node.js (tested with v6.5.0)
* Python 2.7.x
* node-gyp (tested with 3.0.1)
To buid the NuGet package, open the Visual Studio 2013 Developer Command Prompt and call:
`
tools\build_double.bat 6.5.0
(you can substitite another version of Node.js).
The script takes several min