(async function() {

try{

let connectionstring = "Driver={SQL Server}; Server=localhost; Database=MyDB;trusted_connection=yes;";

let conn = await HMIRuntime.Database.CreateConnection(connectionstring);

let query = "Select * from MyTable;";

let results = await conn.Execute(query);

if(results !== undefined && results !== null)

{

let statements = results.Results;

for(let statement in statements)

{

let rows = statements[statement].Rows;

for (let i in rows)

{

let row = rows[i];

for(let key in row)

{

HMIRuntime.Trace(key+":"+row[key]);

}

}

}

}

conn.Close();

}

catch(e)

{

let res = e.Results;

for(let statement in res)

{

let errors = res[statement].Errors;

for (let i in errors)

{

let detailed = errors[i];

HMIRuntime.Trace("Errors state : "+detailed.State);

HMIRuntime.Trace("Errors Message : "+detailed.Message);

}

}

}

})();