.Net Runtime Library for Delphi

The .Net Runtime Library for Delphi (CNClrLibrary) is the best library to work with .Net framework and .Net libraries from Delphi. It is designed to provide a way to interact with applications written in anyone of the .Net languages (such as C#, Visual Basic.Net, Delphi.Net, JScript.Net, etc) from Delphi.

CNClrLibrary allows Delphi to use .Net libraries without the need for registry entries, COM registrations, or changes to the .NET libraries.

Learn more »

Introduction

  • Overview – Provides detailed information about the .Net Runtime Library for Delphi.
  • Features – Provides Key features of the .Net Runtime Library for Delphi.
  • Editions – Shows different versions of the .Net Runtime Library for Delphi.
  • Source Code Examples – Demonstrates how you can use the .Net Runtime Library for Delphi to produce Delphi applications.
  • Documentations – Official .Net Runtime Library for Delphi Documentations

Competitive Advantages

  • No extra dll is required when deployed.
  • No COM registration of .Net Libraries is required when deployed.
  • There are tools to generate your .Net Libraries into Delphi pas files.
  • Allows Delphi to consume .Net libraries as if they were native code.
  • Full access to .Net Framework Class Library.
  • Easy to use.

CNClrLibrary can do so much:

  • Access .Net Framework Class Library (such as Collections, Data Configuration, DataSets, Data Access, Database Connectivity, Diagnostics, IO, Linq, Dynamic Linq, System, Device and Application Management, Networking, Reflections, Security, Encryption, Cryptogrphy, Character Encoding and String Manipulation, XML etc).
  • Access Third Party .Net Libraries.
  • Access Your .Net Libraries.
  • etc

Deployment

  • Microsoft .Net Framework (Latest versions of Windows have .Net Framework pre-installed)
  • Basic Copy Deployment
    • Your application

What Our Customers Say:

  1. Eros Baseotto
    Rodacciai S.p.A.

    "It was about a year I tried to use the NiceLabel.Net library from Delphi using remObjects Hydra, CrossTalk without success. Finally I found your .Net Runtime Library for Delphi and that worked great!Many thanks also for your kindness in analysing my problem."
    More Comments

Example:

program XML;

{$APPTYPE CONSOLE}
{$R *.res}

uses
  CNClrLib.Xml,
  CNClrLib.Core;

var
  NameTable: _NameTable;
  Book, Price: Variant;
  Settings: _XmlReaderSettings;
  Reader: _XmlReader;
  ReaderHelper: _XmlReaderHelper;
  ObjectHelper: _ObjectHelper;
begin
  NameTable := CoNameTable.CreateInstance;

  Book := NameTable.Add('Book');
  Price := NameTable.Add('Price');

  // Create the Reader.
  Settings := CoXmlReaderSettings.CreateInstance;
  Settings.NameTable := NameTable.AsXmlNameTable;

  ReaderHelper := CoXmlReaderHelper.CreateInstance;
  Reader := ReaderHelper.Create_1('books.xml', Settings);

  Reader.MoveToContent;
  Reader.ReadToDescendant('Book');

  ObjectHelper := CoObjectHelper.CreateInstance;
  if ObjectHelper.ReferenceEquals(Book, Reader.Name) then
  begin
    // Do additional processing.
  end;
end.

.Net DLL/WSDL Importer for Delphi

The .Net DLL/WSDL Importer for Delphi also called .Net Assemblies/WSDL Import Utility for Delphi is used for importing .Net Libraries, WSDL or web service XML schema and generate Delphi pas files from the types of the imported libraries.

Learn more » Documentations»

ADO.Net VCL for Delphi

The fastest and most reliable database connectivity solutions for any database using ADO.Net technology in Delphi. The ADO.Net VCL for Delphi provides data access through the ADO.Net data provider framework. It is an enterprise solution for a low cost High-class functionality with fast and reliable support and with highest performance and unlimited possibilities.

Learn more »

Introduction

  • Overview – Provides detailed information about the ADO.Net VCL for Delphi.
  • Components – Provides list of components of the ADO.Net VCL for Delphi.
  • Features – Provides Key features of the ADO.Net VCL for Delphi.
  • Source Code Examples – Demonstrates how you can use the ADO.Net VCL for Delphi to produce Delphi database based applications.

Competitive Advantages

  • High performance access to the data source.
  • Fast-forward data retrieval with TDbDataReader component and Server CursorKind Dataset.
  • Fast controlled fetch of large data blocks.
  • Transmission is via XML format, therefore can pass through firewalls.
  • Support Prefetching rows.
  • High performance of applying cached updates with batches.
  • High performance batch updates processing.

Example:

The code in this example assumes that you can connect to the Northwind sample database on Microsoft SQL Server. The code creates a TSqlClientDataReader to select rows from the Products table, adding a parameter to restrict the results to rows with a UnitPrice greater than the specified parameter value, in this case 5. The code executes the command using the TSqlClientDataReader, and displays the results in the console window.

SQlClientDAC Example program SqlClientExample;

{$APPTYPE CONSOLE}

{$R *.res}

uses
  System.SysUtils, CNClrLib.ADONet.SqlClient;

var
  queryString: string;
  paramValue: Integer;
  connection: TSqlClientConnection;
  reader: TSqlClientDataReader;
begin
  try
    // Provide the query string with a parameter placeholder.
    queryString := 'SELECT ProductID, UnitPrice, ProductName from dbo.products '
            + 'WHERE UnitPrice > :pricePoint '
            + 'ORDER BY UnitPrice DESC';

    // Specify the parameter value.
    paramValue := 5;

    // Create and open the connection.
    connection := TSqlClientConnection.Create(nil);
    try
      // Setup connectionstring
      with connection.Params do
      begin
        DataSource := '(local)';
        InitialCatalog := 'Northwind';
        IntegratedSecurity := True;
      end;

      // OR you can set sql connectionstring to the connectionstring property of TSqlClientConnection

      connection.ConnectionString := 'Data Source=(local);Initial Catalog=Northwind;Integrated Security=true';

      // Open connection
      connection.Open;

      // Create the DataReader command.
      reader := TSqlClientDataReader.Create(nil);
      try
        reader.Connection := connection;
        reader.CommandText.Text := queryString;
        reader.ParamByName('pricePoint').AsInteger := paramValue;
        reader.Open;
        while reader.Read do
        begin
          Writeln(Format(chr(9) + '%s' + chr(9) + '%s' + chr(9) + '%s',
            [reader.GetString(0), reader.GetString(1), reader.GetString(2)]));
        end;

        reader.Close;
      finally
        reader.Free;
      end;
    finally
      connection.Free;
    end;
  except
    on E: Exception do
      Writeln(E.ClassName, ': ', E.Message);
  end;
  ReadLn;
end.

Database Tool

This is called a CrystalNet Database (CrystalDB) Tool which is a Microsoft Windows based database tool developed by CrystalNet Technologies LTD. This tool is used by developers, DBAs and analyst for managing, administering and developing databases. The tool supports the two common database management system, namely MS SQL Server and Oracle.

Learn more »

Database Management

The CrystalDB Tool provides database management functionalities which includes editing table data, creating or altering tables and views as well as database objects, backup and restore database etc.

Generate Scripts

This is a wizard in the CrystalDB Tool which allows the user to perform Data Definition Language(DDL) operations on the database objects. The DDL operations performed using this wizard include: ALTER, CREATE and DROP objects.

Import & Export Data

This is a wizard in the CrystalDB Tool which allows the user to create packages that import and export data between databases from different servers (MSSQL and Oracle), the same servers, spreadsheets, text files and XML Files.


Compare Database

This is a wizard in the CrystalDB Tool which allows the user to compare the structure or the data in two databases both from the same server or different servers.

XML Explorer

This is a tool in the CrystalDB Tool which allows the user to view XML data from an xml file, excel file and any file which contains xml format and add a new xml data.

Query Builder

This is a tool in the CrystalDB Tool which provides an easy way to develop database queries by using a point-and-click interface and does not require in-depth knowledge about the SQL syntax.