Hello,

I have a project that works both with SQLServer and Oracle databases.

I have a user function GET_DENOMF, with one parameter that returns a string, and I want to compare the result with a given pattern

IExpression exp = new DbFunctionCall("dbo","GET_DENOMF", new object[] { ARBO_HDENOMFields.AHD_DENOMF });
 filter.PredicateExpression.Add(new FieldLikePredicate(ARBO_HDENOMFields.AHD_DENOMF.SetExpression(exp), null , "%" + rETURN_VALUE + "%"));

For this to work in SqlServer, I had to add the default schema "dbo", but for Oracle I should not use any schema. So, for it to work in Oracle as well, I understand that I have to treat this separately.

What I wanted to do, was to go into the ormsupportclasses and SQLServerDQL projects, and see if I can add a property, whom if setted, should use the schema 'dbo'. But my problem is that I cannot make the ormsupportclasses work. I am using in my project the ORMSupportClasses.NET20. I loaded the solution ORMSupportClasses.CF35.sln, but at a first compilation try, I get the error that: Error 1 \Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\Exceptions\ExceptionInfoRetrieverBase.cs' could not be opened ('Unspecified error ') ORMSupportClasses.CF35

What I wanted to do, was to go into the ormsupportclasses and SQLServerDQL projects, and see if I can add a property, whom if setted, should use the schema 'dbo'. But my problem is that I cannot make the ormsupportclasses work. I am using in my project the ORMSupportClasses.NET20. I loaded the solution ORMSupportClasses.CF35.sln, but at a first compilation try, I get the error that: Error 1 \Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\Exceptions\ExceptionInfoRetrieverBase.cs' could not be opened ('Unspecified error ') ORMSupportClasses.CF35

Why do you need to have this inside the LLBLGen libraries. You can have a property in your code to control passing the schema name.