Do you think your life is harder only because you have to execute some stored procedures?
So Neat.Procedure is for you.
A stored procedure executer in a neat way.
Why don't you call like this?
object oneScalarReturn = ProcedureExecuter.ExecuteScalar("YourSPName");
or like this?
int count = ProcedureExecuter.ExecuteNonQuery("YourSPName");
or even like this?
IEnumerable<YourDomainClass> list = ProcedureExecuter.ExecuteReader<YourDomainClass>("YourSPName");
No mapping between classes and stored procedures results.
Just that. Simple, fast and Neat.
Duh... Aren't you forgetting stored procedure parameters?
Sure. You can pass it like arguments or like a key/value Dictionary<string, object>.
string arg1 = "arg1";
int arg2 = 2;
bool arg3 = true;
DateTime arg4 = DateTime.Now;
ProcedureExecuter.ExecuteNonQuery("YourSPName", arg1, arg2, arg3, arg4);
or
Dictionary<string, object> parameters = new Dictionary<string, object>()
{
{ "arg1", "arg1" },
{ "arg2", 2 },
{ "arg3", true },
{ "arg4", DateTime.Now }
};
ProcedureExecuter.ExecuteNonQuery("YourSPName", parameters);
By default, connectionStringName is Neat.Procedure.Settings.ConnectionString.Default
But can be changed by
Connection.ConnectionStringName("YourConnectionStringNameHere");
or
Connection.ConnectionString("server=(local)\SQLEXPRESS;database=DBName;Integrated Security=SSPI");
You can install it via NuGet
Install-Package Neat.Procedure