EntityFrameworkCore/issues/11826

issues11826.cs

using Microsoft.EntityFrameworkCore;
using System;
using System.Linq;

namespace ConsoleApp1
{
    public class TestModel
    {
        public int Id { get; set; }
        public string Name { get; set; }
    }

    public class TestContext : DbContext
    {
        public TestContext(string databaseName)
            : base(new DbContextOptionsBuilder<TestContext>()
                  .UseInMemoryDatabase(databaseName)
                    .Options)
        { }

        public DbSet<TestModel> SomeEntities { get; set; }
    }

    internal class Program
    {
        private static void Main(string[] args)
        {
            using (var context = new TestContext("DatabaseA"))
            {
                context.Set<TestModel>().Add(new TestModel() { Name = "DatabaseAFirstModel" });
                context.SaveChanges();

                context.Set<TestModel>().ToList().ForEach(m => Console.WriteLine($"{m.Id} : {m.Name}"));

                /* ---- Prints ----

		1 : DatabaseAFirstModel

		*/
            }

            using (var context = new TestContext("DatabaseB"))
            {
                context.Set<TestModel>().Add(new TestModel() { Name = "DatabaseBFirstModel" });
                context.SaveChanges();

                context.Set<TestModel>().ToList().ForEach(m => Console.WriteLine($"{m.Id} : {m.Name}"));

                /* ---- Prints ----

		2 : DatabaseBFirstModel

		*/
            }

            using (var context = new TestContext("DatabaseA"))
            {
                context.Set<TestModel>().Add(new TestModel() { Name = "DatabaseASecondModel" });
                context.SaveChanges();

                context.Set<TestModel>().ToList().ForEach(m => Console.WriteLine($"{m.Id} : {m.Name}"));

                /* ---- Prints ----

		1 : DatabaseAFirstModel
		3 : DatabaseASecondModel

		*/
            }
        }
    }
}