DBhelperMySQL 1.0.0

Install-Package DBhelperMySQL -Version 1.0.0
dotnet add package DBhelperMySQL --version 1.0.0
<PackageReference Include="DBhelperMySQL" Version="1.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add DBhelperMySQL --version 1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: DBhelperMySQL, 1.0.0"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install DBhelperMySQL as a Cake Addin
#addin nuget:?package=DBhelperMySQL&version=1.0.0

// Install DBhelperMySQL as a Cake Tool
#tool nuget:?package=DBhelperMySQL&version=1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

This lib contains the following functions

GetSql Database function value Get SQL Query value

Examples var _dataAccess = new DBhelperMySQL.DB.DataAccess("ConnectionString");

        //No Parameters
        var _DateFromDb = _dataAccess.getFunctionValue(new DB.Dtos.GetFunctionInputMySQL()
        {
            Name = "CURRENT_TIME",
            Parameters = null
        });

        //With Parameter
        var FunctionValue = _dataAccess.getFunctionValue(new DB.Dtos.GetFunctionInputMySQL()
        {
            Name = "UPPER",
            Parameters = new System.Collections.Generic.List<DB.Dtos.DbParamsMySQL>()
            {
                new DB.Dtos.DbParamsMySQL()
                {
                    name = "PAR1",
                    value = "My SQL database"
                }
            }
        });

        //No Parameter
        var sqlQueryValue = _dataAccess.GetSqlQueryValue(new DB.Dtos.GetQueryInputMySQL()
        {
            Query = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES",
            Parameters = null
        });

        //With Parameter
        var sqlQueryWithPar = _dataAccess.GetSqlQueryValue(new DB.Dtos.GetQueryInputMySQL()
        {
            Query = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES where table_name = @PAR1",
            Parameters = new System.Collections.Generic.List<DB.Dtos.DbParamsMySQL>()
            {
                new DB.Dtos.DbParamsMySQL()
                {
                    name ="PAR1",
                    value = "PROFILING"
                }
            }
        });

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.0.0 64 9/19/2021