Chapter 5. Working with relational databases
This chapter covers
- Accessing databases with .NET Standard System.Data classes
- Using the SQLite in-memory database
- Transforming data between objects and tables
- Unit testing data-access code
Widget Corporation needs to keep better track of their supply chain, so they hire you to transform their paper-based process into software. You find that each part used in the manufacturing process comes from a different supplier, and that Widget Corp. is having trouble ordering the right supplies at the right time.
To solve this problem, you decide to use a relational database. The database will persist data, making it resilient to shutdown or power failure. It will enforce relationships between data, so ...
Get .NET Core in Action now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
