LINQ statement with where clause not working correctly

Question

I am trying to create LINQ statement. with where clause like this

  p.Users = db.UserFSMs
      .Where(t => t.UserName.Contains(userORFile.Split('_')[2]))
      .Select(new Models.UsersFSMFinal { Email=t.Email });

But the compiler is not recognizing t. How can I create above query that will work with where?

Just syntax error. You should read about lamba syntax here: https://msdn.microsoft.com/en-us/library/bb397687.aspx — Mauro Sampietro, Aug 30 '16 at 07:08

score 1 · Answer 1 · edited Sep 05 '16 at 13:25

1

you have to declare t=> again with the .Select(t => new

I wrote the same LINQ statement but on my Database and the inserted data will be from a textbox. It worked fine

 var allData = db.Patients
     .Where(t => t.firstName.Contains(TextBox1.Text))
     .Select(t => new
     {
          t.firstName,
          t.lastName
     });

edited Sep 05 '16 at 13:25

t3chb0t

16,340
13
78
118

answered Aug 28 '16 at 09:51

Mai

39
8

I am not inserting into database, I am sending data to view. so I can't send `var` typed to view I need concrete type. – user786 Aug 28 '16 at 10:00
@Alex While this is not the best formulated answer, it's technically correct. Just read the beginning - insert `t =>` in your `Select`. Then you'll get a runtime exception, but that's another story. – Ivan Stoev Aug 28 '16 at 10:17

LINQ statement with where clause not working correctly

1 Answers1