Error while using await to add elements into database C#

Question

Sample code:

static async Task Main(string[] args)
{
    using (var context = new DBContext())
        {
            await context.Objects.Add(new Level
            {  
                Id = 1,
                Name = "Name 1"
            });
        }
}

Creates error:

Objects does not contain a definition for 'GetAwaiter' and no accessible extension method 'GetAwaiter' accepting a first argument of type 'Objects' could be found.

It's TPH database, Objects is class at the top of hierarchy.

I have no idea how to fix it, i'm not sure why it doesn't work here. I have heard it can be issue with using older C# (i don't use 8.0 because i'm unable to upgrade it).

DbSet<T>.Add(T) does not return a Task. If you want to persist what you have added to the DbSet<T> then call DbContext.SaveChangesAsync and await the resulting Task that this call returns. — Igor
– Igor, Commented Mar 24, 2020 at 16:34
i'm not sure why it doesn't work here it wont, there's no task returned as mentioned already. Looking at that code, there's honestly no reason to even try and await it. — Trevor
– Trevor, Commented Mar 24, 2020 at 16:35
@Igor It's not the constructor ( that's missing, it's the close for Add. — Jasper Kent
– Jasper Kent, Commented Mar 24, 2020 at 16:38

Jasper Kent · Accepted Answer · 2020-03-25 08:30:03Z

2

Adding doesn't do any heavyweight operations. It simply adds the object to the in-memory context, not the database. Therefore there is no point (or opportunity) to do it asynchronously.

Data is sent to the database only when you do

context.SaveChanges();

so you can do

await context.SaveChangesAsync()

at that point.

edited Mar 25, 2020 at 8:30

answered Mar 24, 2020 at 16:37

Jasper Kent

3,69618 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

Error while using await to add elements into database C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related