/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

19 votes159 views2 answers
Unity change text
C#Unity
106 votes313 views6 answers
C# get random integer
C#
1 vote132 views2 answers
How to set layout margin programmatically in android
C#
4 votes123 views1 answer
Minimize button c#
C#
0 vote143 views1 answer
Print out a dictionary c#
C#
14 votes122 views2 answers
How to do cmd command c#
C#
0 vote204 views1 answer
Unity ignore collision between two objects
C#Unity
0 vote126 views1 answer
Swagger skip endpoint .net core
C#
0 vote137 views4 answers
Read csv file into wpf C#
C#
0 vote132 views1 answer
Aspx receive variable from url
C#