using System;

using System.Collections.Generic;

using System.Data.SqlClient;

using System.Linq;

using Dapper;

using Z.Dapper.Plus;

​

public class Program

{   

    public static void Main()

    {

        CreateDatabase();       

        SetGlobalMapping();

        var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer());

        var equity = new Equity()

        {

            Ticker = "AAPL",

            Name = "Apple",

            CUSIP = "123456789",

            DividendYield = 1.2

        };

        // Inserting an equity should insert a record in the Security and Equity tables. How to get this to work?

        // connection.BulkInsert(equity);

        equity.DividendYield = 3;

        equity.Modified = DateTime.Now;

        // Updating the equity should update the Equity table and Security table. How to get this to work?

        // connection.BulkUpdate(equity);

​

        FiddleHelper.WriteTable("1 - Security", connection.Query<Invoice>("SELECT * FROM Security"));

        FiddleHelper.WriteTable("2 - Equity", connection.Query<InvoiceMeta>("SELECT * FROM Equity"));

    }

    #region Mapping

    public static void SetGlobalMapping()

    {

        DapperPlusManager.Entity<Security>().Identity(x => x.ID, true);

    }

    #endregion

​

    #region Entity

    public abstract class Security 

    {

        public int ID { get; set; }

        public string Ticker { get; set; }

        public string Name { get; set; }

        public string CUSIP { get; set; }

        public DateTime Modified {get; set; }

    }

    public class Equity : Security

    {

        public int SecurityID { get; set; }

        public double DividendYield { get; set; }

    }

    #endregion

    #region CreateDatabase

​

    public static void CreateDatabase()

    {

        var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer());

        connection.Execute(@"

CREATE TABLE [dbo].[Security]

(

    [ID] [INT] IDENTITY(100, 1) PRIMARY KEY NOT NULL,

    [Ticker] [VARCHAR](50) NOT NULL,

    [Name] [VARCHAR](255) NOT NULL,

    [CUSIP] [VARCHAR](50) NOT NULL,

    [Modified] DATETIME NOT NULL,

);

​

CREATE TABLE [dbo].[Equity]

(

    [SecurityID] [INT] PRIMARY KEY NOT NULL REFERENCES dbo.[Security](ID),

    [DividendYield] FLOAT NOT NULL

);

");

    }

    #endregion

}