QuerySingle Strongly Typed (NET Core)

CSharp · Console

/Program.cs

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

// @nuget: Dapper -Version 1.60.6

using Dapper;
using System;
using System.Collections.Generic;
using System.Data;
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 * FROM OrderDetails WHERE OrderDetailID = @OrderDetailID;";

		using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
		{			
			var orderDetail = connection.QuerySingle<OrderDetail>(sql, new {OrderDetailID = 1});

			FiddleHelper.WriteTable(new List<OrderDetail>() { orderDetail });
		}
	}
}
;