/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 vote105 views1 answer
Linq c# where condition
C#
0 vote115 views1 answer
Isselected uicollectionview reused
C#
1 vote117 views1 answer
How to instatiate particles in unity
C#
0 vote110 views2 answers
Datetime month name
C#
0 vote116 views1 answer
Reflection static method c#
C#
2 votes110 views1 answer
Vue.createApp is not a function
C#
0 vote111 views2 answers
How to use file watcher in c#
C#
4 votes140 views1 answer
How to write coroutine in unity
C#Unity
4 votes124 views2 answers
Wpf label text in center
C#
0 vote177 views1 answer
List of function in c#
C#