/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

24 votes184 views2 answers
How to destroy an object in unity
C#Unity
1 vote156 views1 answer
Linq query select where c#
C#
0 vote266 views1 answer
How to get file type from base64 in c#
C#
3 votes194 views1 answer
Specified key was too long; max key length is 1000 bytes (SQL: alter table `permissions` add unique `permissions name guard_name_unique`(`name`, `guard_name`))
C#
0 vote165 views1 answer
Keyboard Hook c#
C#
0 vote187 views1 answer
Thread.Sleep() without freezing the UI
C#
3 votes161 views1 answer
How to get the transform of an object in unity
C#
7 votes172 views2 answers
C# count specific words in string
C#
0 vote162 views1 answer
How to make continuous progress bar
C#
0 vote165 views1 answer
.net core Enable-Migrations' is not recognized as the name of a cmdlet
C#