Skip to main content
Total Downloads
9.1K
9,079
Published
Jun 16, 2023
3y ago

Get Started

dotnet add package Iciclecreek.Bot.Builder.Dialogs.Database.SqlClient --version 4.20.0
ProductVersions
.NET Standard
netstandard2.0

README

icon

SQL Actions

This library provides custom actions for Bot Framework/Composer to do operations against SQL Database stores.

Installation

To install into your project run the cli:

dotnet add package Iciclecreek.Bot.Builder.Dialogs.Database.SQL

Library

This library adds actions for SQL Databases.

Database

Action Description
Iciclecreek.Sql.ExecuteSQL dexecute sql statement

Example

  {
    "$kind": "Iciclecreek.Sql.Execute",
    "connectionString": "=settings.connectionString",
    "statements": [
        "CREATE TABLE COMPANY(",
        "   ID INT PRIMARY KEY     NOT NULL,",
        "   NAME           TEXT    NOT NULL",
        ");"
    ]
},
{
    "$kind": "Iciclecreek.Sql.Execute",
    "connectionString": "=settings.connectionString",
    "statements": [
        "INSERT INTO COMPANY (ID,NAME) VALUES (1, '${turn.name}');"
    ]
},
{
    "$kind": "Iciclecreek.Sql.Execute",
    "connectionString": "=settings.connectionString",
    "statements": [
        "SELECT NAME FROM COMPANY;"
    ],
    "resultProperty": "turn.results"
},

Downloads by Version

Similar & Alternative Packages

Hand-picked matching NuGet libraries based on tags & ecosystem

Depended On By

Find packages that declare this package as a dependency. NuGet does not provide a reverse-dependency endpoint, so candidates are checked on demand.

Adoption Assessment

Assess this package against its supported frameworks, license, maintenance signals and dependency graph before making it a project standard.

Compatibility metadata lists 1 target framework; confirm the exact target used by your application.

Related Guides & Workflows

Learn how to evaluate, integrate, or audit this package in your .NET project.