just a reminder of forming a sql query. for concating strings in different databases, refer to my post here . for concatenation, MS SQL uses " + " operator , Oracle uses " || " operator (as well as MySql uses function CONCAT() ) . so if one is designing a Data Repository using Repository Pattern , one...