Check if a table is empty with Entity Framework using CodeFirst

Question

I'm developing an application using MVVM where i want to use Entity Framwork 5.0. It's my first time using EF, so hope i can explain my problem so you all understand. My application has a embedded database and im using Code-First approach.

Here is an example to illustrate the problem: Here i set my Project model which i set as a table in the embedded database, if i understand correct.

class CreateDbContext : DbContext
{
    public CreateDbContext() : base() { }

    public CreateDbContext(String nameOrConnectionString) : base(nameOrConnectionString) { }

    public DbSet<Project> Projects { set; get; }
}

Now in my ProjectViewModel i want to check if the Project table is empty in the database, before doing anything.

using (var db = new CreateDbContext())
{
    if(db.Projects <-- checked if this is Tablet is empty ??)
}

How should i do that, or is it even possible?

score 43 · Accepted Answer · answered Apr 24 '13 at 13:19

43

This should work:

using (var db = new CreateDbContext())
{
    if(!db.Projects.Any())
    {
        // The table is empty
    }
}

answered Apr 24 '13 at 13:19

greg84

7,541
3
36
45

Hey greg84. That was very simple and works like a charm. Thanks alot m8 – RooKie- Apr 24 '13 at 13:26
you should mark it as the answer since it was what you were asking for – Charles380 Apr 24 '13 at 13:34
Have already done that, but had to wait 8 minutes before i was able to mark the answer. – RooKie- Apr 24 '13 at 13:36
4

Also don't forget to add `using System.Linq;`. – A-Sharabiani Feb 25 '17 at 20:55

score 3 · Answer 2 · edited May 23 '17 at 12:26

3

You can also use Count():

if(db.Projects.Count() == 0) 
{
    // The table is empty.
}

To see the differences between Any() and Count() see this question.

edited May 23 '17 at 12:26

Community

1
1

answered Feb 25 '17 at 21:01

A-Sharabiani

17,750
17
113
128

Check if a table is empty with Entity Framework using CodeFirst

2 Answers2