/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 vote277 views2 answers
C# aspx return image
C#
0 vote263 views1 answer
Button commandfield commandargument pass textbox
C#
2 votes245 views1 answer
C# constructor call another constructor
C#
0 vote260 views1 answer
Clock in wpf
C#
3 votes268 views1 answer
Linq include
C#
0 vote258 views1 answer
C# milisecond to h m s
C#
23 votes273 views3 answers
C# write to console
C#
0 vote247 views2 answers
C# type from string
C#
0 vote218 views0 answer
C#
-3 votes278 views2 answers
Gmail
C#