/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

1 vote197 views1 answer
Unity nested list
C#Unity
1 vote135 views1 answer
Is c# hard to learn
C#
0 vote162 views1 answer
Store Images In SQL Server Using EF Core And ASP.NET Core
C#
6 votes102 views1 answer
Movement slowly towards target unity
C#
0 vote133 views1 answer
Unity ar object occlusion
C#
3 votes148 views1 answer
Unity c# on trigger enter with specific gameobject
C#
0 vote143 views1 answer
Catwherehouse
C#
12 votes148 views2 answers
How to get ip address in c#
C#
2 votes146 views3 answers
C# http post request with file
C#
9 votes137 views2 answers
Index in foreach in c#
C#