book

The C# Workshop

Name: The C# Workshop
ISBN: 9781800566491

by Jason Hales, Almantas Karpavicius, Mateus Viegas

September 2022

Beginner

780 pages

14h 43m

English

Packt Publishing

Read now

Unlock full access

The C# Workshop
Preface
About the BookAudienceAbout the AuthorsAbout the ChaptersConventionsBlock of CodeEmphasisTechnical TermsAdded InformationTruncationBefore You BeginInstalling VS CodeMoving Between Chapters in VS CodeInstalling the .NET Developer PlatformThe .NET 6.0 Features Found in Windows, macOS, and LinuxWindowsmacOSLinuxDocker.NET Command-Line Interface (CLI)PostgreSQL Installation for WindowsPostgreSQL Installation for macOSExploring pgAdmin DashboardPostgreSQL Installation on UbuntuAccessing the postgres User Account with the postgres RoleVerifying the postgres User Account as a postgres User RoleAccessing a New User and DatabaseDownloading the Code
1. Hello C#
IntroductionRunning and Developing C# with the .NET CLICreating Programs with the CLI and VS CodeBasic Anatomy of a C# ProgramExercise 1.01: Creating a Console App that Says "Hello World"Top-Level StatementsDeclaring VariablesDeclaring Variables ExplicitlyDeclaring Variables ImplicitlyExplicit versus Implicit DeclarationExercise 1.02: Assigning Variables to User InputsData TypesStringsExercise 1.03: Checking String ImmutabilityComparing StringsNumeric TypesExercise 1.04: Using the Basic Arithmetic OperatorsClassesDatesExercise 1.05: Using Date ArithmeticFormatting DatesLogical Operators and Boolean ExpressionsUsing if-else StatementsExercise 1.06: Branching with if-elseThe Ternary OperatorReference and Value TypesExercise 1.07: Grasping Value and Reference Equality Default Value TypesEnhancing Decision Making with the switch StatementExercise 1.08: Using switch to Order FoodIteration StatementswhileExercise 1.09: Checking Whether a Number is Prime with a while LoopJump Statementsdo-whileArraysfor LoopsExercise 1.10: Ordering an Array Using Bubble Sortforeach StatementsFile HandlingFileAccessFileModeExercise 1.11: Reading Content from Text FilesDisposable ObjectsExercise 1.12: Writing to a Text FileExceptionsExercise 1.13: Handling Invalid User Inputs with try/catchActivity 1.01: Creating a Guessing GameSummary
2. Building Quality Object-Oriented Code
IntroductionClasses and ObjectsConstructorsFields and Class MembersExercise 2.01: Creating Classes and ObjectsReference TypesPropertiesObject InitializationComparing Functions and MethodsAn Effective ClassExercise 2.02: Comparing the Area Occupied by Different ShapesThe Four Pillars of OOPEncapsulationInheritancePolymorphismWhat is the Benefit of Polymorphism?AbstractionInterfacesExercise 2.03: Covering Floor in the BackyardSOLID Principles in OOPSingle Responsibility PrincipleOpen-Closed PrincipleLiskov SubstitutionInterface SegregationDependency InversionHow C# Helps with Object-Oriented DesignStaticSealedPartialVirtualInternalConditional OperatorsTernary OperatorsOverloading OperatorsNullable Primitive TypesGenericsEnumExtension MethodsStructRecordInit-Only SettersValueTuple and DeconstructionExercise 2.04: Creating a Composable Temperature Unit ConverterActivity 2.01: Merging Two CirclesSummary
3. Delegates, Events, and Lambdas
IntroductionDelegatesDefining a Custom DelegateExercise 3.01: Defining and Invoking Custom DelegatesThe Inbuilt Action and Func DelegatesAssigning DelegatesInvoking a DelegateExercise 3.02: Assigning and Invoking DelegatesMulticast DelegatesExercise 3.03: Invoking a Multicast DelegateMulticasting with a Func DelegateWhat Happens When Things Go Wrong?Exercise 3.04: Ensuring All Target Methods Are Invoked in a Multicast DelegateEventsDefining an EventExercise 3.05: Publishing and Subscribing to EventsEvents or Delegates?Static Events Can Cause Memory LeaksLambda ExpressionsExercise 3.06: Using a Statement Lambda to Reverse Words in a SentenceCaptures and ClosuresActivity 3.01: Creating a Web File DownloaderSummary
4. Data Structures and LINQ
IntroductionData StructuresListsExercise 4.01: Maintaining Order within a ListQueuesStacksHashSetsDictionariesExercise 4.02: Using a Dictionary to Count the Words in a SentenceLINQQuery OperatorsQuery ExpressionsDeferred ExecutionStandard Query OperatorsProjection OperationsSelectAnonymous TypesSelectManyFiltering OperationsSorting OperationsOrderBy and OrderByDescendingThenBy and ThenByDescendingExercise 4.03: Filtering a List of Countries by Continent and Sorting by AreaPartitioning OperationsGrouping OperationsExercise 4.04: Finding the Most Commonly Used Words in a BookAggregation OperationsQuantifier OperationsJoin OperationsUsing a let Clause in Query ExpressionsActivity 4.01: Treasury Flight Data AnalysisSummary
5. Concurrency: Multithreading Parallel and Async Code
IntroductionRunning Asynchronous Code Using TasksCreating a New TaskUsing Task.Factory.StartNewUsing Task.RunExercise 5.01: Using Tasks to Perform Multiple Slow-Running CalculationsCoordinating TasksWaiting for Tasks to CompleteExercise 5.02: Waiting for Multiple Tasks to Complete Within a Time PeriodContinuation TasksUsing Task.WhenAll and Task.WhenAny with Multiple TasksExercise 5.03: Waiting for All Tasks to CompleteAsynchronous ProgrammingAsync Lambda ExpressionsCanceling TasksExercise 5.04: Canceling Long-Running TasksException Handling in Async/Await CodeExercise 5.05: Handling Async ExceptionsThe AggregateException ClassIAsyncEnumerable StreamsParallel ProgrammingData ParallelismTask ParallelismThe Parallel ClassParallel.For and Parallel.ForEachActivity 5.01: Creating Images from a Fibonacci SequenceSummary
6. Entity Framework with SQL Server
IntroductionCreating a Demo Database Before You StartModeling Databases Using EFConnection String and SecurityWhich One to Choose—EF or EF Core?ModelDbContext and DbSetAdventureWorks DatabaseExercise 6.01: Reading Stock Locations from AdventureWorks DatabaseQuerying a Database—LINQ to SQLQuery SyntaxThe Rest of CRUDExercise 6.02: Updating Products and Manufacturers TableDatabase FirstRevisiting DbContextGenerating DbContext from an Existing DatabaseCode First and MigrationsExercise 6.03: Managing Product Price ChangesPitfalls of EFExamples SetupMultiple AddsEquals over ==Using IEnumerable over IQueryableLazy over Eager LoadingRead-Only QueriesSummary of ResultsTools to Help You Spot Problems Early OnWorking with a Database in EnterpriseRepository PatternExercise 6.04: Creating a Generic RepositoryTesting Data Persistence Logic LocallyIn-Memory Database ProviderSQLite Database ProviderA Few Words on RepositoryQuery and Command Handlers PatternsSeparating the Database Model from the Business Logic (Domain) ModelActivity 6.01: Tracking System for Trucks DispatchedSummary
7. Creating Modern Web Applications with ASP.NET
IntroductionAnatomy of an ASP.NET Web AppProgram.cs and the WebApplicationMiddlewaresLoggingDependency InjectionExercise 7.01: Creating Custom Logging MiddlewareDependency LifetimesRazor PagesBasic Razor SyntaxFile StructureExercise 7.02: Creating a Kanban Board with RazorPageModelThe Life Cycle with Page HandlersRendering Reusable Static Code with Tag HelpersExercise 7.03: Creating Reusable Components with Tag HelpersModel BindingExercise 7.04: Creating a New Page to Submit TasksValidationDynamic Behavior with Partial PagesExercise 7.05: Refactoring a Tag Helper to a Partial Page with Custom LogicActivity 7.01: Creating a Page to Edit an Existing TaskView ComponentsExercise 7.06: Creating a View Component to Display Task StatisticsActivity 7.02: Writing a View Component to Display Task LogSummary
8. Creating and Using Web API Clients
IntroductionBrowserWeb APIRESTful APIPostmanClientOctokitAPI KeyAzure Text AnalyticsExercise 8.01: Performing Sentimental Text Analysis on Any TextYour Own ClientHttpClientHttpClient and IDisposableOAuthReal-life AnalogyAPI AnalogyOAuth App for GitHubAuthorization HeaderBasic AuthenticationAPI Key and Personal Access TokenThird-Party Authentication—OAuth2Request IdempotencyPUT, PATCH, or POSTExercise 8.02: HttpClient Calling a Star Wars Web APIActivity 8.01: Reusing HttpClient for the Rapid Creation of API ClientsRestSharpActivity 8.02: The Countries API Using RestSharp to List all CountriesRefitActivity 8.03: The Countries API Using Refit to List all CountriesOther Ways of Making HTTP RequestsExercise 8.03: A Strongly Typed HTTP Client for Testing Payments in a PayPal SandboxActivity 8.04: Using an Azure Blob Storage Client to Upload and Download FilesSummary

