gpt4 book ai didi

c# - LINQ 交叉连接错误

转载 作者:太空宇宙 更新时间:2023-11-03 16:00:26 24 4
gpt4 key购买 nike

我遇到了这个错误

Object of type 'System.Data.Objects.ObjectQuery`1[XXX.Model.Cust_ProfileTbl]' cannot be converted to type 'System.Data.Entity.DbSet`1XXX.Core.Model.Cust_ProfileTbl]'.

当我尝试使用 LINQ CROSS JOIN对这 2 个表进行操作时。谁能建议我该怎么做?

var Cust_ProfileTbl = service.DBContext.Set<Cust_ProfileTbl>();
var Cust_GroupTbl = service.DBContext.Set<Cust_GroupTbl>();

var test =
from cg in Cust_GroupTbl
from c in Cust_ProfileTbl
select new { intCustGroup = cg.intCustGroup, bintAccountNo = c.bintAccountNo };

Cust_ProfileTbl.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
namespace XXXX.Core.Model
{
[Table("Cust_ProfileTbl")]
public partial class Cust_ProfileTbl
{
[Key]
public long bintAccountNo { get; set; }
}
}

Cust_GroupTbl.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
namespace xxxx.Core.Model
{
[Table("Cust_GroupTbl")]
public partial class Cust_GroupTbl
{
[Key]
public int intCustGroup { get; set; }
}
}

最佳答案

var test =
from cg in service.DBContext.Cust_GroupTbls
from c in service.DBContext.Cust_ProfileTbls
select new { intCustGroup = cg.intCustGroup, bintAccountNo = c.bintAccountNo };

关于c# - LINQ 交叉连接错误,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/21696687/

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com