using Dapper;

using System;

using System.Collections.Generic;

using System.Data.SqlClient;

using Z.Dapper.Plus;

using System.Linq;

​

public class Program

{

    public static void Main()

    {

        CreateDatabase();

        SetGlobalMapping();

        // Generate invoices

        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"));

    }

​

#region Mapping

    public static void SetGlobalMapping()

    {

        DapperPlusManager.Entity<ClaimHash>("MapProspectiveClaim").Table("PROSPECTIVE_HASH_CHECK").Map(x => new

        {

        x.ActiveInd

        }).Key(x => new

        {

        x.ProspectiveClaimId, x.Clientid, x.ClaimType

        });

    }

​

#endregion

    public class ClaimHash

    {

        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());

        connection.Execute(@"

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

    )

​

");

    }

}