/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

6 votes232 views2 answers
C# float to string with 2 decimals
C#
1 vote218 views1 answer
How to concate in c#
C#
0 vote225 views1 answer
Wpf c# select folder path
C#
1 vote233 views1 answer
How to delete multiple file by datagridview in c#
C#
0 vote209 views1 answer
How to cut image from timeline editor in c#
C#
0 vote202 views2 answers
How to convert list of string to single string in c#
C#
0 vote199 views1 answer
Defining vectors in c#
C#
0 vote202 views1 answer
C# property attribute
C#
0 vote210 views1 answer
Detect mouse in bottom of screen + unity
C#
0 vote194 views1 answer
C# external ip
C#