using System.Collections.Generic;
using System.Data.SqlClient;
public static void Main()
var hash = new List<ClaimHash>();
for (int i = 0; i < 3; i++)
hash.Add(new ClaimHash() {Clientid = "25", ProcessId = 1, ClaimType = "P", BillingId = "MMM", ProspectiveClaimId = "pci_" + i, Ptype = "P", ActiveInd = "Y"});
var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer());
connection.UseBulkOptions(options => options.BatchSize = 10).BulkInsert(hash);
FiddleHelper.WriteTable("1 - Invoice", connection.Query("SELECT * FROM PROSPECTIVE_HASH_CHECK"));
public static void SetGlobalMapping()
DapperPlusManager.Entity<ClaimHash>("MapProspectiveClaim").Table("PROSPECTIVE_HASH_CHECK").Map(x => new
x.ProspectiveClaimId, x.Clientid, x.ClaimType
public long ID { get; set; }
public string Clientid { get; set; }
public long ProcessId { get; set; }
public string ClaimType { get; set; }
public string BillingId { get; set; }
public string ProspectiveClaimId { get; set; }
public string Ptype { get; set; }
public string ActiveInd { get; set; }
public static void CreateDatabase()
var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer());
CREATE TABLE PROSPECTIVE_HASH_CHECK(
[ID] [bigint] IDENTITY(1,1) NOT NULL,
[Clientid] [bigint] NOT NULL,
[ProcessId] [bigint] NOT NULL,
[ClaimType] [char](1) NOT NULL,
[BillingId] [varchar](5) NULL,
[ProspectiveClaimId] [nvarchar](50) NOT NULL,
[Ptype] [varchar](1) NOT NULL,
[ActiveInd] [char](1) NULL