linq like empty string

Question

var list = (from i in _dataContext.aspnet_Users.Include("aspnet_Membership")  where i.UserName.Contains(userName)  select i ).ToList();

if userName="" then nothing return. how can i do that if empty string then return all records?

Please clarify, I don't have a clue what you're asking. - Edit - on second thought, I think I've got it. — Ian P
– Ian P, Commented Apr 19, 2010 at 21:15

Nix · Accepted Answer · 2010-04-19 21:16:21Z

7

Do:

  var list = 
      (from i in _dataContext.aspnet_Users.Include("aspnet_Membership") 
        where string.IsNullOrEmpty(userName)
               || i.UserName.Contains(userName)  
       select i ).ToList();

answered Apr 19, 2010 at 21:16

Nix

58.8k31 gold badges154 silver badges206 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

rossisdead · Accepted Answer · 2010-04-19 21:24:05Z

2

Fun Fact: The System.Data.Linq.SqlClient namespace includes a few helper methods that are pretty useful.

You can use the SqlMethods.Like function which will return all results if an empty string is passed to it.

Ex:

 (from i in _dataContext.aspnet_Users.Include("aspnet_Membership") 
  where SqlMethods.Like(i.UserName, "%" + userName + "%")
  select i).ToList();

answered Apr 19, 2010 at 21:24

rossisdead

2,1161 gold badge19 silver badges30 bronze badges

1 Comment

rossisdead Over a year ago

Nix: You're right, I assumed too quickly. Fun fact still stands though ;)

Collectives™ on Stack Overflow

linq like empty string

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related