DBhelperPostgree 1.0.1

Used For Get Database Function value Get SQL Query value

DataAccess _dataAccess = new DataAccess("Connectionstring");

        //CURRENT DATE Function without Params
        var Date = _dataAccess.getFunctionValue(new DB.Dtos.GetFunctionInput()
        {
            Name = "CURRENT_DATE",
            Parameters = null
        });


        //upper Function with Params
        var Uppervalue = _dataAccess.getFunctionValue(new DB.Dtos.GetFunctionInput()
        {
            Name = "upper",
            Parameters = new System.Collections.Generic.List<DbParams>()
            {
                new DbParams()
                {
                    Type = DataType.String,
                    value = "dataAccessLib"
                }
            }
        });

        //GetSqlQuery
        var queryResult = _dataAccess.GetSqlQueryValue(new GetQueryInput()
        {
            Query = "SELECT table_name FROM information_schema.tables WHERE table_schema = @PAR1 " +
                        "AND table_type = @PAR2; ",
            Parameters = new System.Collections.Generic.List<DbParams>()
            {
                //@PAR1
                new DbParams()
                {
                    Type = DataType.String,
                    value = "public"
                },
                //@PAR2
                new DbParams()
                {
                    Type = DataType.String,
                    value = "BASE TABLE"
                }
            }
        });