CSharp · Console
// @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;}
}
}