/C#/C# dapper execute stored procedure with parameters

C# dapper execute stored procedure with parameters

public void GetSomething(int somethingId)
{
    IRepository<Something, SomethingEnum> repository = UnitOfWork.GetRepository<Something, SomethingEnum>();

    var param = new DynamicParameters();
    param.Add("@somethingId", dbType: DbType.Int32, value:somethingId, direction: ParameterDirection.Input);

    var result = repository.Exec<Something>(SomethingEnum.spMyStoredProcedure, param);

    ...

}

Source: dapper-tutorial.net

Similar codes

3 votes328 views1 answer
Unity how to change the text on a button
C#Unity
0 vote306 views1 answer
Hide component in component menu
C#
6 votes314 views4 answers
Add row to datagridview c#
C#
0 vote301 views1 answer
How to make a draggable visual studio panel
C#
0 vote301 views1 answer
Find gameobject by name in root
C#
0 vote301 views1 answer
How to disable vsync in monogame
C#
0 vote298 views1 answer
C# convert list to string and back
C#
2 votes301 views2 answers
Creatw list of int in C#
C#
0 vote299 views1 answer
Most popular products code using asp.net core in visual studio code
C#
0 vote316 views1 answer
C# using rename class
C#