ThinkSQL v1.1.2

ThinkSQL v1.1.2

Downloads

Asset	Description
ThinkSQL-Module-v1.1.2.zip	PowerShell module — extract to a PSModulePath folder and Import-Module ThinkSQL

Quick Start — PowerShell Module

# Extract to your modules folder
Expand-Archive ThinkSQL-Module-v1.1.2.zip -DestinationPath "$env:USERPROFILE\Documents\PowerShell\Modules"

# Use it
Import-Module ThinkSQL
Connect-ThinkSQLConnection -Server localhost -Database master -Username sa -Password YourPassword
Invoke-ThinkSQL "SELECT @@VERSION AS Version"
Close-ThinkSQLConnection

Quick Start — C/C++ Interop

The module zip also contains ThinkSQL.dll and the header is generated at build time.

#include "ThinkSQL.h"
// Link against ThinkSQL.dll
char* err = ConnectDb("server=localhost;user id=sa;password=YourPassword;database=master");
char* json = ExecuteSql("SELECT @@VERSION AS Version");
FreeCString(json);
DisconnectDb();

Release Notes

Version 1.1.2

• Initial release
• Connect/disconnect to SQL Server
• Execute SQL with automatic processing
• SELECT queries use SNAPSHOT isolation
• CREATE TABLE auto-adds primary key
• Returns SELECT results as PowerShell objects or JSON