Is it Possible to Get Multiple Data Type using a Single Query in Entity Framework?

Question

I have a ViewModel looks like this :

public int AllRecords { get; set; }
public int IsActiveRecords { get; set; }
public int IsDeletedRecords { get; set; }
public List<Setup_Country> Countries { get; set; }

Is it possible to write a single query using Entity Framework to get these data from database ?

If not , then what is the best way to do this ?

Are the first 3 properties the count of all, active and deleted Setup_Country items? — user3559349
– user3559349, Commented Feb 13, 2016 at 11:44
Why not just var countries = db.Setup_Countries.ToList(); var model = new ViewModel { Countries = countries, AllRecords = countries.Count, IsDeletedRecords = countries.Count(x => x.IsDeleted), ... } — user3559349
– user3559349, Commented Feb 13, 2016 at 11:56
I am afraid that it will query database 4 times..... @Stephen Muecke — Bimal Das
– Bimal Das, Commented Feb 13, 2016 at 11:59
No it wont - it only queries the database once - in the first line - the others are referencing the in-memory set — user3559349
– user3559349, Commented Feb 13, 2016 at 12:01

A. Burak Erbora · Accepted Answer · 2016-02-13 12:16:15Z

1

What is the multiplicity you want here? you can fill this ViewModel in like this:

model = new MyViewModel();
model.Countries = db.SetupCountry.ToList();
model.AllRecords  = model.Countries.Count();
model.IsActiveRecords = model.Countries.Count(c => c.IsActive);
model.IsDeletedRecords = model.Countries.Count(c => c.IsDeleted);

As Stephen Muecke Has noted in the comments, this will query the db only once.

Or, if you want a one-liner,

model = new MyViewModel{
    Countries = db.SetupCountry.ToList(),
    AllRecords = db.SetupCountry.Count(),
    IsActiveRecords = db.SetupCountry.Count(c => c.IsActive),
    IsDeletedRecords = db.SetupCountry.Count(c => c.IsDeleted),
}

edited Feb 13, 2016 at 12:16

answered Feb 13, 2016 at 11:55

A. Burak Erbora

1,0742 gold badges12 silver badges26 bronze badges

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

2 Comments

Bimal Das Over a year ago

Can you please tell me which one is the best way ?

A. Burak Erbora Over a year ago

First one, since it's hutting the db only once and is relying on the memory for operations, it's way more efficient.

Collectives™ on Stack Overflow

Is it Possible to Get Multiple Data Type using a Single Query in Entity Framework?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related