Part of my auditing logic is to log whatever filter (Predicate expression) was used to fetch the object/collection. I started to build a generic function that can return a friendly string representation of the Predicate object but thought myabe LLBL already has this facility...??

Is there an easy way to do this?.. if NOT how do you think I should proceed to build such a function ??

Please try

PredicateExpression.ToQueryText()

Retrieves a ready to use text representation of the contained Predicate.

Be sure to set the DbSpecificCreatorToUse property to an instance of the DQE 's DbSpecificCreator class.

Otis wrote:

Be sure to set the DbSpecificCreatorToUse property to an instance of the DQE 's DbSpecificCreator class.

forgive my ignorance but I have no idea what you meen

What are these two parameters required by the ToQueryText method

Function ToQueryText( _
   ByRef uniqueMarker As Integer, _
   ByVal inHavingClause As Boolean _
) As String

What I want to do is a simple (and generic to work with any DAL/DQE) PredicateExpressionToString function that retreives a string representation of the PredicateExpression object

ToQueryText() produces SQL, for the WHERE clause (for example). Prior to call ToQueryText, you should set the dbspecific creator object of the predicateexpression. See the following example for sqlserver:

myPredicateExpression.DatabaseSpecificCreator = new SD.LLBLGen.Pro.DQE.SqlServer.SqlServerSpecificCreator();
int uniqueMarker = 0;
string s = myPredicateExpression.ToQueryText(ref uniqueMarker, false);

That's about it.

Otis wrote:

ToQueryText() produces SQL, for the WHERE clause (for example). Prior to call ToQueryText, you should set the dbspecific creator object of the predicateexpression. See the following example for sqlserver:

myPredicateExpression.DatabaseSpecificCreator = new SD.LLBLGen.Pro.DQE.SqlServer.SqlServerSpecificCreator();
int uniqueMarker = 0;
string s = myPredicateExpression.ToQueryText(ref uniqueMarker, false);

That's about it.

If I want to create this function in my DALDBSepecific assembly, can I use an include template to generate such code (so that I don't modify the original templates)? If yes, can you please tell me how to do that??

omar wrote:

Otis wrote:

ToQueryText() produces SQL, for the WHERE clause (for example). Prior to call ToQueryText, you should set the dbspecific creator object of the predicateexpression. See the following example for sqlserver:

myPredicateExpression.DatabaseSpecificCreator = new SD.LLBLGen.Pro.DQE.SqlServer.SqlServerSpecificCreator();
int uniqueMarker = 0;
string s = myPredicateExpression.ToQueryText(ref uniqueMarker, false);

That's about it.

If I want to create this function in my DALDBSepecific assembly, can I use an include template to generate such code (so that I don't modify the original templates)? If yes, can you please tell me how to do that??

See 'adding your own code to the generated code' in the documentation for how to use an include template. You should add an include template to the DataAccessAdapter class and simply generate a method which accepts a predicate and returns a string.