/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 vote362 views1 answer
Unity quit in edtor
C#Unity
0 vote364 views1 answer
How to authorize token when consuming api in c#
C#
0 vote326 views1 answer
Embed video to exe file with c#
C#
0 vote347 views1 answer
Httpcontext.current.session null c# in class library
C#
4 votes310 views1 answer
Unity round float to nearest 10
C#
0 vote310 views1 answer
Dotcms contentidentifier
C#
0 vote383 views1 answer
Button color uwp c#
C#
0 vote322 views1 answer
Set margin programmatically wpf c#
C#
-2 votes347 views4 answers
C# datagridview selected row index
C#
0 vote297 views1 answer
Unity repeat coroutine
C#