Dapper-Results

CSharp · Console

/Program.cs

// @nuget: Dapper -Version 1.60.6

using Dapper;
using System;
using System.Data.SqlClient;
using System.Linq;
					
public class Program
{
	
	public static void Main()
	{
		string sqlOrderDetails = "SELECT TOP 10 * FROM OrderDetails;";

		using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
		{
			var anonymousList = connection.Query(sqlOrderDetails).ToList();
			var orderDetails = connection.Query<OrderDetail>(sqlOrderDetails).ToList();
			
			Console.WriteLine(anonymousList.Count);
			Console.WriteLine(orderDetails.Count);
			
			FiddleHelper.WriteTable(orderDetails);
				
			FiddleHelper.WriteTable(connection.Query(sqlOrderDetails).FirstOrDefault());
		}
		 
        
	}
	
	public class OrderDetail
	{
		public string Name {get; set;}
		public int OrderDetailID {get; set;}
		public int OrderID {get; set;}
		public int ProductID {get; set;}
		public int Quantity {get; set;}
	}

}
		
	
;