// Solution Code

 using System;

 using System.Collections.Generic;

 using System.Data.SqlClient;

​

 public class Product

 {

  public int ProductId { get; set; }

  public string ProductName { get; set; }

  public decimal UnitPrice { get; set; }

 }

​

 public class ProductRepository

 {

  /// <summary>

  /// Retrieves all products from the "Products" table in the SQL Server database.

  /// </summary>

  /// <param name="connectionString">The connection string used to connect to the SQL Server database.</param>

  /// <returns>A list of Product objects. Returns an empty list if any error occurs during the database operation or if the connection string is invalid.</returns>

  public static List<Product> GetAllProducts(string connectionString)

  {

  if (string.IsNullOrEmpty(connectionString))

  {

  Console.WriteLine("Connection string cannot be null or empty.");

  return new List<Product>();

  }

​

  List<Product> products = new List<Product>();

​

  try

  {

  using (SqlConnection connection = new SqlConnection(connectionString))

  {

  connection.Open();

​

  string query = "SELECT ProductId, ProductName, UnitPrice FROM Products";

  using (SqlCommand command = new SqlCommand(query, connection))

  {

  using (SqlDataReader reader = command.ExecuteReader())

  {

  while (reader.Read())

  {

  Product product = new Product

  {

  ProductId = reader.GetInt32(0),

  ProductName = reader.GetString(1),

  UnitPrice = reader.GetDecimal(2)

  };

  products.Add(product);

  }

  }

  }

  }

  }

  catch (SqlException ex)

  {

  Console.WriteLine($"A SqlException occurred: {ex.Message}");

  return new List<Product>();

  }

  catch (Exception ex)

  {

  Console.WriteLine($"An exception occurred: {ex.Message}");

  return new List<Product>();

  }

​

  return products;

  }

​

  public static void Main(string[] args)

  {

  // Example Usage (Replace with your actual connection string)

  string connectionString = "Server=localhost;Database=YourDatabaseName;User Id=YourUserId;Password=YourPassword;";

​

  List<Product> products = GetAllProducts(connectionString);

​

  if (products.Count > 0)

  {

  Console.WriteLine("Products:");

  foreach (Product product in products)

  {

  Console.WriteLine($"- ProductId: {product.ProductId}, ProductName: {product.ProductName}, UnitPrice: {product.UnitPrice}");

  }

  }

  else

  {

  Console.WriteLine("No products found or an error occurred.");

  }

  }

 }