static void Main(string[] args)
        {
            try
            {
                string connString = "Server=localhost;Database=TestDb;User Id=user;Password=Password;TrustServerCertificate=True;";

                using(var con = new SqlConnection(connString))
                {
                    con.Open();

                    using (var cmd = con.CreateCommand())
                    {
                        cmd.CommandText = "select count(*) from [dbo].[AspNetUsers]";
                        using(var reader = cmd.ExecuteReader())
                        {
                           while (reader.Read())
                           {
                               Console.WriteLine(reader[0].ToString());
                           }
                        }
                    }
                }    
            }
            catch(Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }

            Console.ReadLine();
        }