/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 vote319 views1 answer
C# CheckwhethertheStringisapalindromeornot.
C#
0 vote345 views1 answer
Auto select file in Solution Explorer from its open tab
C#
0 vote298 views1 answer
Unable to resolve service for type 'microsoft.aspnetcore.identity.rolemanager`1
C#
0 vote289 views1 answer
Unity time.fixeddeltatime
C#
0 vote335 views1 answer
Unity hide mouse first person
C#
0 vote335 views1 answer
.net core check if linux
C#
10 votes290 views3 answers
How to make a quit button in unity
C#
49 votes350 views8 answers
C# hello world
C#
0 vote320 views2 answers
Generate random light colors programatically in android
C#
39 votes324 views6 answers
Steam top wishlist
C#