9. Creating API Services
IntroductionASP.NET Core Web APICreating a New ProjectWeb API Project StructureAn In-Depth Look at WeatherForecastControllerResponding with Different Status CodesExercise 9.01: .NET Core Current Time ServiceBootstrapping a Web APIDependency InjectionProgram.cs and Minimal APIThe Inner Workings of the AddLogging MethodThe Lifetime of an Injected ComponentDI Examples within a ServiceSingletonScopedTransientTryAddManual Injection Using an IoC ContainerExercise 9.02: Displaying Current Time in a Country API Time ZoneOpenAPI and SwaggerUsing Swagger SwashbuckleError HandlingRequest ValidationConfigurationDevelopment Environments and ConfigurationBootstrappingCalling Another APIRapidAPIService ClientDTO and Mapping Using AutoMapperHttpClient DIExercise 9.03: Performing File Operations by Calling Azure Blob StorageSecuring a Web APIAzure Active DirectoryJWTOpenID ConnectApplication RegistrationImplementing Web API SecurityToken Generator AppConfiguring Swagger AuthTroubleshooting Token Validation ErrorsService-Oriented ArchitectureMicroservice ArchitectureActivity 9.01: Implementing the File Upload Service Using Microservice ArchitectureAzure FunctionsSummary
Hey!

Content preview from The C# Workshop

6. Entity Framework with SQL Server

Overview

This chapter introduces you to the basics of database design, storage, and processing using SQL and C#. You will learn about the Entity Framework (EF), and Object-Relational Mapper (ORM) and use them to convert database results into C# objects. You will then learn about the main performance pitfalls of SQL and EF and how to find and fix them.

Finally, you will delve into enterprise practices of working with databases by looking at Repository and Command Query Responsibility Segregation (CQRS) patterns and also by setting up a local database for development and testing. By the end of this chapter, you will be able to create and design your own database using PostgreSQL Server and use EF to hook ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9781800566491

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

The C# Workshop

by Jason Hales, Almantas Karpavicius, Mateus Viegas

6. Entity Framework with SQL Server

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.