连接两个表实体框架
本文关键字:实体 框架 两个 连接 | 更新日期: 2023-09-27 18:08:01
我正在尝试使用LINQ在实体框架中连接两个表
模型如下:
public partial class PredbiljezbeEF
{
public int idPredbiljezba { get; set; }
public Nullable<System.DateTime> datumPredbiljezba { get; set; }
public string imePolaznik { get; set; }
public string prezimePolaznik { get; set; }
public string gradPolaznik { get; set; }
public string adresaPolaznik { get; set; }
public Nullable<int> postanskiBrojPolaznik { get; set; }
public Nullable<bool> statusPredbiljezba { get; set; }
public int idSeminar { get; set; }
public virtual SeminariEF SeminariEF { get; set; }
}
public partial class SeminariEF
{
public SeminariEF()
{
this.PredbiljezbeEFs = new HashSet<PredbiljezbeEF>();
}
public int idSeminar { get; set; }
public string nazivSeminar { get; set; }
public string opisSeminar { get; set; }
public string datumSeminar { get; set; }
public Nullable<bool> statusSeminar { get; set; }
public Nullable<int> brojPredbiljezbi { get; set; }
下面是LINQ表达式:
if(!IsPostBack)
{
SeminariEntities db = new SeminariEntities();
var predB = (from x in db.PredbiljezbeEFs
join y in db.SeminariEFs on x.idSeminar equals y.idSeminar
select new
{
id = x.idPredbiljezba,
ime = x.imePolaznik,
prez = x.prezimePolaznik,
datum = x.datumPredbiljezba,
grad = x.gradPolaznik,
adresa = x.adresaPolaznik,
post = x.postanskiBrojPolaznik,
status = x.statusPredbiljezba,
naziv = y.nazivSeminar,
datumS = y.datumSeminar
}).ToList();
//var predB = (from x in db.PredbiljezbeEFs select x).ToList();
gvPredbiljezbe.DataSource = predB.ToList();
gvPredbiljezbe.DataBind();
}
我得到这个错误:
DataBinding: '<>f__AnonymousType0
10[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.Nullable
1[[System.]DateTime, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]], mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System. DateTime],String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System. net]。String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System. net]。可空1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]], mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.Nullable
1[[系统。Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]], mscorlib, Version=4.0.0.0, Culture=n…'不包含名称为'idPredbiljezba'的属性。
谁来帮帮我。
从例外message => something
(数据网格可能是?)正试图从您的gvPredbiljezbe
dataSource
访问名称[idPredbiljezba]
属性,但查询最终投影不包含您项目属性[idPredbiljezba]
作为[id]
的属性
希望能有所帮助