gistfile1.txt

 public class BaseEntity
    {
        [AutoIncrement]
        [PrimaryKey]
        public long Id { get; set; }
    }

    public class ResearchEntity : BaseEntity
    {
        [References(typeof(NameEntity))]
        public long? PrimaryNameId { get; set; }
        [Reference]
        public NameEntity PrimaryName { get; set; }
        [Reference]
        public List<NameEntity> Names { get; set; } = new List<NameEntity>();
    }


    public class NameEntity : BaseEntity
    {
        public string Value { get; set; }
        [References(typeof(ResearchEntity))]
        public long ResearchId { get; set; }
        [Reference]
        public ResearchEntity Research { get; set; }
    }



    public class UnitTest1
    {

        [Fact]
        public void Test1()
        {
            var dbFactory = new OrmLiteConnectionFactory("Server=127.0.0.1;Database=db2;Port=3307;Uid=root;Pwd=root;", MySqlDialect.Provider);
            var db = dbFactory.Open();
            db.ExecuteSql("SET FOREIGN_KEY_CHECKS = 0;");
            db.DropAndCreateTable<NameEntity>();
            db.DropAndCreateTable<ResearchEntity>();
            db.ExecuteSql("SET FOREIGN_KEY_CHECKS = 1;");
            var research = new ResearchEntity();
            research.Names.Add(new NameEntity { Value = "test 1" });
            research.Names.Add(new NameEntity { Value = "test 2" });
            research.Names.Add(new NameEntity { Value = "test 3" });

            db.Save(research, references: true);
            research.PrimaryName = research.Names[1];
            db.Save(research, references: true);

            var res = db.LoadSelect(db.From<ResearchEntity>().Where(x => x.Id == 1));


        }
    }