Abstract DataAccessor example

[emre....@gmail.com]

Hi,

I'm trying two different ways to use DataAccessor :

public class PositionAccessor1 : DataAccessor<Position>
{
public PositionAccessor1(DbManager dbManager) :
base(dbManager) { }
public List<Position> GetPosition(string positionCode)
{
return DbManager.SetSpCommand("pkg_test.test",
DbManager.Parameter("arg1", positionCode),

DbManager.Parameter(System.Data.ParameterDirection.Output, "cur1",
null))
.ExecuteList<Position>();
}
}

public abstract class PositionAccessor2 : DataAccessor<Position>
{
[SprocName("pkg_test.test")]
public abstract List<Position>
GetPosition([Direction.InputOutput("arg1")]string positionCode,
[Direction.InputOutput("cur1")] object result);
}

I test PositionAccessor as :

var db = new BLToolkit.Data.DbManager("App1");

//this works
var pos1 = new PositionAccessor1(db).GetPosition("23889");

//this fails,
var pos2 =
DataAccessor.CreateInstance<PositionAccessor2>(db).GetPosition("23889",
null);

For abstract version, I can't define the OutPut refcursor via
Direction attribute.

Any ideas?

[jaso...@gmail.com]

Hi,

Did you find a solution for this?

Thanks,
Jason