首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >实体框架返回一个实体的每个被引用的表

实体框架返回一个实体的每个被引用的表
EN

Stack Overflow用户
提问于 2017-06-04 21:55:44
回答 0查看 171关注 0票数 1

我尝试将我的Java项目重写为C# Rest Api项目。对于数据库映射,我使用user Entity Framework,并且在从表中获取记录方面有一些问题。首先,我有一个被其他表引用的表:

代码语言:javascript
复制
CREATE TABLE Bibliogr (
  Bknumber INT PRIMARY KEY NOT NULL,
  Authors VARCHAR(500),
  Source VARCHAR(500),
  Title VARCHAR(1000)
);

映射的类如下:

代码语言:javascript
复制
public partial class Bibliogr
    {
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
        public Bibliogr()
        {
            this.AcOpTabl = new HashSet<AcOpTabl>();
            this.ConstSel = new HashSet<ConstSel>();
            this.CuryTabl = new HashSet<CuryTabl>();
            this.DecrTabl = new HashSet<DecrTabl>();
            this.DensTabl = new HashSet<DensTabl>();
            this.DielDiss = new HashSet<DielDiss>();
            this.Dielectr = new HashSet<Dielectr>();
            this.ElemTabl = new HashSet<ElemTabl>();
            this.ElOpTabl = new HashSet<ElOpTabl>();
            this.EquationTabl = new HashSet<EquationTabl>();
            this.EsOpTabl = new HashSet<EsOpTabl>();
            this.HardTabl = new HashSet<HardTabl>();
            this.HeatExpn = new HashSet<HeatExpn>();
            this.HeatTabl = new HashSet<HeatTabl>();
            this.MechTabl = new HashSet<MechTabl>();
            this.MnOpTabl = new HashSet<MnOpTabl>();
            this.ModfTabl = new HashSet<ModfTabl>();
            this.NlOpTabl = new HashSet<NlOpTabl>();
            this.PlavTabl = new HashSet<PlavTabl>();
            this.PzElTabl = new HashSet<PzElTabl>();
            this.RefrcInd = new HashSet<RefrcInd>();
            this.SuspTabl = new HashSet<SuspTabl>();
            this.Wavepure = new HashSet<Wavepure>();
        }

        public int Bknumber { get; set; }
        public string Authors { get; set; }
        public string Source { get; set; }
        public string Title { get; set; }

        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<AcOpTabl> AcOpTabl { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<ConstSel> ConstSel { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<CuryTabl> CuryTabl { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<DecrTabl> DecrTabl { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<DensTabl> DensTabl { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<DielDiss> DielDiss { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<Dielectr> Dielectr { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<ElemTabl> ElemTabl { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<ElOpTabl> ElOpTabl { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<EquationTabl> EquationTabl { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<EsOpTabl> EsOpTabl { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<HardTabl> HardTabl { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<HeatExpn> HeatExpn { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<HeatTabl> HeatTabl { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<MechTabl> MechTabl { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<MnOpTabl> MnOpTabl { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<ModfTabl> ModfTabl { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<NlOpTabl> NlOpTabl { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<PlavTabl> PlavTabl { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<PzElTabl> PzElTabl { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<RefrcInd> RefrcInd { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<SuspTabl> SuspTabl { get; set; }
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<Wavepure> Wavepure { get; set; }
    }

有很多我不想从我的请求中得到的HashSet。我如何才能改变这种行为?我只需要这个表的值,而不需要其他的表。

请求结果:

代码语言:javascript
复制
{  
   "AcOpTabl":[  ],
   "ConstSel":[  ],
   "CuryTabl":[  ],
   "DecrTabl":[  ],
   "DensTabl":[  ],
   "DielDiss":[  ],
   "Dielectr":[  ],
   "ElemTabl":[  ],
   "ElOpTabl":[  ],
   "EquationTabl":[  ],
   "EsOpTabl":[  ],
   "HardTabl":[  ],
   "HeatExpn":[  ],
   "HeatTabl":[  ],
   "MechTabl":[  ],
   "MnOpTabl":[  ],
   "ModfTabl":[  ],
   "NlOpTabl":[  ],
   "PlavTabl":[  ],
   "PzElTabl":[  ],
   "RefrcInd":[  ],
   "SuspTabl":[  ],
   "Wavepure":[  ],
   "Bknumber":4,
   "Authors":"Niizeki N.,Yamada N.,Toyoda H.",
   "Source":"Jap.J.Appl.Phys.,1967,v.6,N.3,p.318-327",
   "Title":"Growth ridges, etched hillocks and crystal structure of lithium niobate"
}
EN

回答

页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/44354831

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档