About asp.net web api core PUT method

Sushant Torankar

hello,

I am new to asp.net web api core 5.0 entity framework database first approach

I am using PUT method to update details of my CONTACT table. Table has more than 8 columns . I am updating only 5 columns using PUT verb. It is updating the details, but it is making other columns NULL which are not included in my code

For ex. I am not passing "CreatedDate" column in code, but it is making that column NULL

I only want to update columns which I am ppassing to my code, the other columns should not get null

Following is my Update Repository code ;

public async Task UpdateContactAsync(Guid id, ContactsMaster CM)
{
var contact = await _context.ContactsMasters.FindAsync(id);
if (contact != null)
{
contact.UserId = CM.UserId;
contact.ContactName = CM.ContactName;
contact.EmailAddress = CM.EmailAddress;
contact.PhoneNumber = CM.PhoneNumber;
contact.Relationship = CM.Relationship;

await _context.SaveChangesAsync();
}
}
}

Thank you

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sushant Torankar4y ago
thank you everyone for reply
Looks like the code is working
Sachin Singh4y ago
you can use Update() method as well
public async Task UpdateContactAsync(Guid id, ContactsMaster CM)
        {
            var contact = await _context.ContactsMasters.FindAsync(id);
            if (contact != null)
            {
                contact.UserId = CM.UserId;
                contact.ContactName = CM.ContactName;
                contact.EmailAddress = CM.EmailAddress;
                contact.PhoneNumber = CM.PhoneNumber;
                contact.Relationship = CM.Relationship;
                _context.Contacts.Update(contact);
                await _context.SaveChangesAsync();
            }
        }
or
public async Task UpdateContactAsync(Guid id, ContactsMaster CM)
        {
            var contact = await _context.ContactsMasters.FindAsync(id);
            if (contact != null)
            {
                contact.UserId = CM.UserId;
                contact.ContactName = CM.ContactName;
                contact.EmailAddress = CM.EmailAddress;
                contact.PhoneNumber = CM.PhoneNumber;
                contact.Relationship = CM.Relationship;
                _context.Entry(contact).state=EntityState.Modified;
                await _context.SaveChangesAsync();
            }
        }
Riccardo Rigutini4y ago
Hi,
I just tried your code but it's working correctly for me, do you have any other information you can share? (entity framework version, table/entity structure...)
If you place a breakpoint before the SaveChangesAsync and inspect the content of the contact object, do all properties have the correct values?

As an alternative, you can try using directly the CM object for the update, attaching it to the context and setting it as modified (I'm assuming CM and contact are of the same type):
public async Task UpdateContactAsync(Guid id, ContactsMaster CM)
{
    var contact = await _context.ContactsMasters.FindAsync(id);
    if (contact != null)
    {
        // set the not updated values from contact (including the id) if not already set
        CM.CreatedDate = contact.CreatedDate;
        // ...

        _context.ContactsMasters.Attach(CM);
        _context.Entry(CM).State = EntityState.Modified;

        await _context.SaveChangesAsync();
    }
}