Beginning C# 7 Hands-On ??? Advanced Language Features

Book Image

Beginning C# 7 Hands-On ??? Advanced Language Features

By : Tom Owsiak

Book Image

Beginning C# 7 Hands-On ??? Advanced Language Features

By: Tom Owsiak

Overview of this book

Beginning C# 7 Hands-On – Advanced Language Features assumes that you’ve mastered the basic elements of the C# language and that you're now ready to learn the more advanced C# language and syntax, line by line, in a working Visual Studio environment. You'll learn how to code advanced C# language topics including generics, lambda expressions, and anonymous methods. You'll learn to use query syntax to construct queries and deploy queries that perform aggregation functions. Work with C# and SQL Server 2017 to perform complex joins and stored procedures. Explore advanced file access methods, and see how to serialize and deserialize objects – all by writing working lines of code that you can run within Visual Studio. This book is designed for beginner C# developers who have mastered the basics now, and anyone who needs a fast reference to using advanced C# language features in practical coding examples. You'll also take a look at C# through web programming with web forms. By the time you’ve finished this book, you’ll know all the critical advanced elements of the C# language and how to program everything from C# generics to XML, LINQ, and your first full MVC web applications. These are the advanced building blocks that you can then combine to exploit the full power of the C# programming language, line by line.

Title Page

Credits

About the Author

About the Author

www.PacktPub.com

www.PacktPub.com

Customer Feedback

Customer Feedback

Preface

Free Chapter

Creating a Simple Generics Class

Creating a Simple Generics Class

Creating a generics class

Adding a button to Default.aspx

Initializing a collection of integers to their array and displaying the results

Creating a Generic Method

Creating a Generic Method

Creating a button to exchange and then comparing two values

Writing a swap function

Implementing a Generic Interface to Accomplish Sorting

Implementing a Generic Interface to Accomplish Sorting

Adding a button to sort and display results

Creating a generics interface class

Entering the reference code

Making Delegates More Flexible with Generics

Making Delegates More Flexible with Generics

Adding a summarize button to the HTML

Creating and Using Generic Dictionaries

Creating and Using Generic Dictionaries

Adding a show button to the HTML

Starting a process from a web page

Making a directory and creating a file from Command Prompt

Connection Between Delegates and Lambda Expressions

Connection Between Delegates and Lambda Expressions

Adding a Show Results button to the HTML

Adding delegates

Expression-Bodied Lambdas and Expression-Bodied Members

Expression-Bodied Lambdas and Expression-Bodied Members

Adding a box and a Find Max button to the HTML

Making the delegate

Anonymous Methods and Objects That Run Their Own Delegates

Anonymous Methods and Objects That Run Their Own Delegates

Adding a Show Results button to the HTML

Streamlining writing functions

C# with LINQ and Built-In Types

C# with LINQ and Built-In Types

Adding a Show Values button to the HTML

Adding namespaces

C# with LINQ and Custom Data Types

C# with LINQ and Custom Data Types

Adding a Show People button to the HTML

Setting up a database

Using Query Syntax to Construct Queries

Using Query Syntax to Construct Queries

Adding a show button to the HTML

Creating a decimal salary array

Observing deferred execution

Queries That Perform Aggregation Functions

Queries That Perform Aggregation Functions

Adding a show button to the HTML

Creating an array

Using LINQ to Summarize Tuples

Using LINQ to Summarize Tuples

Adding a show tuple summary values button to the HTML

Introducing tuples

Summarizing Results with Grouping

Summarizing Results with Grouping

Adding a Show Results button to the HTML

Adding namespaces

Joining Datasets with Inner Joins

Joining Datasets with Inner Joins

Adding a Join Classes button to the HTML

Adding the namespaces

Downloading, Installing, and Running SQL Server 2017

Downloading, Installing, and Running SQL Server 2017

Downloading SQL Server 2017 express

Working with SQL server inside Visual Studio

Writing Code to Manually Connect to a Table and Retrieve Records

Writing Code to Manually Connect to a Table and Retrieve Records

Adding a show records button to the HTML

Making the connection string

Inserting Records into Tables Using Stored Procedures

Inserting Records into Tables Using Stored Procedures

Adding text boxes and a button to the HTML

Reviewing what you created already in SQL Server

Using the Nullable Feature to Make Apps More Stable

Using the Nullable Feature to Make Apps More Stable

Adding a Show People button to the HTML

Connecting a Chart Control to SQL Server

Connecting a Chart Control to SQL Server

Placing a chart into the HTML page

Adding a new table to the People database

Coding the project

Using LINQ to Operate on Tables from SQL Server

Using LINQ to Operate on Tables from SQL Server

Changing the data in the ExperimentValues table

Creating a Page That Saves Text to Disk

Creating a Page That Saves Text to Disk

Creating an application to save text

Creating a Page That Uses the File Upload Control

Creating a Page That Uses the File Upload Control

Starting our project from scratch

Serializing and Deserializing Objects

Serializing and Deserializing Objects

Adding two buttons to the HTML

Having a Little Fun with Images with Pixel Manipulations

Having a Little Fun with Images with Pixel Manipulations

Manipulating an image

Saving an Image to SQL Server

Saving an Image to SQL Server

Adding buttons and a list box to HTML

Creating and Using an XML File

Creating and Using an XML File

Adding a button to HTML

Creating XML Files with C#

Creating XML Files with C#

Adding a button to HTML

Querying XML Documents with LINQ

Querying XML Documents with LINQ

Adding a text box and a button to HTML

Customer Reviews

5 star

0

4 star

0

3 star

0

2 star

0

1 star

0

Making the connection string

Now, beyond this, we'll go through the construction of the code line-by-line. The first thing that you need is a connection string. So, let's do the following:

Open SQL Server Object Explorer.
Right-click on the name of your database, in this case People, and view its Properties.
Then, to get the connection string, make sure that you expand the node called General within the Properties pane, and then go to the one that says Connection string and double-click on it to select it with its long description.

Next, right-click on the long description and copy it. (It's difficult to construct accurately by hand, so it's better just to copy it from there). This procedure is shown in Figure 17.2.2:

Figure 17.2.2: Copying the connection string

Now, enter the following within the set of curly braces beneath the line that begins with protected void Button1_Click...:

string connString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=People;Integrated Security=True;Connect...