Getting started

Before you start writing your first application to connect to the 1010data Insights Platform, you need to install Visual Studio and download the .NET SDK.

Requirements

The 1010data .NET SDK is only available for Windows. You must have Visual Studio installed on your system.

Installation

You can download the .NET SDK files from https://www2.1010data.com/downloads/tools/dotNETv2/dotNetSDKv2.zip. The zip file contains two folders and a Readme file. The win64 and win32 directories contain the library files. Use the library files in the directory that matches the version you're using.


Version	Directory to use
Windows 64-bit	win64
Windows 32-bit	win32

Two of the library files, TenTenSDK.Native.dll and TenTenSDK.dll, must be added as references to your Visual Studio project. The third file, lib1010csdk-vs64.dll or lib1010csdk-vs32.dll depending on the version, must be added as source file. For more information, see Add TenTenSDK.Native.dll and TenTenSDK.dll and Add lib1010csdk-vs64.dll.

If you are not working with a Visual Studio project, add these files to your working directory. The examples directory contains sample Visual Studio projects. Each of these projects already references the library files.

Using the single sign-on (SSO) feature

If you want to use the SSO feature of the .NET SDK, you also need to copy the file sso_login to any directory on the PATH. Check your PATH environment variable for a list of directories by typing echo %PATH% on the command line.

Example projects

The examples folder contains six examples. Each example is set up as a Visual Studio project. Before you can run the examples, you must replace the USER_NAME and USER_PASSWORD in each project with a valid 1010data user name and password before you attempt to run the sample applications.

To run a project, click Start in the toolbar.

The examples directory contains the following sample projects:

AllTypes: Casts Insights Platform data types (text, integer, decimal, bigint, date, time, and date+time) to their appropriate .NET types.
ColumnPrinter: Prints the columns of a table one at a time.
Fsharp: Prints the entire table. This example is written in F #.
IntPrinter: Prints the title and values of columns that have the integer data type.
OddPrinter: Prints the odd rows.
TablePrinter: Prints the entire table.
Threads1: Uses two threads to create two session objects, retrieves information from two tables, and downloads the data into two separate files.
ToDataTable: Casts your result set to the .NET DataTable object.
Vbnet: Prints the entire table. This example is written in VB.NET.