Advertisement
Guest User

Untitled

a guest
Jan 22nd, 2017
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. SELECT * FROM Table WHERE (FirstName = '' OR FirstName = @FirstName) AND (LastName = '' OR LastName = @LastName
  2.  
  3. var sql = "SELECT * FROM Table WHERE 1 = 1 /* Just to not care about if the where clause is needed */";
  4.  
  5. if (!String.IsNullOrWhiteSpace(FirstName))
  6. {
  7. sql += " AND FirstName = @FirstName ";
  8. }
  9.  
  10. if (!String.IsNullOrWhiteSpace(LastName))
  11. {
  12. sql += " AND LastName= @LastName";
  13. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement