/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 vote197 views1 answer
How to create empty text file in c#
C#
1 vote239 views1 answer
Toggle unity c#
C#Unity
3 votes188 views1 answer
To list c#
C#
8 votes206 views1 answer
Get all child gameObject of gameObject C#
C#
0 vote202 views1 answer
Set data annotation text in model c#
C#
7 votes225 views2 answers
How to make a character move in unity 3d
C#Unity
1 vote255 views1 answer
Unity 2d joystick controls
C#Unity
1 vote177 views1 answer
C# get bits from float
C#
31 votes262 views5 answers
String to json c#
C#
0 vote184 views7 answers
Python to php converter online
C#