Has anyone used confirmation rules on register data?

Execute Query on App DB

Using dbConnApp As DBConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si)

Using dt As DataTable = BRAPi.Database.ExecuteSql(dbConnApp, sql.ToString, True)

If Not dt Is Nothing Then
MyResults = (From r In dt.AsEnumerable() Select r.Field(of String)(""FirstName"")).ToList()
End If
End Using
End Using