스토어드 프로시저 호출(with Dapper)

DB연결부터 쿼리 날리는 예

using(var connection = new SqlConnection(connectionString))
{
    //Set up DynamicParameters object to pass parameters  
    DynamicParameters parameters = new DynamicParameters();   
    parameters.Add("id", 1);  
	
    //Execute stored procedure and map the returned result to a Customer object  
    var customer = conn.QuerySingleOrDefault<Customer>("GetCustomerById", parameters, commandType: CommandType.StoredProcedure);
}

 

스토어드 프로시저 예

var storedProcedureName = "GetSalesByYear";
var values = new { BeginningDate = "2017-01-01", EndingDate = "2017-12-31" };
var results = connection.Query(storedProcedureName, values, commandType: CommandType.StoredProcedure).ToList();
results.ForEach(r => Console.WriteLine($"{r.OrderID} {r.Subtotal}"));

 

[출처]

https://www.learndapper.com/stored-procedures - 스토어드 프로시저

https://www.learndapper.com/dapper-query - 쿼리 방법