Commerce Server General - Searching profiles in CS2002

Author

Searching profiles in CS2002

Guru Smaran

2006-08-15, 1:19 am

Hi,

We are using CS2002 with SQL2k and VS.net 2003 on Win2003. We have created a
few profiles in CS2002, and they are working properly in ASP.net. The
profiles typically have the following fields:

Full Name
Address
Phone
Country
Bio
Links

The users have to personalize their content and then publish their profile
pages, and they get a virtual directory created in IIS. The published profile
pages are stored as an ASPX page under the user's directory. The data in the
ASPX page is populated from the database in realtime.

Now, we have been asked to incorporate a search functionality, where the
"Full Name" field is to be searched. We would have to incorporate this using
CS2002 and MS Indexing Services.

I had a look at Indexing Services, and realised that the search looked for
words/phrases only within documents that are present under the scope of the
catalog.

Now, I'm not sure if we can integrate CS2002 and Indexing Services, and have
the following doubts:

1. I have heard of CS's search capability. Does CS have an inbuilt search
engine? If yes, how do I use this in the BizDesk, and how do I incorporate
the search in .net?

2. How do we make Indexing Services search for objects in a CS2002 profile?

Please help. :-)

Regards,
GS

David Hargis [MSFT]

2006-08-24, 7:20 pm

You can search profiles using the CSOLEDBProvider. I just posted
instructions on how to do this under a different thread... here is the meat
of it:

Just open an OleDbConnection using the connection string specified by the
s_CommerceProviderConnectionString Profiles resource property. There are
just a couple of things to be careful of when using the CSOLEDBProvider:

1) The connection string in s_CommerceProviderConnectionString is
formatted for ADO, not ADO.NET. To use ADO.NET you need to tweak the
connection string slightly:
string adonetConnStr = adoConnStr.Replace("url=",
"Provider=Commerce.DSO;Data Source=");
2) Create and open only one OleDbConnection for the lifetime of your
service. This is the opposite of what you would probably expect, but
creating a CSOLEDBProvider connection is very expensive, and it implements
its own internal connection pool. So save this connection in a singleton
or static property.
3) The query language supported is somewhat limited. The main limitation
is that 'OR' is not supported in the WHERE clause. But all of the syntax
limitations should be listed in the CS2007 help file.

As for integration with Indexing Services, I've not worked with this so I
can't say whether this integration is possible or not.

- David

--------------------
Thread-Topic: Searching profiles in CS2002
thread-index: Aca/oqvKa7fThkhtTkaCqyV9DZzUiw==
X-WBNR-Posting-Host: 164.164.87.57
From: =?Utf-8?B?R3VydSBTbWFyYW4=?= <GuruSmaran@discussions.microsoft.com>
Subject: Searching profiles in CS2002
Date: Mon, 14 Aug 2006 06:08:01 -0700
Lines: 41
Message-ID: <8017124F-D4FD-43E6-A621-2CC3C91499ED@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.commerceserver.general
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18152
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.general

Hi,

We are using CS2002 with SQL2k and VS.net 2003 on Win2003. We have created
a
few profiles in CS2002, and they are working properly in ASP.net. The
profiles typically have the following fields:

Full Name
Address
Phone
Country
Bio
Links

The users have to personalize their content and then publish their profile
pages, and they get a virtual directory created in IIS. The published
profile
pages are stored as an ASPX page under the user's directory. The data in
the
ASPX page is populated from the database in realtime.

Now, we have been asked to incorporate a search functionality, where the
"Full Name" field is to be searched. We would have to incorporate this
using
CS2002 and MS Indexing Services.

I had a look at Indexing Services, and realised that the search looked for
words/phrases only within documents that are present under the scope of the
catalog.

Now, I'm not sure if we can integrate CS2002 and Indexing Services, and
have
the following doubts:

1. I have heard of CS's search capability. Does CS have an inbuilt search
engine? If yes, how do I use this in the BizDesk, and how do I incorporate
the search in .net?

2. How do we make Indexing Services search for objects in a CS2002 profile?

Please help. :-)

Regards,
GS

--

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.