C# Linq Query Question

Question

Good Evening everyone,

I've been trying to figure out the most efficient way to do this, but am falling short. Here's how it goes...

I am ultimately trying to determine "like customers" based on a specific customer's buying habits and a given threshold, say 50%. IE customer 1 purchased products A,B,C,D  ... customer 2 purchased B,C,D,E ... these two customers are >= 50% "likeness" so they should be matched.

My schema is as would be expected

CLIENT (1 ----- many)  CLIENT_PURCHASE (1 -------many) PRODUCT

*clientID                      *clientID *prodID                            *prodID

For now I am ignoring the threshold and simply am trying to find customers who have purchased any item within customer 1's history via a linq subquery. I think I have this working with the following two queries:

var clientOneHistory = (from cp in client.Client_Purchase                           
select cp.prodID).ToList();
 
var matchedClients = (from cp in db.Client_Purchase
where clientOneHistory.Contains(cp.prodID)                   
select cp.Client.fullname).Distinct().ToList();  

var clientOneHistory = (from cp in client.Client_Purchase
                               select cp.prodID).ToList();

var matchedClients = (from cp in db.Client_Purchase
                             where clientOneHistory.Contains(cp.prodID)
                             select cp.Client.fullname).Distinct().ToList();

So my ultimate question is, "How do I work in the threshold portion?"

Thanks for your time

Answer 1

You just include the exception details as it will be easier to find the detailed error

Answer 2

Sorry Can't Get Meaning For Your Above Post Please Can You Explain it Clearly

Answer 3

i need to keep ssl=false, and defaultcredentials is =false. ideally, these settings should help. but i guess its something related to machine configuration

Answer 4

Hi.,

Had You Allow Permissions in IIS

If Not Check With Below Method

Go to IIS
IIS---->
Default SMTP Virtual Server (Right Click) ----> Properties ----> Access ----> Relay ----> All Except the List Below (Radio Button) Select that And Click Ok And then Execute Your Code

If U Got Solution With this Mark it Has Accepted

Or Else Please Post The Error

With Regards..,

R.V.Rajagopalan

Answer 5

Please share the sample code and also do the following settings

smtpClient.UseDefaultCredentials = false;

smtpClient.EnableSsl = true;