How you can use Dapper Plus in .NET Core

To put in these packages, choose the challenge within the Resolution Explorer window, then right-click and choose “Handle NuGet Packages.” Within the NuGet Package deal Supervisor window, seek for the Dapper.Plus and Microsoft.Information.Sqlite packages and set up them.

Alternatively, you may set up the Dapper Plus and Dapper packages utilizing the NuGet Package deal Supervisor console by coming into the instructions beneath.

PM> Set up-Package deal Z.Dapper.Plus
PM> Set up-Package deal Dapper

Insert knowledge in bulk utilizing BulkInsert

To insert bulk knowledge (i.e., a number of entity data) in your database, you may make the most of the BulkInsert technique. This technique will insert a number of rows of knowledge within the underlying database desk suddenly. Allow us to look at methods to use the BulkInsert technique to insert bulk knowledge in a database.

Think about the next C# class.

class Creator
{
    public int AuthorId { get; set; }
    public string FirstName { get; set; } = string.Empty;
    public string LastName { get; set; } = string.Empty;
    public string Handle { get; set; } = string.Empty;
    public string Cellphone { get; set; } = string.Empty;
}

The code given beneath illustrates how one can create an inventory of authors, populate knowledge, and return the checklist.

static Checklist GetAuthors()
{
    var authors = new Checklist()
    {
        new Creator() { AuthorId = 1, FirstName = "Joydip", LastName = "Kanjilal", Handle = "Hyderabad, India", Cellphone = "1234567890" },
        new Creator() { AuthorId = 2, FirstName = "Steve", LastName = "Smith", Handle = "Texas, USA", Cellphone = "0987654321" }
    };
    return authors;
}

You map your entity utilizing the DapperPlusManager.Entity technique as proven beneath. Notice how the Id extension technique has been known as to configure the identification column, i.e., AuthorId on this instance.