Lesson1 ---＞ Ado.net Demo for SQLServer

Nuget

add package for sql connection.

Demo Code

create a table named user

-- auto-generated definition
create table [user]
(
    id     int identity
        primary key,
    name nvarchar(50)
)
go

simple select demo

using System.Data.SqlClient;

Console.WriteLine("Hello, World!");

var sqlConnection = new SqlConnection("Server=.;uid=sa;pwd=root234;database=dotnet_test;");
sqlConnection.Open();
Console.WriteLine(sqlConnection.State);
Console.WriteLine(sqlConnection.ServerVersion);

SqlCommand sqlCommand = new();
sqlCommand.CommandText = "select * from [user]";
sqlCommand.Connection = sqlConnection;
var sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
    Console.WriteLine($"ID: {sqlDataReader[0]}, name: {sqlDataReader[1]}");
}

sqlConnection.Close();