New Query Builder Classes

Hi,

I'm using the Petshop sample to try out the SqlStringBuilder and EntityStringBuilder classes, but I can't seem to get it working.

My code is below:

Try:

AccountList = accountService.Find(afb.GetParameters());

I don't see that method as part of the AccountFilterBuilder class. If I use the code given, I get the following error

'Petshop.Data.Bases.AccountFilterBuilder' does not contain a definition for 'GetParameters'

I am using .NetTiers v2.0.1.471

Thanks,

RK

Sorry, use the AccountParameterBuilder class (which has the GetParameters method).

Thanks. That worked!

Regarding "query2.Append(CustomersColumn.City, "London, Berlin");", which results in "(City = 'London' OR City = 'Berlin')"

As per my experience, the IN clause works faster than list separated with OR condition. Therefore, how about creating IN clause whenever we get the list of comma delimited parameters. I will be doing in "IN Clause" way.

Your opinion?
 

Just use the AppendIn method, which will do what you are looking for...

how to keep the sorting functionality on EntityGridView working when using the builder with the TList?
Always get the err messafe that the datasource doenst support sorting.

THANKS. 

OQ 

When performing a Deepload is there anyway to specify a where clause for the native table the provider is for and also for a column in one of the tables that are joined in the DeepLoad?

i.e: Performing a Deepload on Orders with tables: OrderDetails and ShippingMethod, and being able to specify a where clause or ParamenterBuilder on Orders with status = Open (clause for Order table), states = CA (clause for joined State table), ShippingMethod = Overnight (clause for joined Shipping table)?

Thanks in advance,

 -Le

 BTW: Nettiers and Codesmith Rocks!

Hello,

 you showed how to find in a view classe via ParameterBuilder.  Very useful descipted

I got a view  View_EmployeeSkill.  Using View_EmployeeSkillParameterBuilder  I receive as Result a VList<View_EmployeeSkill> 

How can I use that List for a second search step ?

another point.

.That project is planned for an WebService. Because of  the MVC princip there is an Seperation between GUI and business logic.

For an intelligent business logic it would be nice, that name and value  of search parameter could only be interesting at runtime.

as I have seen at the samples above, the columnname ist wanted. 

very thanks

// Finding one employee
View_EmployeeSkill view_EmployeeSkill =  VList<View_EmployeeSkill>.Find( View_EmployeeSkill.Column.EmployeeId, 18);

// Finding one employee (delgation usage on two conditions)
View_EmployeeSkill view_EmployeeSkill =  VList<View_EmployeeSkill>.Find(
     delegate(View_EmployeeSkill.Column v) { return v.EmployeeId == 18 && v.DepartmentId = 25; } ) );

// Finding employee set
VList<View_EmployeeSkill> view_EmployeeSkills =  VList<View_EmployeeSkill>.FindAll( View_EmployeeSkill.Column.DeptartmentId, 25);

 Thanks for answering.

 I think I can handle your respond. 

 What I still haven't found: how to use ParameterBuilder.  Okay, I know how to build the ParameterBuilder string. 

also to call the DB via the service .

but the final:    find (...GetParameters())  How do I set the Parameters with  values? 

 should it be into the brackets ? --> GetParameters(...,...)

Check yyour answer here:

http://community.codesmithtools.com/forums/t/8401.aspx 

That's my code for method.

In my list I want to get something like Query.searchQuery.AppendGreaterThanOrEqual

 and it seems for me, writing a delegate is nessessary.

the thick code line is the point, there I got my problems.  

thanks 

public int IterateFind(ref VList<View_EmployeeSkill> list, View_EmployeeSkillColumn column, string value)
        {
            View_EmployeeSkillFilterBuilder searchQuery = new View_EmployeeSkillFilterBuilder();

            if (column.Equals(View_EmployeeSkillColumn.SkillLevel))
            {
                int number = -1;
                int.TryParse(value,out number);

                list = list.FindAll(delegate(list l) { return l.SkillLevel > number || l.SkillLevel == number; });
                //list.FindAll(column >
            }
            else
            {
                list = list.FindAll(column,value);
                //searchQuery.Append(column, value);
            }


            return list.Count;
        }

It looks right, I would do it in a different way.

* Theres no need to use the ref keyword, its a reference type already.
* I would return the filtered list. That way i would end up with the original list and the new one.
* Theres no need to return the list count. Returning the filtered list, haven both lists you can compare and do more stuf.
* Your predicate could have just one test.

 So, with my changes, I end up with this:

public VList<View_EmployeeSkill> IterateFind(VList<View_EmployeeSkill> list, View_EmployeeSkillColumn column, string value)
        {
            if (column.Equals(View_EmployeeSkillColumn.SkillLevel))
            {
                int number = -1;
                int.TryParse(value, out number);

                return list.FindAll(delegate(View_EmployeeSkill vES) { return vES.SkillLevel >= number; });
            }
            else
            {
                return list.FindAll(column, value);
                //searchQuery.Append(column, value);
            }
        }

If you want  do more stuff within the method with the result list just declare the variable and do your thing.

Hope this helps.