USE master
GO
CREATE DATABASE InMemDb CONTAINMENT = NONE
ON PRIMARY (
  NAME = N'InMemDb', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\InMemDb.mdf' ,
  SIZE = 275456KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), 
FILEGROUP [MEMGROUP] CONTAINS MEMORY_OPTIMIZED_DATA  DEFAULT (
  NAME = N'MemDataFile', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\MemDataFile' ,
  MAXSIZE = UNLIMITED
)
LOG ON (
  NAME = N'InMemDb_log',
  FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\InMemDb_log.ldf' ,
  SIZE = 1341696KB , MAXSIZE = 2048GB , FILEGROWTH = 10%
)
GO

use InMemDb
go
create table dbo.NotInMemory (
  id bigint identity not null primary key nonclustered,
  n int not null,
)
go
create table dbo.InMemory (
  id bigint identity NOT NULL,
  n int not null,
  primary key nonclustered hash (id) with (bucket_count = 1048576)
) with (memory_optimized = on, durability = schema_only)
go
select @@version;

Microsoft SQL Server 2014 (SP2-CU12) (KB4130489) - 12.0.5589.7 (X64) 
	Jun  9 2018 11:17:15 
	Copyright (c) Microsoft Corporation
	Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

public class Program
{
  public static void Main(string[] args)
    => BenchmarkRunner.Run<Program>();

  [Benchmark]
  public void InMemoryInsert()
  {
    using(var cnn = new SqlConnection("Data Source=.;Initial Catalog=InMemDb;Integrated Security=True"))
    {
      cnn.Open();
      using(var tran = cnn.BeginTransaction())
      {
        using(var cmd = new SqlCommand("insert into dbo.InMemory(n) values(@n)", cnn, tran))
        {
          var p = cmd.Parameters.Add("@n", SqlDbType.Int);
          using(var idr = new IntDataReader())
            while(idr.Read())
            {
              p.Value = idr.GetValue(0);
              cmd.ExecuteNonQuery();
            }
        }
        tran.Commit();
      }
    }
  }

  [Benchmark]
  public void BulkInsert()
  {
    using(var cnn = new SqlConnection("Data Source=.;Initial Catalog=InMemDb;Integrated Security=True"))
    {
      cnn.Open();
      using(var bc = new SqlBulkCopy(cnn))
      {
        bc.DestinationTableName = "dbo.NotInMemory";
        bc.ColumnMappings.Add(0, 1);
        using(var idr = new IntDataReader())
          bc.WriteToServer(idr);
      }
    }
  }

  class IntDataReader : IDataReader
  {
    const int MaxValue = 10000;
    public void Close() => RecordsAffected = MaxValue;
    public void Dispose() => Close();
    public bool Read() => RecordsAffected < MaxValue;
    public int FieldCount => 1;
    public int Depth => 0;
    public bool IsClosed => RecordsAffected >= MaxValue;
    public int RecordsAffected { get; private set; }
    public object GetValue(int i) => RecordsAffected++;

    public string GetName(int i) => throw new NotImplementedException();
    public string GetDataTypeName(int i) => throw new NotImplementedException();
    public Type GetFieldType(int i) => throw new NotImplementedException();
    public int GetValues(object[] values) => throw new NotImplementedException();
    public int GetOrdinal(string name) => throw new NotImplementedException();
    public bool GetBoolean(int i) => throw new NotImplementedException();
    public byte GetByte(int i) => throw new NotImplementedException();
    public long GetBytes(int i, long fieldOffset, byte[] buffer, int bufferoffset, int length)
      => throw new NotImplementedException();
    public char GetChar(int i) => throw new NotImplementedException();
    public long GetChars(int i, long fieldoffset, char[] buffer, int bufferoffset, int length)
      => throw new NotImplementedException();
    public Guid GetGuid(int i) => throw new NotImplementedException();
    public short GetInt16(int i) => throw new NotImplementedException();
    public int GetInt32(int i) => throw new NotImplementedException();
    public long GetInt64(int i) => throw new NotImplementedException();
    public float GetFloat(int i) => throw new NotImplementedException();
    public double GetDouble(int i) => throw new NotImplementedException();
    public string GetString(int i) => throw new NotImplementedException();
    public decimal GetDecimal(int i) => throw new NotImplementedException();
    public DateTime GetDateTime(int i) => throw new NotImplementedException();
    public IDataReader GetData(int i) => throw new NotImplementedException();
    public bool IsDBNull(int i) => throw new NotImplementedException();
    public object this[int i] => throw new NotImplementedException();
    public object this[string name] => throw new NotImplementedException();
    public DataTable GetSchemaTable() => throw new NotImplementedException();
    public bool NextResult() => throw new NotImplementedException();
  }
}

         Method |      Mean |     Error |    StdDev |
--------------- |----------:|----------:|----------:|
 InMemoryInsert | 578.86 ms | 5.4307 ms | 5.0799 ms |
     BulkInsert |  66.25 ms | 0.9006 ms | 0.7520 ms |