Breaking News: Grepper is joining You.com. Read the official announcement!

inserting into 2 or more tables using transaction in web api c#

OLUWATOBI USMAN ADEBANJO answered on May 22, 2023 Popularity 1/10 Helpfulness 1/10

answer inserting into 2 or more tables using transaction in web api c#

inserting into 2 or more tables using transaction in web api c#

Comment

public class ClassMain
{
    [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int ClassMainId { get; set; }

    [InverseProperty("ClassMain")]
    public virtual ICollection<ClassA> ClassAs { get; set;} = new List<ClassA>();
    [InverseProperty("ClassMain")]
    public virtual ICollection<ClassB> ClassBs { get; set;} = new List<ClassB>();
}

public class ClassA
{
    [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int ClassAId { get; set; }

    public int ClassMainId { get; set; }
    [ForeignKey("ClassMainId")]
    public virtual ClassMain ClassMain{ get; set; }
    public string ClassAName { get; set; }
}

Public class ClassB
{
    [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int ClassBId { get; set; }

    public int ClassMainId { get; set; }
    [ForeignKey("ClassMainId")]
    public virtual ClassMain ClassMain{ get; set; }

    public string ClassBName { get; set; }
}

This uses a transaction to save in 2 or more tables using EFCore and rolls back when something goes wrong with a particular table insertion

Popularity 1/10 Helpfulness 1/10 Language csharp

Source: stackoverflow.com

Tags: api c# using web

Link to this answer
Share Copy Link

Contributed on May 22 2023

OLUWATOBI USMAN ADEBANJO

0 Answers Avg Quality 2/10

inserting into 2 or more tables using transaction in web api c#

Contents

More Related Answers

inserting into 2 or more tables using transaction in web api c#

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.