use Dapper Plus in .NET Core

To put in these packages, choose the undertaking within the Answer 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’ll be able to set up the Dapper Plus and Dapper packages utilizing the NuGet Package deal Supervisor console by coming into the instructions under.

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’ll be able to reap the benefits of the BulkInsert methodology. This methodology will insert a number of rows of knowledge within the underlying database desk abruptly. Allow us to look at learn how to use the BulkInsert methodology to insert bulk knowledge in a database.

Contemplate the next C# class.

class Writer
{
    public int AuthorId { get; set; }
    public string FirstName { get; set; } = string.Empty;
    public string LastName { get; set; } = string.Empty;
    public string Deal with { get; set; } = string.Empty;
    public string Cellphone { get; set; } = string.Empty;
}

The code given under illustrates how one can create a listing of authors, populate knowledge, and return the checklist.

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

You map your entity utilizing the DapperPlusManager.Entity methodology as proven under. Observe how the Id extension methodology has been referred to as to configure the id column, i.e., AuthorId on this instance.