Hello,
Using LLBL v5.3 latest, SQL Server 2016, adapter.
We use TypedView that are mapped to stored procedure. i wish it was as easy as retrieving DataTable. When you have tons of TypedView the current method is not much desired.
Can you consider making is more simple?
Current Method
public List<MvListItemRow> GetListItem(string category, int officeId)
{
var rv = new List<MvListItemRow>();
using (var adapter = DataAccessHelper.GetAdapter())
{
rv= RetrievalProcedures.FetchMvListItemTypedView(adapter, new QueryFactory().GetMvListItemTypedViewProjection(),category,officeId);
adapter.CloseConnection();
}
return rv;
}
Preferred Method, something like this
public List<MvListItemRow> GetListItem(string category, int officeId)
{
var rv = new List<MvListItemRow>();
using (var adapter = DataAccessHelper.GetAdapter())
{
rv = RetrievalProcedures.FetchTypedView(category, officeId,adapter);
adapter.CloseConnection();
}
return rv;
}