Primo.Database.SqlServer 1.0.4

About

Primo.Database.SqlServer is a set of ready-to-use activities for Primo RPA Studio designed to automate interaction with MS SQL Server databases. It addresses the need to connect to SQL Server databases and execute database operations within automated processes. Key activities include: connecting to a database, executing queries, inserting data, and disconnecting from the database. The package can be added to any Primo RPA Studio project via the built-in dependency manager.

How to Use

In Primo RPA studio, create a project that will be executed by Primo RPA robot. Install this package via the ".Dependencies → Manage Dependencies" menu; the "Detabase → SQL Server" node with package elements will appear in Elements tree .
There are four elements in the package: "Connect (SQL Server)", "Execute Query (SQL Server)", "Insert (SQL Server)", "Disconnect DB (SAP HANA)". "Connect (SQL Server)" is the main one, because it is not possible to interact with any DB without connecting. It is highly recommended to use the "Disconnect DB (SQL Server)" element after interacting with the database to free up external resources.
In pure code projects use the "Connect (SQL Server)" element as follows:

//wf: [LTools.Common.Model.WorkflowData] parent algorithm link
//db - Connection string: [String] Database connection string (SERVER=<hostname>:<port>; DATABASE=<database name>; UID=<username>;PWD=<password>)
Primo.Database.SqlServer.DatabaseApp app = Primo.Database.SqlServer.DatabaseApp.Init(wf, db);

Pure code for "Insert (SQL Server)" element:

//app - [Primo.Database.SqlServer.DatabaseApp] DB application
//query - Table: [String] Table name
//data - Data: [System.Data.DataTable] Data to insert
//timeOut - Time-out: [Int32] Query time-out
//res - Records: [Int32] Affected records
int res = app.Insert(query, data, [timeOut]);

Key Features

• User-friendly, intuitive interface
• High performance
• Supports .NET Framework 4.6.1+

Main Types

• Primo.Database.SqlServer.DatabaseInst
• Primo.Database.SqlServer.DatabaseApp
• Primo.Database.SqlServer.Elements.WFConnectDatabase
• Primo.Database.SqlServer.Elements.WFExecuteQuery
• Primo.Database.SqlServer.Elements.WFInsert
• Primo.Database.SqlServer.Elements.WFDisconnectDatabase

Feedback

Bug reports and contributions are welcome at Primo RPA chat