Unit test tests single unit of code without communicating with the external dependencies i.e. file system, network or database.
Connection resiliency is used to describe a scenario where some resource becomes unavailable for short period of time, if we try to connect that resource like SQL Server during that time our connection should not throw exception instead it should retry.
Lazy loading should typically be disabled for web applications, since its use will result in additional database queries being made within each web request.
In web applications, it’s recommended to use the async/await pattern with the async methods, so that web server threads are not blocked while waiting for data access operations to complete.