DBhelperMySQL 1.0.0

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"
                }
            }
        });