QuerySingleOrDefault Anonymous (NET Core)

CSharp · Console

/Program.cs

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

// @nuget: Dapper -Version 1.60.6

using Dapper;
using System;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
					
public class Program
{
	public static void Main()
	{
		string sql = "SELECT * FROM OrderDetails WHERE OrderDetailID = @OrderDetailID;";

		using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
		{
			var orderDetail = connection.QuerySingleOrDefault(sql, new {OrderDetailID = 1});

    		FiddleHelper.WriteTable(orderDetail);
		}
	}
}