Pass parameters to PostgreSQL query in a C# code
if (oUSERDTO.EVENT_ACTION == (int)Enums.EventAction.Create && result.Equals(“true”)) { result = “false”; using (DBConnector oCloudConnection = new DBConnector(connectionValues[0], Convert.ToInt32(connectionValues[1]))) { StringBuilder varname1 = new StringBuilder(); varname1.Append(“DO n”); varname1.Append(“$$ n”); varname1.Append(“BEGIN n”); varname1.Append(“IF NOT EXISTS n”); varname1.Append(“( n”); varname1.Append(“SELECT 1 n”); varname1.Append(“FROM SUSER n”); varname1.Append(“WHERE (USER_ID=:USER_ID) n”); varname1.Append(“) n”); varname1.Append(“THEN n”); varname1.Append(“INSERT INTO SUSER n”); varname1.Append(“( n”); varname1.Append(“USER_ID, […]
PostgerSQL connection
This is the connection of a PostgreSQL database to a function which get the details and create database record