implementing effective searching in the business code(with linqmaybe)

[giddy]

hi,

If I have something like:
class Person
{
//functions:
static Person[] GetAllPersons();
static Person[] Search(string field,string value);
}

In the second function I would do something like build an sql query
like this:

>SELECT ........... WHERE field = value

and send it through another data class to retrieve the right Persons.

eg:
Person[] teens = Person.Search("Age",18);

Firstly the biggest problem searching with AND, >,<, OR, Between etc.?
Which terribly limits the search.I could make more functions for that,
but its turns into a little bit of a mess. Is there a better/more
generic way to build a query on the fly?

Would I benefit by using Linq instead/would it be more efficient to
load all persons in memory and then search them with linq? If I were
to use linq how again would I write a function to build a query on the
fly?

Thanks so much

Gideon

[Family Tree Mike]

I think your send button is stuck. You have posted the same question three
times now. The first time has been answered.
"giddy" <gi*******@gmail.comwrote in message
news:1f**********************************@r15g2000 prh.googlegroups.com...

hi,

If I have something like:
class Person
{
//functions:
static Person[] GetAllPersons();
static Person[] Search(string field,string value);
}

In the second function I would do something like build an sql query
like this:

>>SELECT ........... WHERE field = value

and send it through another data class to retrieve the right Persons.

eg:
Person[] teens = Person.Search("Age",18);

Firstly the biggest problem searching with AND, >,<, OR, Between etc.?
Which terribly limits the search.I could make more functions for that,
but its turns into a little bit of a mess. Is there a better/more
generic way to build a query on the fly?

Would I benefit by using Linq instead/would it be more efficient to
load all persons in memory and then search them with linq? If I were
to use linq how again would I write a function to build a query on the
fly?

Thanks so much

Gideon

[giddy]

Jeez, this happens every now and then, but this time, i posted and it
didn't show up in the forum for a couple hours I think, then i posted
again.

What do you guys use to post here, I use google groups.

Thanks so much

Gideon

[Family Tree Mike]

I use Windows Mail on Vista, and
http://www.microsoft.com/communities...s/default.aspx from XP.
They all have quirks though...

"giddy" <gi*******@gmail.comwrote in message
news:9d**********************************@i20g2000 prf.googlegroups.com...

Jeez, this happens every now and then, but this time, i posted and it
didn't show up in the forum for a couple hours I think, then i posted
again.

What do you guys use to post here, I use google groups.

Thanks so much

Gideon

[giddy]

I use Windows Mail on Vista,

Interesting, can I use outlook to post and maybe see replies??

Thanks so much
Gideon

[Peter Duniho]

On Wed, 08 Oct 2008 01:26:31 -0700, giddy <gi*******@gmail.comwrote:

>I use Windows Mail on Vista,

Interesting, can I use outlook to post and maybe see replies??

Outlook Express (the predecessor to Windows Mail) has decent newsgroup
support (the only major bug I'm aware of has to do with failing to quote
properly when the replied-to message is encoded in one of a set of
particular encodings).

On Windows, there are lots of other options, including 40tude, Forté
Agent, Thunderbird, and Opera. Note that with any newsreader, you'll need
to point it at a specific news server. For any of the
"microsoft.public..." newsgroups, you can use Microsoft's own public
server. I believe you can access it with either "news.microsoft.com" or
"msnews.microsoft.com".

Pete