https://docs.microsoft.com/en-us/dotnet/core/tutorials/with-visual-studio-code
Extensions I use, C# is the one to install now.
Prerequisites
Visual Studio Code with the C# extension installed. For information about how to install extensions on Visual Studio Code, see VS Code Extension Marketplace.
The .NET 5.0 SDK or later
Yea…
The folder name becomes the project name and the namespace name by default. You’ll add code later in the tutorial that assumes the project namespace is HelloWorld.
Terminal
dotnet new console
Run the app
Run the following command in the Terminal:
Enhance the app
Open Program.cs by clicking on it.
The first time you open a C# file in Visual Studio Code, OmniSharp loads in the editor.
Select Yes when Visual Studio Code prompts you to add the missing assets to build and debug your app.
After you have done some changes, In Visual Studio Code, you have to explicitly save changes. Unlike Visual Studio, file changes are not automatically saved when you build and run an app.
Great, we done some changes, not lets add a separate class in a different folder.
Classes and Objects:
https://www.tutlane.com/tutorial/csharp/csharp-classes-and-objects-with-examples
So here we created a new class and made two instances of it, the field W_id and Name we can get, the property Location we can set and get.
Some more refresh on dotnet, arry, arraylist (using systems.collections), hashtable (dictionary) and the cool goto with for and foreach st.
using System;
using System.Collections;
namespace HelloWorld
{
// class name
class Worker
{
// fields
public int W_id;
public string Name;
// constructor
public Worker(string name)
{
Random rnd = new Random();
W_id = rnd.Next(1, 5555);
Name = name;
work();
}
public void work()
{
Console.WriteLine("loops");
for (int i = 0; i < 3; i++)
{
Console.WriteLine(i);
}
for (int i = 0, j = 1; i < 3; i++, j++)
{
Console.WriteLine(i + " " + j);
}
string[] names = new string[3];
names[0] = "Dimmu B";
names[1] = "Gorgoroth";
names[2] = "Trelldom";
for (int i = 0; i < names.Length; i++)
{
Console.WriteLine(names[i]);
}
ArrayList arr = new ArrayList();
arr.Add(45);
arr.Add(55);
foreach (int aa in arr)
{
Console.WriteLine(aa);
}
Hashtable ht = new Hashtable();
ht.Add("Jones", "Tom");
ht.Add("Oneil", "Jane");
ht.Add("Boris", "Petro");
foreach (DictionaryEntry item in ht)
{
Console.WriteLine(item.Key + " " + item.Value);
if (item.Value.ToString() == "Petro")
{
goto removeit;
}
}
removeit:
Console.WriteLine("Can safefully remove it");
}
// method
public void getDetails()
{
Console.WriteLine(Name + " " + W_id + " " + Location);
}
// properties
public string Location { get; set; }
}
}
Add a package
Go to terminal and type
dotnet add package System.Data.SqlClient
using System.Data.SqlClient;
public void listDatabases()
{
try
{
using (SqlConnection sqlCon = new SqlConnection(connectionString))
{
string q = "SELECT name, database_id FROM sys.databases";
SqlCommand command = new SqlCommand(q, sqlCon);
command.Connection.Open();
command.ExecuteNonQuery();
SqlDataReader sqlReader = command.ExecuteReader();
while(sqlReader.Read()) {
string name = sqlReader["name"].ToString();
string id = sqlReader["database_id"].ToString();
Console.WriteLine(name + " " + id);
}
}
}
catch (SqlException e)
{
Console.WriteLine(e);
}
}
Debug a .NET console application using Visual Studio Code