/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 vote210 views2 answers
Asp net identity login failed for user
C#
0 vote200 views1 answer
C# todatatable nullable
C#
-1 vote166 views1 answer
Instantiate date time variable C#
C#
0 vote203 views1 answer
C# validate xml
C#
0 vote138 views1 answer
C# sharepoint get users from column
C#
4 votes220 views1 answer
Unity cast int to float
C#Unity
1 vote176 views1 answer
C# how to refreshyour bindingsource
C#
0 vote165 views1 answer
C# scrape html document
C#
-1 vote173 views1 answer
How to check if a number is prime or not c#
C#
0 vote290 views1 answer
Unity get perlin noise 3d
C#Unity