Stored procedure: some DB-side logic that can perform something and return (retrieval SP's) or not-return (actions SP's results) data. If you have Stored Procedures you can use them at your code, you even could use projections and fill entity objects with your SP call.
TypedView: if you have some DB views, you can map them to your LLBLGen model. Then you can fetch them at your code easily.
TypedList: you want to make a typed view based on your entity fields at designer. This is helpful because you can use entity fields to reference the results or filter the results.
DynamicList: you want to construct a view at your own code, make some filter, grouping, aliasing and use your already generated entity fields and entity relations. This is very flexible and you can do almost everything there.
Ref:
- LLBLGenPro Help - Using the generated code - (Adapter || SelfServicing) - Using TypedViews, TypedLists and DynamicLists
- LLBLGenPro Help - Using the generated code - (Adapter || SelfServicing) - Calling a stored procedure
