- 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
Microsoft offers various editions of its SQL Server product. We will use a free version that can run stand-alone, known as LocalDb. The latest version of LocalDb is installed as part of Visual Studio 2017.
When you write code to connect to a SQL Server database, you need to know its server name. The name depends on the version you choose to use. Here are some examples:
- Visual Studio 2017 installs SQL Server 2016:
(localdb)mssqllocaldb - Visual Studio 2015 installs SQL Server 2014:
(localdb)mssqllocaldb - Visual Studio 2012/2013 installs SQL Server 2012:
(localdb)v11.0 - If you install SQL Server Express:
.sqlexpress
In Visual Studio 2017, go to File | Open | File... or press Ctrl + O .
Browse to select the Northwind.sql file and choose Open.
In the editor window, right-click and choose Execute... or press Ctrl + Shift + E.
In the dialog box, enter the server name as (localdb)mssqllocaldb and click on Connect, as shown in the following screenshot:
When you see the Command(s) completed successfully message, then the Northwind database has been created, and we can connect to it.
In Visual Studio 2017, choose View | Server Explorer... or press Ctrl + W, L.
In the Server Explorer window, right-click on Data Connections and choose Add Connection...
If you see the Choose Data Source dialog, as shown in the following screenshot, then select Microsoft SQL Server and click on Continue:
In the Add Connection dialog box, enter the server name as (localdb)mssqllocaldb, enter the database name as Northwind, and click on OK, as shown in the following screenshot:
In the Server Explorer window, expand the data connection and its tables. You should see a dozen tables, including the Products table, as shown in the following screenshot:
Right-click on the Products table and choose Show Table Data, as shown in the following screenshot:
To see the details of the Products table columns and types, right-click on Products and choose Show Table Definition, as shown in the following screenshot:
-
No Comment