//@nuget: Microsoft.EntityFrameworkCore

//@nuget: Microsoft.EntityFrameworkCore.InMemory

​

using Microsoft.EntityFrameworkCore;

using System;

using System.Diagnostics;

using System.Linq;

​

using var context = new TestContext(new DbContextOptionsBuilder<TestContext>().UseInMemoryDatabase("test").Options);

var item = new Item { Text = "abcdef" };

context.Item.Add(item);

context.SaveChanges();

var stopWatch = new Stopwatch();

stopWatch.Start();

for (var i = 0; i <= 10000; i++)

{

    //var obj = context.Item.SingleOrDefault(x => x.ItemId == i);

    var obj = context.Item.Find(i);

}

Console.WriteLine($"{stopWatch.ElapsedMilliseconds}ms");

​

public class Item

{

    public int ItemId { get; set; }

    public string Text { get; set; }

}

​

public class TestContext : DbContext

{

    public TestContext(){ }

​

    public TestContext(DbContextOptions<TestContext> options)

        : base(options){ }

​

    public DbSet<Item> Item { get; set; }

}