/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 vote306 views1 answer
C# and Arrow Keys
C#
0 vote293 views1 answer
Parsing object from text file c#
C#
1 vote293 views1 answer
UnityEngine.Transform.get_position () (at <a0ef933b1aa54b668801ea864e4204fe>:0) Gamekit3D.MeleeWeapon.BeginAttack (System.Boolean thowingAttack)
C#
0 vote322 views1 answer
Length of arr c#
C#
0 vote291 views1 answer
How to check for file lock?
C#
1 vote308 views2 answers
Sort datatable c#
C#
-11 votes297 views9 answers
çeviri
C#
2 votes276 views7 answers
Covid
C#
4 votes307 views2 answers
Foreach c# linq example
C#
-1 vote288 views1 answer
Join two tables in linq c#inner join
C#