/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

0 vote259 views1 answer
C# max in 2d array row
C#
0 vote245 views1 answer
Freeze time unity 2d script
C#Unity
0 vote249 views1 answer
Base64 bit string to pdf c#
C#
0 vote229 views1 answer
C# 2 timespan return yesterday
C#
8 votes232 views2 answers
C# add object to array
C#
24 votes232 views7 answers
Qwertyuiopasdfghjklzxcvbnm
C#
0 vote278 views1 answer
Username and password into base64 encoding c#
C#
2 votes238 views1 answer
Winforms messagebox with button
C#
0 vote243 views2 answers
Reflection get enum value C#
C#
3 votes268 views2 answers
C# inline array initialization
C#