Two C# linq queries convert to vb.net

Question

Hi guys,
have some C# linq and would like to convert it to vb.net linq. Can you help?

  

  var currentUserId = 25;  
    var prjectId = 10;  
    
    var projects= db.tbProjekt.Where(s => s.tbUserProjects
                                           .Any(x => x.UserId == currentUserId)).ToList();
    
    
    var projectIds = db.tbUserProjects
                        .Where(s => s.UserId == currentUserId && s.ProjectId == idPojektu)
                        .Select(x => x.ProjectId).ToList();

in first case i tried:

  

   var currentUserId = 25;  
                    ProjectsPerUser = db.tbProjekt.Where(Function(s) s.tbUserProjects.Any(Function(x) x.UserId = currentUserId )).ToList()

 

but i got error:

`"Late binding operationscannot be converted toexpression tree"` on line  s.tbUserProjects.Any

Answer 1

Hi johnyyy,

I reproduced you code snippet and made a demo, it worked fine. Below is my demo for you
reference.

Dim db As New DemoEntities
Dim productId = 1
Dim suplies= (db.Suppliers.Where(Function(s) s.Products.Any(Function(x) x.Id = productId))).ToList()
Console.WriteLine(suplies.Count)
Console.ReadKey()

Hope it is helpful to you.

Best regards,

Answer 2

that's exactly how i did and i amr eceiving error :

Late binding operationscannot be converted toexpression tree"` on line  s.tbUserProjects.Any

Answer 3

Hi johnyyy,

The problem maybe is that you are trying to use strongly typed. Try to modify code snippet as below.

Dim currentUserId = 25

Dim perUser = db.tbProjekt.Where(Function(s) s.tbUserProjects.Any(Function(x) x.UserId = currentUserId)).ToList()

Best regards,