C#查询转换为vb.net
本文关键字:vb net 转换 查询 | 更新日期: 2023-09-27 18:27:18
我有一些C#LINQ代码,想把它转换成vb.net。你能帮忙吗?将项目每个用户分为新列表(属于tbProjekt)var currentUserId=25
var prjectId=10;
ProjectsPerUser = db.tbProjekt.Where(s => s.tbUserProjects
.Any(x => x.UserId == currentUserId)).ToList();
在第一种情况下,我尝试了:
Dim ProjectsPerUser As New List(Of tbProjekt)
var currentUserId = 25;
ProjectsPerUser = db.tbProjekt.Where(Function(s) s.tbUserProjects.Any(Function(x) x.UserId = currentUserId )).ToList()
但是,我得到了这个错误:
后期绑定操作无法转换为表达式树
在线CCD_ 1上。
完整代码:(上下文中的表格:tbProjekt和tbUserProjects)
Dim dabcon As New production_TextEntitesContext
Dim ProjectsPerUsers As New List(Of tbProjekt)
Dim userSessionId As Integer = 111
ProjectsPerUsers = dabcon.tbProjekt.Where(Function(s) s.tbUserProjects.Any(Function(x) x.UserId = userSessionId)).ToList()
应该只是一个问题:
ProjectsPerUser = db.tbProjekt.Where(Function(s) s.tbUserProjects.Any(Function(x) x.UserId = currentUserId)).ToList()