我正在尝试在同一个表中添加类别之间的关系 . 我有一个
类别(ID INTEGER PRIMARY KEY AUTOINCREMENT,NAME TEXT)
表和
CATEGORIES_CATEGORIES(ID INTEGER PRIMARY KEY AUTOINCREMENT,CATEGORIES_ID INTEGER NOT NULL,SUBCATEGORIES_ID INTEGER NOT NULL)
表 .
我正试图将它们与Vici Coolstorage ORM一起绘制 . 我上了课
Category class
[MapTo("CATEGORIES")]
public abstract class Category : CSObject<Category>
{
public abstract int Id { get; }
public abstract string Name { get; set; }
[ManyToMany("CATEGORIES_CATEGORIES", Pure = true)]
public abstract CSList<CategoryCategory> Subcategories { get; set; }
}
CategoryCategory class
[MapTo("CATEGORIES_CATEGORIES")]
public abstract class CategoryCategory : CSObject<CategoryCategory>
{
public abstract int Id { get; }
[ManyToOne(LocalKey = "CATEGORIES_ID", ForeignKey = "ID")]
public abstract Category Cat { get; set; }
[ManyToOne(LocalKey = "SUBCATEGORIES_ID", ForeignKey = "ID")]
public abstract Category SubCat { get; set; }
}
但我不能让它发挥作用 . 任何人都可以帮助我实现这种关系吗?
1 回答
您的映射表不应该是多对多关系的目标 .
尝试这样的事情: