SPBP.Core 1.0.0.8

Create DBAgent
DbAgent agent = new DbAgent(connectionstring);

Create Procedure object : DataSItem itm = new DataSItem {

         Schema = "dbo", //schema name 
         Name = "Images_NewINstance"
     };

Equip procedure with parameter : itm.AddParam(new DataParam("@path", CustomSqlTypes.String));

If the procedure returns some data you can set it as a parameter : itm.AddReturnParam(CustomSqlTypes.Int);

Equip param with value : itm.Params["@path"].Value = newimagepath ;

Execute procedure : ExecAsyncResult res = await itm.ExecuteNonQueryAsync(agent); //or ExecResult res = itm.ExecuteNonQuery(agent);

Create DBAgent : DbAgent agent = new DbAgent(connectionstring);

Create Procedure object : DataSItem itm = new DataSItem {

         Schema = "auto", //schema name 
         Name = "Models_Get" // procedure name 
     };

Equip procedure with params if needed and execute : DataSet ds = new DataSet(); //sync version

     ExecResult res =  _selectedProcedure.ExecDataSet(agent, out ds);

     //async version 

     ExecAsyncResult resas =  await _selectedProcedure.ExecDataSetAsync(agent);
    ds = resas.Object as DataSet; 

Create DBAgent : DbAgent agent = new DbAgent(connectionstring);

Create Procedure object : DataSItem itm = new DataSItem { Schema = "general", //schema name Name = "Images_Get" // procedure name };

Create object class that will be received : [DbObject] public class Img { [ColumnName()] public int Id { get; set; }

 [ColumnName]
 public string Path { get; set; }

}

Equip procedure with params if needed and execute : itm.AddReturnParam(CustomSqlTypes.Int); // procedure has return value as int IBag<Img> images ; //executeion async ExecAsyncResult res = await itm.ExecuteDataReaderByRefAsync<Img>(agent); images = res.Object as IBag<Img>;

//sync version ExecResult rs = itm.ExecuteDataReaderByRef<Img>(agent, out images);