CODE EXAMPLE FOR CSHARP

linq get values is not in other table

var list = (from user in db.Users
                where !db.Fi.Any(f => f.UserID == user.UserID)
                select user.UserName).ToList()