void test1() { var cnnstr = "Data Source=server\\I2k14,61129;Initial Catalog=TASSBase;User ID=admin;Password=adm321(;Connect Timeout=3"; using (var con = new SqlConnection(cnnstr)) { using (var cmd = new SqlCommand("usp1_ApiClient_GetByKey", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@result", SqlDbType.VarChar, 50)); cmd.Parameters.Add(new SqlParameter("@args", SqlDbType.NVarChar, 1000)); cmd.Parameters.AddWithValue("@execMode", 0); cmd.Parameters.Add(new SqlParameter("@ClientKey", SqlDbType.UniqueIdentifier)); cmd.Parameters[0].Direction = ParameterDirection.Output; cmd.Parameters[1].Direction = ParameterDirection.Output; cmd.Parameters[3].Value = new System.Data.SqlTypes.SqlGuid("F9FA3F42-7568-4FDC-AF12-A88994997596"); con.Open(); var reader = cmd.ExecuteReader(); var c = new Locust.Modules.Api.Model.ApiClient.Full(); while (reader.Read()) { c.Read(reader); } con.Close(); Console.WriteLine(c.ToJson()); } } }
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); } }