Is there a way for each column in a grid to determine which table or entity they belongs to using llblgen DAL? I have an updatable view made up from many tables and would like to know the base table of each column. I want to know it programatically as I want to come up with generic code to populate grid and then determine the base tables for each column.

I know that I can use View Information schema but I want to find out through llblgen DAL?

Any help will be appreciated.

Is this view a TypedView, TypedList, or a View mapped on entity? LLBLGen version and TemplateSet (Adapter/SelfServicing) ? (http://llblgen.com/TinyForum/Messages.aspx?ThreadID=7725)?

It is a View mapped on entity, since the requirement is to have the capability to edit columns in grid. Since it a database view, i can check the schema to determine the tables used for each column but I want same sort of deal from llblgen DAL not from Database.

Please see this thread

and this one which even has the code to do it

Matt

Since the grid is based on a view(consisting of multiple tables), if I use entity.fields(0).GetObjectSourceName (selfServicing) it gives me name of the view. But, the requirement is to find the underlying table for that column.

Is there a way where we can determine for a given view these columns comes from these tables?

Hi there... I think that is not possible. Remember that the parent of a view's field is not necessarily a table. It could be another view, a subquery, the result of a calculated field, the result of an expression, etc. So I doubt this information is available on the Database drivers to O/R world.

Indeed, that meta-information is not available and also not retrievable from the database meta-data unless the SQL of the view is parsed which is very hard to do (read: VERY hard to do) and can be impossible if the view's sql is encrypted.

Thanks for your help