Are Bulkoperations possible?

[janbiehl]

Hey, first i want to point out that i love the idea of this library and i recently discovered it. I have a question about bulk operations. Is there a chance to do bulk operations for example inserts?

Before i discovered this library i would have done it like below. I love the idea of doing just the formattable string thing and would like to adapt that also for the buk operations.

public async Task<ErrorOr<Success>> CreateBulkAsync(IReadOnlyCollection<RoleEntity> entities, 
CancellationToken cancellationToken = default)
{
	var parameters = entities.Select(entity => new
	{
		name = entity.Name,
		descriptioN = entity.Description
	});

	CommandDefinition definition = new ("""
	                                    INSERT INTO roles (name, description)
	                                    VALUES (@name, @description)
	                                    """, parameters);
	await Connection.ExecuteAsync(definition);

	return new Success();
}

If possible please point me to a example.
Thank you