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

## What are the databases?
**Databases**  store collections of information in an organized way that can easily be added, deleted, and updated.


## How to connect a database with C#
In the following example, a local ```SQL``` database is created to demonstrate **CRUD (Create, Read, Update, Delete)** in a database.

### Step 1: Create the project
In the first step, we create a .NET Console Application. In the following, we're using `Program.cs` as our project.

### Step 2: Verify the Entity Frameworks
In the second step, we verify that the Entity Framework is installed. We require the following three Entity Frameworks:

1. `Microsoft.EntityFrameworkCore
2` `Microsoft.EntityFrameworkCore.Tools`
3. `Microsoft.EntityFrameworkCore.SQLServer`

These frameworks can be installed using the following commands from CLI:
```Terminal
dotnet add package Microsoft.EntityFrameworkCore
dotnet add package Microsoft.EntityFrameworkCore.Tools
dotnet add package Microsoft.EntityFrameworkCore.SQLServer
```

### Step 3: Set up the `Student` class
In the next step, We create a folder named `People` to store and set up the model. In the created folder, we create a `Student.cs` file and add the following code into it.
```C#
namespace People
{
    public class Student
    {
        public int Id { get; set; } 
        public string Name { get; set; } 
        public int Grade { get; set; }
    }
}
```

### Step 4: Set up the database context
In this step, we create an additional folder called `Data` for the project and a class in the `Data` folder called `StudentDBContext`. This class manages the connection to the database. The class, `StudentDBContext`, needs to inherit from the `Entity Framework` class, `DBContext`.

- Update the class to `class StudentDBContext : DbContext`.
- To use `DBContext`, add `using Microsoft.EntityFrameworkCore;` to the top of the page.
-  To handle the information from the `Student` class model previously created, the `DbSet` is used `public DbSet <Student> Students { get; set; }`.
- An additional `using` statement, `using People;`, is also added to access the `Student` class.
- A connection string is added to connect to the database.

The final code of the `StudentDBContext.cs` should look like the following:
```C#
using Microsoft.EntityFrameworkCore;
using People;

namespace Data
{
    internal class StudentDBContext : DbContext
    {
        public DbSet<Student> Students { get; set; }
        // Connect to database
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseSqlServer(@"Server=localhost; Database=StudentDatabase; User Id=sa; Password=Educative@123;");
        } 
    }
}
```
### Step 5: Use `migrations` for the database
In this step, we use `migrations` to create the database. The purpose of migration is to keep the database in sync with the models.

We use the following CLI commands to create a migration:
```Terminal
dotnet ef migrations add InitialMigration
```

After pressing "Enter", notice that a new folder called `Migrations` was added to the project. This folder contains the schema and other information the database needs.

The database isn't created yet; the following command creates the database.
```Terminal
dotnet ef database update
```

If these commands execute without any error, the database has been created and we can communicate with the database. 

# What are the databases?
**Databases**  store collections of information in an organized way that can easily be added, deleted, and updated.


# How to connect a database with C#
In the following example, a local ```SQL``` database is created to demonstrate **CRUD (Create, Read, Update, Delete)** in a database.

## Step 1: Create the project
In the first step, we create a .NET Console Application. In the following, we're using `Program.cs` as our project.

## Step 2: Verify the Entity Frameworks
In the second step, we verify that the Entity Framework is installed. We require the following three Entity Frameworks:

1. `Microsoft.EntityFrameworkCore
2` `Microsoft.EntityFrameworkCore.Tools`
3. `Microsoft.EntityFrameworkCore.SQLServer`

These frameworks can be installed using the following commands from CLI:
```Terminal
dotnet add package Microsoft.EntityFrameworkCore
dotnet add package Microsoft.EntityFrameworkCore.Tools
dotnet add package Microsoft.EntityFrameworkCore.SQLServer
```

## Step 3: Set up the `Student` class
In the next step, We create a folder named `People` to store and set up the model. In the created folder, we create a `Student.cs` file and add the following code into it.
```C#
namespace People
{
    public class Student
    {
        public int Id { get; set; } 
        public string Name { get; set; } 
        public int Grade { get; set; }
    }
}
```

## Step 4: Set up the database context
In this step, we create an additional folder called `Data` for the project and a class in the `Data` folder called `StudentDBContext`. This class manages the connection to the database. The class, `StudentDBContext`, needs to inherit from the `Entity Framework` class, `DBContext`.

- Update the class to `class StudentDBContext : DbContext`.
- To use `DBContext`, add `using Microsoft.EntityFrameworkCore;` to the top of the page.
-  To handle the information from the `Student` class model previously created, the `DbSet` is used `public DbSet <Student> Students { get; set; }`.
- An additional `using` statement, `using People;`, is also added to access the `Student` class.
- A connection string is added to connect to the database.

The final code of the `StudentDBContext.cs` should look like the following:
```C#
using Microsoft.EntityFrameworkCore;
using People;

namespace Data
{
    internal class StudentDBContext : DbContext
    {
        public DbSet<Student> Students { get; set; }
        // Connect to database
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseSqlServer(@"Server=localhost; Database=StudentDatabase; User Id=sa; Password=Educative@123;");
        } 
    }
}
```
## Step 5: Use `migrations` for the database
In this step, we use `migrations` to create the database. The purpose of migration is to keep the database in sync with the models.

We use the following CLI commands to create a migration:
```Terminal
dotnet ef migrations add InitialMigration
```

After pressing "Enter", notice that a new folder called `Migrations` was added to the project. This folder contains the schema and other information the database needs.

The database isn't created yet; the following command creates the database.
```Terminal
dotnet ef database update
```

If these commands execute without any error, the database has been created and we can communicate with the database. 

Introduction

C# Basics

Operators

Decisional Statements

Loops (Iterative Statements)

Arrays

Methods

Classes

Data Structures

Delegates and Events

Miscellaneous Topics

Concurrency

LINQ and Databases

Appendix

Database: Connectivity

What are the databases?

How to connect a database with C#

Step 1: Create the project

Step 2: Verify the Entity Frameworks