Dapper - Query Strongly Typed (NET Core)

CSharp · Console

/Program.cs

// Dapper Plus
// Doc: https://dapper-tutorial.net/query

// @nuget: Dapper -Version 1.60.6

using Dapper;
using System;
using System.Data.SqlClient;
using System.Linq;
					
public class Program
{
	public class OrderDetail
	{
		public int OrderDetailID { get; set; }
		public int OrderID { get; set; }
		public int ProductID { get; set; }
		public int Quantity { get; set; }
	}
	
	public static void Main()
	{
		string sql = "SELECT TOP 10 * FROM OrderDetails";

		using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
		{			
			var orderDetails = connection.Query<OrderDetail>(sql).ToList();

    		Console.WriteLine(orderDetails.Count);
						
			FiddleHelper.WriteTable(orderDetails);
		}
	}
}
;