How can i insert into multiple tables using Linq?

Question

How can i Insert record into multiple tables using Linq?

I have three related tables Contact, Phone and Email, Is it possible to create Contact first then Phone or Email. Since Phone and Email use ContactID as a foreign Key

Here is my linq expression looks like:

 var Contact = Mapper.Map<Contact>(request.CreateContactInformation);
    Contact.CreatedBy = request.CreateContactInformation.CreatedBy;
    Contact.CreatedDate = SystemClock.UtcNow;
    Contact.UpdatedBy = request.CreateContactInformation.UpdatedBy;
    Contact.UpdatedDate = SystemClock.UtcNow;

    await Context.AddAsync(Contact);
    await Context.SaveChangesAsync();

    var phones = Mapper.Map<Phone>(request.CreateContactInformation);
    phones.ContactID = Contact.ID;
    phones.PhoneNumber = request.CreateContactInformation.PhoneNumber;     
    Context.AddAsync(phones);
    await Context.SaveChangesAsync();


    var email = Mapper.Map<Email>(request.CreateContactInformation);
    email.ContactID = Contact.ID;
    email.EmailAddress = request.CreateContactInformation.Email;
    Context.AddAsync(email);
    await Context.SaveChangesAsync();

But i get this exception error

InternalServerError. Error Content: System.ArgumentException: Cannot create an instance of abstract type ....EF.Base.BaseEntity. (Parameter 'type') at ...AsyncTransactionInterceptor.InterceptAsync[T](Task`1 task, String methodName)

Look like we need more detail about your model to resolve the problem.If there're some abstract method in the model. — talesa82035
– talesa82035, Commented May 25, 2020 at 5:06

talesa82035 · Accepted Answer · 2020-05-25 03:40:02Z

0

I am not very sure about what your context actually is. But I guess your Add function might look like :

  await Context.Contact.AddAsync(Contact);

Since you are not specifying which table to insert. And in other AddAsync() function , you need to enclose it by await. Or it'll still be a Task , and will not be invoked.

answered May 25, 2020 at 3:40

talesa82035

1245 bronze badges

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

1 Comment

Rob Over a year ago

Thank you Talesa!, i tried that still gives me the same error

Collectives™ on Stack Overflow

How can i insert into multiple tables using Linq?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related