ExecuteSprocAccessor how to return string from stored procedure?

Question

I am using Enterprise Library 5, set up the Database successfully but am now facing the following problem.

I have a stored procedure which is a simple select statement which returns 1 string (not an output parameter).

In code I wrote:

var result = _db.ExecuteSprocAccessor<string>("GetTypeOfPerson", mapper, parameters);

However this won't work as string does not have a parameterless constructor. Any way around? Or how can I call with Enterprise Library the stored procedure and obtain my result?

Answer 1

Hi,

that indeed won't work out. Do the following instead:

var result = _db.ExecuteScalar("GetTypeOfPerson", parameters);

That'll give you exactly one result back.