/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

9 votes325 views3 answers
Unity how to create 2d object from script
C#Unity
0 vote191 views1 answer
How to use javascriptexecutor for loop in selenium c#
C#
2 votes197 views3 answers
C# generic type converter
C#
0 vote272 views1 answer
Unity repeat coroutine
C#Unity
34 votes223 views3 answers
Setactive unity
C#
1 vote237 views1 answer
Unity get scrollbar value
C#Unity
0 vote181 views1 answer
C# listview as listbox
C#
1 vote177 views1 answer
C# write text before user input
C#
0 vote203 views1 answer
C# Change color
C#
0 vote214 views1 answer
Asp.net throw unauthorized exception
C#