We just purchased LLBLGen, so still a bit rusty getting it all figured out - so far we love it. We have one issue that is plinking us in the head, however.

We have a Data Dictionary where we store almost all our database logic, field names, table names, input formatters, output formatters, form layout, the works - including Lookup data for various fields.

What I would like to do is get the LookupDictionary record which contains the "table.fieldnames" of the fields to add to a DataTable to display and build the appropriate code from that data to retrieve the data to fill the datatable. The previous ORM tool we used allowed us (in cases such as this) to just build the SQL in our code and pass that to the server and it returned the DataTable to us.

Is there a way to pass a raw SQL string and return a DataTable?

In addition, is there a way for us to dynamically create a list of ResultsetFields() to pass to TypeListDAO() so we can use that method? (Considering all we have are lists of "table.fieldname" entries - course we can map the "table" to an Entity and the "fieldname" to an EntityField - just don't know the proper way to do that)

I looked as some of the other posts about getting the FieldIndex from the name of a field, but in our case, we won't even know the Entity that the Field is to use until we load the LookupDictionary record (since that data is contained in each).

Thanks for your help on this.

Andrew Fields

Have you looked at using a dynamic list to retrieve the information you need? You can tell it which fields you would like to return and it will generate the sql for you. What is it you are trying to do? The information that you are referring to as being kept in the database can also be in the generated code of your project, such as tables and fields along with their properties. If you are trying to discover or code against particular table attributes you may already have them in memory without having to access the database.