Log In
       Innovative Solutions for Your Evolving Needs

Purchase Get Running - TechCrystals Code Package

Get Running with the IBM Db2 for i .NET Provider

The base version of Get Running - TechCrystals Code Package licenses for $295.  There is an optional add-on that allows you to run and test stored procedures with any number of parameters, for $195 additional.  There is a second add-on that allows you to generate stored procedure templates and stubs code in IBM SQL PL and c# for $235 additional that includes a maintenance plan.

The keys that enable immediate download (directly after purchase) are emailed to the PayPal Account holder used with the purchase, and to a second email address, if you are logged in to tegratecs.com under a different email address. 

You only need 1 license if you are an individual developer or purchasing for an end-user company (source code for use by up to 5 developers).  Software service providers, education organizations and ISV(s), please contact us.

Purchase Bundle HERE at 10% Discount
(log in to PayPal required)
(you will have the option to continue or to cancel on PayPal)

$655 US
Get Running - TechCrystals Code Package
(complete (Base + Add-On 1 + Add-On 2))


Download Keys Delivery  (Show Expanded Details...)   
  • The keys that enable immediate download (directly after purchase) are emailed to the PayPal Account holder used with the purchase.

  • If you are logged in to tegratecs.com and your Web User ID has a verified email address that is different, a second set of the keys will be emailed directly to you also.

  • If you don't have access to the PayPal account holder email address and aren't logged in to tegratecs.com, please contact us after the purchase to let us know how we can assist you (in getting the keys to you, mailing you a CD or by linking accounts via the back office, which may take up to 12 hours depending upon your time zone).


Licensing Terms   (Show Expanded Details...)   
  • Licensing terms are easy for Get Running - TechCrystals Code Package.  You only need 1 license if you are an individual developer or an end-user company (for use by up to 5 employee developers)

  • The license time frame is 7 years and corresponds to v2.1 and includes download of v2.1 fixes.  If we decide to offer a subsequent version after your purchase, it is likely we will offer you an upgrade (or maintenance service) option for an incremental fee.

  • A single license gives rights for a single contract developer to use as he/she sees fit including to make derivative works, provided existing copyright statements are included in copied or derivative code until at such point the new work is over 50% different than the source code provided (basically the standard minimum software copyright guidelines for claiming rights and avoiding copyright infringement).

  • A single license can also be purchased by an end-user company and is intended for use by up to 5 developers, but not IT or software service providers.

  • Software service providers, education organizations and ISV(s), please contact us.



Contents of Get Running - TechCrystals Code Package (base) $295 US

(Ch 1) install VS 2017 CE or VS 2019 CE pics
(Ch 2a) create c# web app (web forms) base project VS 2017
(Ch 2b) create c# web app (web forms) base project VS 2019
(Ch 3) download latest Db2 for i .NET Data Provider from IBM
(Ch 4)
install latest Db2 for i .NET Data Provider DLL
(Ch 5a) create new web project - simplest and fastest pro app
Dynamic Inline SQL to Results Gridview (web page)
(Ch 5b) subset - enable use (reference) the DLL in an existing VS project
(Ch 6) special (rare) circumstance specs involving the provider
simplest and fastest pro app with responsive master page from MS project template
Get Running with the IBM Db2 for i .NET Provider presentation powerpoint

What isn't Included:

(1) The IBM.Data.DB2.iSeries.dll is not downloaded or licensed with your purchase.  To get the install executable (from IBM), at least 1 IBM ACS user license is probably required.

(2) Microsoft and NuGet .dll(s) and packages.  However, as far we we know, you can use all of the features included in your purchase with any of the Visual Studio versions, including Visual Studio Community edition.

(3) Please note the other data provider,  IBM.Data.DB2.iSeries.dll, is not included with this package either.  IBM.Data.DB2.dll is for use with Db2 platforms other than IBM i, such as AIX and mainframe - or with IBM i and .NET Core (with the CLR limitation) which requires a DB2Connect license).  However,  most of the source code and development techniques used within this TCP should be applicable to OO c# targeting Db2 on other IBM platforms!  

