Entity Framework linq bool response

Question

I have 3 tables: main account, activities & trades.

What I want is to return a bool, based on wither or not a main account has any trades associated with it (connect via an account id column in main account table).

I'm able to tie back the main account and it's associated activities with the following linq query:

From ma in context.MainAccounts
From ac in context.Activities.where(ac => ac.AccountId == ma.AccountId
Select new MainAccountDto{

}

However, I'm struggling to workout how I can set a HasTrades column on my dto object.

I'm not wanting any data from the activities table, just if there are any activities. Would someone be able to please point me in the right direction?

Use navigation property MainAccount.Activities. Don't join manually, as you and the answers (so far) do. Then it's simply HasTrades = ma.Activities.Any(). — Gert Arnold
– Gert Arnold, Commented Feb 12 at 16:31

Dave Morrison · Accepted Answer · 2025-02-12 15:55:13Z

1

You can achieve this by using .Any() in your LINQ query to check if there are any trades associated with a given MainAccount.

Perhaps something like this:

select new MainAccountDto
{
    AccountId = ma.AccountId,
    HasTrades = context.Trades.Any(t => t.AccountId == ma.AccountId)
};

answered Feb 12 at 15:55

Dave Morrison

3073 silver badges13 bronze badges

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

Comments

GH DevOps · Accepted Answer · 2025-02-12 15:59:31Z

0

If I'm understanding you correctly, maybe:

var dto = (from ma in context.MainAccounts
           let hasTrades = (from ac in context.Activities where ac.AccountId == ma.AccountId select ac).Any()
           select new MainAccountDto{ HasTrades = hasTrades }).Tolist();

answered Feb 12 at 15:59

GH DevOps

5123 silver badges18 bronze badges

Collectives™ on Stack Overflow

Entity Framework linq bool response

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related