v2/web

Hello Guys,

How do you manage your reports/stats with LLBL?

Do you use stored proc and return a datatable? Do you use TypedList? Or do you use anything else like entitycollection with prefetch or...?

Cheers,

LLBLPowa.

It depends, but since reports are Read-Only data, I always try to use DataTables using Typed Lists or Dynamic Lists (not via Stored procedures).

Depends on the type of report. If it's a detail style report with few transforms I'll use entitycollections or dynamic lists.

If it's a summary report with a lot of aggregates and nested queries and weird joins I'll put it into a typed view or sproc.

Jeff

It also depends on your reporting tools. If you're just writing HTML reports using ASP.NET for instance, you are not hemmed in to a particular style as if you were using Crystal reports or another banded report writer (ActiveReports for instance).