C# List

class Program
	{
		//configuration untuk baca file dari json
		private static IConfigurationRoot Configuration;

		//configuration / koneksi ke sqlserver
		private static DbContextOptionsBuilder<NorthwindContext> optionsBuilder; 


		static void Main(string[] args)
		{
			BuildConfiguration();
			Console.WriteLine($"ConnectionString : {Configuration.GetConnectionString("NorthwindDS")}");
			BuildOptions();
			ListCustomer();

        }

		static void BuildConfiguration()
		{
			var builder = new ConfigurationBuilder()
				.SetBasePath(Directory.GetCurrentDirectory())
				.AddJsonFile("appsettings.json", optional:true, reloadOnChange:true);
			Configuration = builder.Build();
		}

		static void BuildOptions()
		{
			optionsBuilder = new DbContextOptionsBuilder<NorthwindContext>();
			optionsBuilder.UseSqlServer(Configuration.GetConnectionString("NorthwindDS"));
		}

		static void ListCustomer()
		{
			using (var db = new NorthwindContext(optionsBuilder.Options))
			{
				var customers = db.Customers.OrderByDescending(x => x.CompanyName).Take(10).ToList();
				foreach (var cust in customers)
				{
					Console.WriteLine($"{cust.CompanyName} {cust.ContactName}");
				}
			}
		}

	}