In this chapter, we are going to look into ways to leverage the built-in programmable features of SQL Server that allow for maximum performance and efficiency.
We’ve already seen that we can easily create tables in a code-first approach with Entity Framework. However, in real-world applications, we are going to need to start building out more robust database solutions. By the end of this chapter, we will have a working understanding of what it takes to leverage database objects like stored procedures, views, and functions. We’ll also know how to set up our code and migrations ...
