search

dotnetcore / FreeSql

🦄 .NET aot orm, C# orm, VB.NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, 虚谷 orm, 国产 orm, Clickhouse orm, DuckDB orm, TDengine orm, QuestDB orm, MsAccess orm.
https://freesql.net
MIT License
4.13k stars 860 forks source link

一对一多字段关联 #1930

Open gudufy opened 6 days ago

gudufy commented 6 days ago

使用场景

比如我有个SEO表，文章分类都要用到，我希望通过id和类型来关联，在freesql里该怎么做
2881099 commented 6 days ago

List 设置关联字段

gudufy commented 5 days ago

List 设置关联字段

比如下面的类我该如何完善呢？

public class Article {
     public long Id {get; set;}
     public Seo Seo  {get;set;}
}
public class Category{
     public long Id {get; set;}
     public Seo Seo  {get;set;}
}
public class Seo {
    public long id {get;set;}
}
2881099 commented 5 days ago 
public class Article {
     public long Id {get; set;}
     public long SeoId {get; set;}
     public Seo Seo  {get;set;}
}
public class Category{
     public long Id {get; set;}
     public long SeoId {get; set;}
     public Seo Seo  {get;set;}
}
public class Seo {
    public long id {get;set;}
}