Dynamic Query with AND, OR criteria

[Tina Agrawal, modificado 12 Anos atrás.]

Hi All,


I am using Dynamic Query to get the result from my custom table.

I want to execute Dynamic Query with "AND"(&&) as well as with "or"(||) criteria.

SQL which resembles to my need is something like this

  Select * 
    From CustomeTable ct
    Where   (ct.firstColumn = "abc" AND ct.secondColumn = "xyz")
            OR ct.thirdColumn = "123";

Let me know any pointers.

Regards,
Tina Agrawal