This chapter discusses several advanced configuration features that interact directly with your SQL database, such as using SQL user-defined functions (UDFs) and computed columns. These features allow you to move some of your calculations or settings into the SQL database. Although you won’t use these features every day, they can be useful in specific circumstances.
The second half of this chapter is about handling multiple, near-simultaneous updates of the same piece of data in the database; these updates can cause problems known as concurrency conflicts. You’ll learn how to configure one property/ column or a whole entity/table to catch concurrency conflicts, as well as how to capture and then write code to correct the concurrency conflict.