/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 vote167 views1 answer
C# attribute
C#
1 vote150 views1 answer
Unity how to end a game with esc
C#
1 vote178 views1 answer
Decalre an int list mvc
C#
2 votes171 views1 answer
Unity 2d how to set an object or the mouse position
C#
5 votes155 views2 answers
How to make c# open brower
C#
1 vote215 views1 answer
Debug raycasthit2d unity
C#Unity
0 vote146 views1 answer
C# get total milliseconds from datetime
C#
2 votes137 views1 answer
Core Request.CreateResponse
C#
0 vote145 views1 answer
C# xml check if attribute exists
C#
0 vote135 views1 answer
Int to binary string with 4 characters
C#