c#-ref vs out, dependency injection, pagination in linq, take vs skip in linq, endpoint, view bag vs view data, eager loading, constructor, event, authentication, get vs post, ajax sql- union vs union all, rank, optimization,