public override void Test() { var guid = Guid.NewGuid(); var _args = new { p1 = CommandParameter.Guid(guid), p2 = CommandParameter.Output(SqlDbType.UniqueIdentifier) }; var dbr = DA.DefaultDb.ExecuteNonQuery("ust_test1", _args); if (dbr.Success) { var s = SafeClrConvert.ToString(_args.p2.Value); System.Console.WriteLine("p2: " + s); } else { System.Console.WriteLine(dbr.Exception.Message); } }
void test2() { var args = new Dictionary <string, object>(); args.Add("Result", CommandParameter.Output(SqlDbType.VarChar, 50)); args.Add("Args", CommandParameter.Output(SqlDbType.NVarChar, 1000)); args.Add("execMode", 0); args.Add("ClientKey", CommandParameter.Guid("F9FA3F42-7568-4FDC-AF12-A88994997596")); //(args["ClientKey"] as GuidCommandParameter).Value = "F9FA3F42-7568-4FDC-AF12-A88994997596"; var dbr = DA.DefaultDb.ExecuteSingle("usp1_ApiClient_GetByKey", (IDataReader reader) => { var result = new Locust.Modules.Api.Model.ApiClient.Full(); result.Read(reader); return(result); }, args); if (dbr.Success) { switch (dbr.MessageType) { case MessageType.SingleSuccess: //Console.WriteLine(dbr.Data.ClientKey); //Console.WriteLine(JsonConvert.SerializeObject(dbr.Data)); Console.WriteLine(dbr.Data.ToJson()); break; case MessageType.SingleNotFound: Console.WriteLine("Not found"); break; } } else { Console.WriteLine("Error: {0}", dbr.Exception.Message); } }