Important - The keys that enable immediate download (directly after purchase) are emailed to the PayPal Account holder used with the purchase and to a second email address (if you are logged in to tegratecs.com under a different email address). 

Purchase Base HERE
(log in to PayPal required)
(you will have the option to continue or to cancel on PayPal)

$295 US
Get Running - TechCrystals Code Package
(base)

Picture of (Chapter 5) Dynamic Inline SQL to Results GridView (included in base
Shown here using SQL filtering and gridview filtering and Db2 for i SQL timestamp formulation at run time from old style decimal date and time columns... 

Simplest Inquiry with 2 types of filtering and timestamp formulation from decimal fields from Get Running - TechCrystals Code Package

This web page function is also quick to get running within a responsive master page drop-down menu because a version of Simplest Inquiry is included that runs under the bootstrap master page (that is included within Microsoft's Web Forms ASP.NET Web Application project template.




Get Running - TCP Add-On 1 - $195 (optional)

(Chapter 9) SQL Prototyping Web UI and Stored Procedure Test Harness

Important - The keys that enable immediate download (directly after purchase) are emailed to the PayPal Account holder used with the purchase and to a second email address (if you are logged in to tegratecs.com under a different email address). 

Purchase Add-On 1 HERE
(log in to PayPal required)
(you will have the option to continue or to cancel on PayPal)

$195 US
SQL Prototyping Web UI and Stored Procedure Test Harness

Picture of (9) SQL Prototyping Web UI and Stored Procedure Test Harness
running stored procedure WEBDAPURCHCONFPPCDETROWLISTSS1 with a lot of  parameters ("*null" triggers passing of c# null)

Stored Procedure Test Harness and SQL Prototyping Web Inquiry picture from Get Running - TechCrystals Code Package


Didn't find what you were looking for?  Please let us know. 


Get Running - TCP Add-On 2 - $235 (optional)

(Chapter 21) Gen Db2 for i Stored Procedures and OO Wrapper Source
using c#, IBM SQL PL and the MS .NET Framework

Important - The keys that enable immediate download (directly after purchase) are emailed to the PayPal Account holder used with the purchase and to a second email address (if you are logged in to tegratecs.com under a different email address). 

Purchase Add-On 2 HERE
(log in to PayPal required)
(you will have the option to continue or to cancel on PayPal)

$235 US
Gen Db2 for i Stored Procedures and OO Wrapper Source and 6 Month Maintenance Plan

Pictures of (21) Gen Db2 for i Stored Procedures and OO Wrapper Source

link to GR-TCP2 Example 1 full browser page snapshot PDF

Gen Db2 for i Stored Procedures and OO Wrapper Source Example 1.1 picture from Get Running - TechCrystals Code Package
Gen Db2 for i Stored Procedures and OO Wrapper Source Example 1.2 picture from Get Running - TechCrystals Code Package
Gen Db2 for i Stored Procedures and OO Wrapper Source Example 1.3 picture from Get Running - TechCrystals Code Package
Gen Db2 for i Stored Procedures and OO Wrapper Source Example 1.4 picture from Get Running - TechCrystals Code Package
Gen Db2 for i Stored Procedures and OO Wrapper Source Example 1.5 picture from Get Running - TechCrystals Code Package


link to -> Get Running - Licensed Product Downloads (and occasionally a promo or two)



        go to the home page Top of TechCrystals Code Packages     go to next series page Next in TechCrystals Code Packages     Site Map     Switch to
Mobile View

You are at the web site of Tegratecs Development Corp.  Click here to go to the home page of this site...
Innovative Solutions for Your Evolving Needs
Our contact information:
Tegratecs Development Corp.
1320 Tower Road
Schaumburg, IL 60173
800-739-3777
( please register or sign-in )
© 2009-2020 Tegratecs Development Corp.