I'm trying to integrate Oracle stored procedure which returns a ref cursor
and map to my model.
Below is the sample code that I'm using.
public class TasksMap : ClassMap<Tasks>
{
public TasksMap()
{
StoredProcedure("My_Proc", "");
Id(x => x.Id);
Map(x => x.TaskType);
Map(x => x.CustId);
Map(x => x.CreateDate);
}
}
return await _session.GetNamedQuery("My_Proc ")
.SetResultTransformer(Transformers.AliasToBean(typeof(Tasks)))
.SetParameter("in_custid", custId)
.ListAsync<Tasks>();
I'm using a ref cursor in the oracle procedure to return the records. Can
someone share a sample working code?
--
You received this message because you are subscribed to the Google Groups
"Fluent NHibernate" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/fluent-nhibernate/ad0263ab-2653-4ef3-98a9-1cf910cc3fff%40googlegroups.com.