Book Image

C# 6 and .NET Core 1.0

Book Image

C# 6 and .NET Core 1.0

Overview of this book

With the release of .NET Core 1.0, you can now create applications for Mac OS X and Linux, as well as Windows, using the development tools you know and love. C# 6 and .NET Core 1.0 has been divided into three high-impact sections to help start putting these new features to work. First, we'll run you through the basics of C#, as well as object-orient programming, before taking a quick tour through the latest features of C# 6 such as string interpolation for easier variable value output, exception filtering, and how to perform static class imports. We'll also cover both the full-feature, mature .NET Framework and the new, cross-platform .NET Core. After quickly taking you through C# and how .NET works, we'll dive into the internals of the .NET class libraries, covering topics such as performance, monitoring, debugging, internationalization, serialization, and encryption. We'll look at Entity Framework Core 1.0 and how to develop Code-First entity data models, as well as how to use LINQ to query and manipulate that data. The final section will demonstrate the major types of applications that you can build and deploy cross-device and cross-platform. In this section, we'll cover Universal Windows Platform (UWP) apps, web applications, and web services. Lastly, we'll help you build a complete application that can be hosted on all of today's most popular platforms, including Linux and Docker. By the end of the book, you'll be armed with all the knowledge you need to build modern, cross-platform applications using C# and .NET Core.
Table of Contents (25 chapters)
C# 6 and .NET Core 1.0
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Relational Database Management Systems


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 MySQL.

Connecting to Microsoft SQL Server LocalDb

Microsoft offers various editions of its SQL Server product. We will use a free version that can run standalone and is known as LocalDb. The latest version of LocalDb is installed as part of Visual Studio 2015.

When you write code to connect to a database, you need to know its server name. The name depends on the version you choose to use. Here are some examples:

  • 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

The Northwind sample database

To learn how to manage a database, 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...