- C# 7 and .NET Core: Modern Cross-Platform Development - Second Edition
- C# 7 and .NET Core: Modern Cross-Platform Development - Second Edition
- Credits
- About the Author
- About the Reviewer
- www.PacktPub.com
- Customer Feedback
- Preface
- 1. Hello, C#! Welcome, .NET Core!
- Choosing your development environment
- Installing Microsoft Visual Studio 2017 for Windows
- Installing Microsoft Visual Studio Code for Windows, macOS, or Linux
- Understanding .NET
- Writing and compiling code using the .NET Core CLI tool
- Writing and compiling code using Microsoft Visual Studio 2017
- Writing and compiling code using Microsoft Visual Studio Code
- Managing source code with GitHub
- Practicing and exploring
- Summary
- 2. Speaking C#
- Understanding C# basics
- Declaring variables
- Building console applications
- Operating on variables
- Practicing and exploring
- Summary
- 3. Controlling the Flow, Converting Types, and Handling Exceptions
- 4. Using .NET Standard Types
- Using assemblies and namespaces
- Storing and manipulating text
- Storing data with collections
- Internationalizing an application
- Practicing and exploring
- Summary
- 5. Debugging, Monitoring, and Testing
- 6. Building Your Own Types with Object-Oriented Programming
- Talking about OOP
- Building class libraries
- Storing data with fields
- Writing and calling methods
- Controlling how parameters are passed
- Splitting classes using partial
- Controlling access with properties and indexers
- Practicing and exploring
- Summary
- 7. Implementing Interfaces and Inheriting Classes
- Setting up a class library and console application
- Simplifying methods with operators
- Defining local functions
- Raising and handling events
- Implementing interfaces
- Managing memory with reference and value types
- Inheriting from classes
- Casting within inheritance hierarchies
- Inheriting and extending .NET types
- Practice and explore
- Summary
- 8. Working with Databases Using the Entity Framework Core
- 9. Querying and Manipulating Data with LINQ
- 10. Working with Files, Streams, and Serialization
- 11. Protecting Your Data
- 12. Improving Performance and Scalability with Multitasking
- 13. Building Universal Windows Platform Apps Using XAML
- 14. Building Web Applications Using ASP.NET Core MVC
- Understanding ASP.NET Core
- Exploring an ASP.NET Core MVC web application
- ASP.NET Core MVC controllers
- ASP.NET Core MVC models
- ASP.NET Core MVC views
- Taking ASP.NET Core MVC further
- Practicing and exploring
- Summary
- 15. Building Mobile Apps Using Xamarin.Forms and ASP.NET Core Web API
- Understanding Xamarin.Forms
- Building services using ASP.NET Core Web API and Visual Studio Code
- Building mobile apps using Xamarin.Forms and Visual Studio for Mac
- Creating a Xamarin.Forms project
- Creating a model
- Creating an interface for dialing phone numbers and implement for iOS and Android
- Creating views for the customers list and customer details
- Test the mobile app with iOS
- Adding NuGet packages for calling a REST service
- Getting customers from the service
- Practicing and exploring
- Summary
- 16. Packaging and Deploying Your Code Cross-Platform
- A. Answers to the Test Your Knowledge Questions
- Chapter 1 - Hello, C#! Welcome, .NET Core!
- Chapter 2 - Speaking C#
- Chapter 3 - Controlling the Flow, Converting Types, and Handling Exceptions
- Chapter 4 - Using .NET Standard Types
- Chapter 5 - Debugging, Monitoring, and Testing
- Chapter 6 - Building Your Own Types with Object-Oriented Programming
- Chapter 7 - Implementing Interfaces and Inheriting Classes
- Chapter 8 - Working with Databases Using Entity Framework Core
- Chapter 9 - Querying and Manipulating Data with LINQ
- Chapter 10 - Working with Files, Streams, and Serialization
- Chapter 11 - Protecting Your Data
- Chapter 12 - Improving Performance and Scalability with Multitasking
- Chapter 13 - Building Universal Windows Platform Apps Using XAML
- Chapter 14 - Building Web Applications Using ASP.NET Core MVC
- Chapter 15 - Building Mobile Apps Using Xamarin.Forms and ASP.NET Core Web API
- Chapter 16 - Packaging and Deploying Your Code Cross-Platform
This chapter is about reading and writing to databases, such as Microsoft SQL Server and SQLite, using the object-relational mapping technology known as the Entity Framework Core.
This chapter will cover the following topics:
- Relational Database Management Systems
- Using Microsoft SQL Server on Windows
- Using SQLite on macOS and mobile platforms
- Setting up Entity Framework Core
- Querying an EF Core model
- Manipulating data with EF Core
One of the most common places to store data is in a Relational Database Management System (RDBMS). Common ones include Microsoft SQL Server, Oracle, and SQLite.
To learn how to manage a database using .NET Core, it would be useful to have a sample one to practice on that has a medium complexity and a decent amount of sample records. Microsoft offers several sample databases, most of which are too complex for our needs. So, we will use a database that was first created in the early 1990s known as Northwind.
Use the link https://github.com/markjprice/cs7dotnetcore/tree/master/VSCode/Chapter08 to download the Northwind.sql file for use with Microsoft SQL Server on Windows, or the NorthwindSQLite.sql file for use with SQLite on macOS or mobile platforms.
Here is a diagram of the Northwind database that you can refer to as we write queries:
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.