Dapper Rainbow Insert Data

Inserting data into the database is one of the CRUD operations that act on an individual row by inserting a row.

The Dapper.Rainbow library provides an Insert extension method to insert data into the database.

The following example inserts a single new record.

private static void InsertSingleAuthor()
    using (DbConnection connection = new SqlConnection(ConnectionString))
        var db = RainbowDatabase.Init(connection, commandTimeout: 2); 
        Author author = new Author()
            FirstName = "Mindy",
            LastName = "Kaling"


If you retrieve all the authors from the database, you will see that the above author is added at the end.

static void Main(string[] args)
    List<Author> authors = GetAllAuthors();

    foreach (var author in authors)
        Console.WriteLine(author.FirstName + " " + author.LastName);

Let's execute the above code, and you will see the following output.

Cardinal Tom B. Erichsen
William Shakespeare
Robert T. Kiyosaki
Mindy Kaling