/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

2 votes300 views1 answer
Unity rotate around pivot c#
C#Unity
0 vote258 views1 answer
Find ip domain linux
C#
0 vote277 views1 answer
Dapper Get List
C#
0 vote293 views1 answer
Set data annotation in model c#
C#
0 vote264 views1 answer
More than one migrations configuration type was found in the assembly 'EFCodeFirst'. Specify the name of the one to use
C#
2 votes253 views1 answer
Remove a specific line in richtextbox c#
C#
45 votes345 views6 answers
Unity C# random number
C#Unity
0 vote332 views1 answer
C# check control type
C#
0 vote284 views1 answer
Npm install --save vue-route@n
C#
0 vote280 views1 answer
Print arraylist values to console unity
C#