Thanks

Posts   
 
    
rboarman
User
Posts: 83
Joined: 01-Feb-2005
# Posted on: 09-Aug-2006 23:57:48   

Like usual, you guys are the best. I don't see how I missed that in the documentation.

Now for a follow-up question. In my WebService, I am being passed a string array (string[]) and want to use that in the filter to filter against a uniqueidentifier column (Guid).

It seems like I have to copy my string[] into a Guid[] in order for the code to run. If I don't, I get a "cannot convert strings to guids" error.

The Where clause is going to end up with strings anyways so this conversion seems redundant.

Am I missing something?

Thanks,

Rick

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 10-Aug-2006 06:23:38   

The Where clause is going to end up with strings anyways so this conversion seems redundant.

The query is built using SqlParameters with the appropriate dataTypes.