Array comparison with Linq in Asp.NET MVC

Question

I am using linq in Asp.NET MVC project for database operations. I want to attract customers who have sitecode in the AgentHealth table. How can I do this with linq in one operation?

var CurrentCustomers = new List<Customer>();
var CurrentCustomersDisc = Database.Session
                                   .Query<agenthealts>()
                                   .ToList()
                                   .Select(x => x.sitecode)
                                   .Distinct()
                                   .ToList();

foreach(var CurrentDisc in CurrentCustomersDisc)
{
    var TempCustomer = Database.Session
                               .Query<Customer>()
                               .FirstOrDefault(x => x.deleted_at == null 
                                                 && x.SiteCode == CurrentDisc);
    if(TempCustomer != null)
    {
        CurrentCustomers.Add(TempCustomer);
    }               
}

Do you want to fetch one random customer from each agenthealth, SiteCode == CurrentDisc and place all these customers in a list? — Christos
– Christos, Commented Aug 27, 2017 at 9:51
Yes, CurrentCustomersDisc is an array of sitecodes and each customer has a sitecode. — İsmail Kasap
– İsmail Kasap, Commented Aug 27, 2017 at 9:53
Please check my answer. Furthermore, please update your question stating explicitly that you are looking for is a list that would contains a customer from each agenthealth, in order to be clear what is the questionable. Thanks — Christos
– Christos, Commented Aug 27, 2017 at 10:03
This looks like it could be done in a single simple query in SQL. I don't know about that linq-frontend-to-sql though. Is this Entity Framework? — Vilx-
– Vilx-, Commented Aug 27, 2017 at 10:07
@İsmail Kasap - Please tag the framework used - seems like NHibernate by the Session.Query, is that correct? — Gilad Green
– Gilad Green, Commented Aug 27, 2017 at 10:08

Ashkan Mobayen Khiabani · Accepted Answer · 2017-08-27 09:57:22Z

1

You can select customers where their Id (or what the primary key is) in `CurrentCustomersDisc':

var CurrentCustomers = Database.Session.Query<Customer>.Where(c=>
     CurrentCustomersDisc.Select(cc=> cc.Id).Contains(c.Id));

edited Aug 27, 2017 at 9:57

answered Aug 27, 2017 at 9:51

Ashkan Mobayen Khiabani

34.3k35 gold badges111 silver badges187 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ashkan Mobayen Khiabani Over a year ago

Rica ederim ;) İsmail bey

Collectives™ on Stack Overflow

Array comparison with Linq in Asp.NET MVC

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related