How connect to MS Sql Server using c#

How connect to MS Sql Server using c#

string connectionString = "data source=[ip or server name];initial catalog=[database_name];persist security info=True;user id=[sql_server_user_id];password=[password];MultipleActiveResultSets=False;TrustServerCertificate=true;";

SqlConnection connection = new SqlConnection(connectionString);

connection.Open();

var query = "select * from books";
var books = connection.query<Book>(query);

connection.Close();

I have used dapper in this post to get record easily

You can easily install dapper from nuget using nuget package manger

Install-Package Dapper

Here is lin to dapper in nuget online

https://www.nuget.org/packages/Dapper