/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

2 votes136 views1 answer
How to edit Camera.size property unity
C#
0 vote141 views1 answer
Print text c# unity
C#
1 vote151 views1 answer
Unity ui get the canvas
C#
2 votes199 views1 answer
Unity player look at mouse
C#Unity
1 vote204 views1 answer
Unity check if a animator parameter trigger is activated
C#Unity
1 vote143 views1 answer
How to get object to spawn in a curcle
C#
1 vote155 views1 answer
C# restart app
C#
78 votes197 views1 answer
Iphone
C#
0 vote137 views1 answer
Use different database with entitymanagerfactory
C#
0 vote167 views1 answer
Godot Duplicate 'global::System.Runtime.Versioning.TargetFrameworkAttribute'
C#