petapoco存储过程

Foo((object)new object[]{ (object)"1", (object)"2" }));
string[] strings = new string[] { "Test1", "Test2", "Test3" };

var myList = new List<KeyValuePair<string, object>>();
Test(myList.ToArray());

db.ExecuteScalar<string>("exec P_GetCode @0,@1,@2,@3,@4,@5",);


using (var db = new Database("test"))
{
SqlParameter[] para = {
new SqlParameter("@m",SqlDbType.NVarChar),
new SqlParameter("@v",SqlDbType.NVarChar),
new SqlParameter("@o",SqlDbType.Int)
};
para[0].SqlValue = m;
para[1].SqlValue = c;
para[2].Direction = ParameterDirection.Output;
db.Execute(" EXEC test @0,@1,@2 OUTPUT", para);
o = int.Parse(para[2].Value.ToString());
}

var list= db.Fetch<student>("EXEC test @id", new { id = "1" });

原文地址:https://www.cnblogs.com/zwei1121/p/5959619.html