Sure.
"workaround to xml parameter"
Why would you fear using xml? Sql Server does a nice job of shredding them.
But you can put the data into cached object.
However, it dependings on how many optional filters you need to code.
If you have alot, it won't be trivial.
I would research the "Filter" using Ludwig's very good article:
http://www.scribd.com/doc/2057557/CTG-Articles-Generics
I foresee a maze of Filter methods......but maybe you can figure out
something.
"Jeff" <it************@hotmail.com.NOSPAMwrote in message
news:uU****************@TK2MSFTNGP02.phx.gbl...
Thanks for that link.
But now I'm wondering if there is another possible approach. The thing is
that my DAL creates a collection of the objects.
for example List<carcars = siteprovider.getCars();
So maybe a possible workaround to using xml parameter is to in the
application start event put some logic that reads in the entire collection
of cars and then store it the cache. And then use the search mecanism on
the list (List<car>) to get the cars I want. In that approach I don't need
to make another trip to the database.
One issue I see is that perhaps sometime the cache will be lost, but then
maybe make a new trip to the database and return all the records. Then
store it in cache etc...
any suggestons? problem using this approach?