Guest User

Untitled

a guest
Jan 21st, 2019
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. public SearchTable(int var1, int var2, int var3)
  2.  
  3. var results = entities.vw_ToSearch.Where(x => x.var1 == var1 && x.var2 == var2 && x.var3 == var3);
  4.  
  5. IQueryable<vw_ToSearchItem> results = entities.vw_ToSearch;
  6. if (x.var1.HasValue)
  7. results = results.Where(x => x.var1 == var1);
  8. if (x.var2.HasValue)
  9. results = results.Where(x => x.var2 == var2);
  10. if (x.var3.HasValue)
  11. results = results.Where(x => x.var3 == var3);
  12.  
  13. Where( x => x.var1==var1 &&
  14. (var2 == null || x.var2 == var2))
Add Comment
Please, Sign In to add comment