Dapper.Bulk contains helper methods for bulk inserting.
PM> Install-Package Dapper.Bulk
- Inserts entities, without result for best performance:
connection.BulkInsert(data);
await connection.BulkInsertAsync(data);
- Inserts and returns inserted entities:
var inserted = connection.BulkInsertAndSelect(data);
var inserted = await connection.BulkInsertAndSelectAsync(data);
TableName
is TypeName + s. When InterfaceI
is removed.Key
is Id property (case-insensitive)
TableName
- somewhere before usage call.
TableMapper.SetupConvention("tbl", "s")
We do not rely on specific attributes. This means you can use whatever attributes with following names:
TableAttribute
- Must have string Name property. Exists in System.ComponentModel.Annotations Nuget.ColumnAttribute
- Must have string Name property. Exists in System.ComponentModel.Annotations Nuget.KeyAttribute
- Marking only attribute. Exists in System.ComponentModel.Annotations Nuget.ComputedAttribute
- Marking only attribute. For fields returned from Db.NotMapped
- Marking only attribute. For ignored fields.
// Table Cars by default convention
public class Car
{
// Identity by convention
public int Id { get; set; }
public string Name { get; set; }
public DateTime ManufactureDate { get; set; }
}
// Supported in v1.2+
public enum CarType : int
{
Classic = 1,
Coupe = 2
}
[Table("tblCars")]
public class Car
{
[Key] // Identity
public int CarId { get; set; }
public string Name { get; set; }
public CarType CarType { get; set; } //SQL Data Type should match Enum type
[Computed] // Will be ignored for inserts, but the value in database after insert will be returned
public DateTime ManufactureDate { get; set; }
}
public class IdentityAndNotMappedTest
{
[Key]
public int IdKey { get; set; }
public string Name { get; set; }
// Will be ignored for inserts
public virtual TestSublass TestSublass { get; set; }
[NotMapped] // Will be ignored for inserts
public int Ignored { get; set; }
}
// Supported in v1.4+
private class CustomColumnName
{
[Key]
public int IdKey { get; set; }
[Column("Name_1")] // Will map to SQL column Name_1
public string Name { get; set; }
[Column("Int_Col")] // Will map to SQL column Int_Col
public int IntCol { get; set; }
[Column("Long_Col")] // Will map to SQL column Long_Col
public long LongCol { get; set; }
[NotMapped] // Will be ignored for inserts
public int Ignored { get; set; }
[Write(false)] // Will be ignored for inserts
public int Ignored { get; set; }
}