Gain insights into C# 10 and .NET, learn programming basics, delve into OOP, explore data structures, and discover how to build and deploy native applications effectively.

Programming Fundamentals- Getting Started with C_ and .NET.png

csharp_sql.tar.gz

CSharp-Run-SPA

CSharp-Run-code

CSharp-Test-SPA

SPA - Database

C# is one of the most popular programming languages in the world, and its latest stable version, C# 10, has several new features and updates that make it an excellent choice for a wide variety of applications. Combined with the .NET framework, C# can empower developers to build native applications for all the major consumer operating systems as well as the cloud.

The course starts with an introduction to programming concepts such as conditional statements, loops, arrays, and functions. You’ll explore advanced topics of object-oriented programming (OOP) including classes, inheritance, access, and extensions. Finally, you’ll work with data structures, events, concurrency, testing, and databases.

By the end of this course, you’ll have a working knowledge of not only the C# programming language, but also key ideas of software engineering. You’ll also be prepared to build and deploy native applications with the .NET framework.

Programming Fundamentals: Getting Started with C# and .NET

**Databases** store collections of information in an organized way that can easily be added, deleted, and updated. In the following example, a local SQL database is created to demonstrate CRUD (Create, Read, Update, Delete) in a database.


**Step 1:** Create a .NET console application in Visual Studio and name it  `StudentDB`.

**Step 2:** Verify that Entity Framework is installed. Right-click on the project, `StudentDB`, and select “Manage NuGet Packages.” Click the “Browse” tab.

- Browse for `Microsoft.EntityFrameworkCore` and install it if it’s not installed.

- Browse for `Microsoft.EntityFrameworkCore.Tools` and install it if it’s not installed.

- Browse for `Microsoft.EntityFrameworkCore.SQLServer` and install it if it’s not installed.


**Step 3:** Create a folder to store and set the model up by doing the following.

- Right-click on the project, `StudentDB`, and select “Add” and then“New Folder.” Name it `People`.
- Right-click on the `People` folder and add a class called `Student`.

Let's learn how the SQL Server connects with Visual Studio 2022.


Connecting with the SQL Server in Visual Studio

Let's learn how the SQL Server connects with Visual Studio 2022.

Introduction

C# Basics

Operators

Decisional Statements

Loops (Iterative Statements)

Arrays

Methods

Classes

Data Structures

Delegates and Events

Miscellaneous Topics

Concurrency

LINQ and Databases

Appendix

Connecting with the SQL Server in Visual Studio