/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

1 vote123 views1 answer
C# delete folder with all contents
C#
0 vote123 views1 answer
Elasticsearch nested aggregation in c#
C#
2 votes124 views1 answer
Format float to time c#
C#
19 votes128 views3 answers
C# string array to string
C#
0 vote127 views1 answer
C# load button image from resource
C#
0 vote128 views1 answer
Query into complex object using dapper
C#
34 votes138 views2 answers
Open scene unity
C#
0 vote123 views2 answers
C# is file closed
C#
11 votes138 views1 answer
C# How to write Hello World
C#
0 vote125 views1 answer
Is odd c# stackoverflow
C#