Affecto.IdentityManagement.Store.PostgreSql.Migrations.RolePermissionMigration.AddRolePermissionIfNotExists C# (CSharp) Method

        protected void AddRolePermissionIfNotExists(string roleId, string permissionId)
        {
            string sql = "INSERT INTO {0} (permissionid, roleid)"
                + " SELECT '{1}', '{2}'"
                + " WHERE NOT EXISTS (SELECT permissionid FROM {0} WHERE permissionid = '{1}' AND roleid = '{2}');";

            Sql(string.Format(sql, FormatTableNameWithSchemaNameAndQuotes("rolepermission"), permissionId, roleId));
        }