Advertisement
Guest User

Untitled

a guest
Apr 10th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. Users
  2. (
  3. varchar UserName,
  4. varchar Password,
  5. binary Permitions
  6. )
  7.  
  8. User{string UserName, string Password, Permition Permitions: {...}}
  9.  
  10. db.Query<User>("Select UserName, Password, Permisions PermitionsFromTable
  11. from Users WHERE UserName=@User AND Password =@Password", new { user,
  12. password
  13. }, user =>
  14. {
  15. user.Permitions = new Permition();
  16. user.Permitions.LoadPermitions("PermitionsFromTable");
  17. return user ;
  18. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement