I'm currently writing a GUI query generator to produce Dynamic Lists and need to get the fields and datatypes for SQL views which are mapped as entities. I've found various enums for fields but no datatype info. What is the best way to get fieldnames, datatypes, keys and relations from LLBGEN.

Thanks Mark

Please check the EntityField class properties in the Refernce Manual.

OK so how do you generate an EntityField for a field in a view when you have the viewname and fieldname as strings (from GUI comboboxes); so you can use it in code to generate a dynamic list.

ResultsetFields fields = new ResultsetFields(1); fields.DefineField(????,0);

It took me a half an hour to do all this in straight SQL with code like DataTable views = con.GetSchema(SqlClientMetaDataCollectionNames.Views);

and

SqlCommand cmd = new SqlCommand("select * from " + Viewname, con); SqlDataReader r = cmd.ExecuteReader(CommandBehavior.SchemaOnly);

but the generated code has so much baggage, I get lost, casts here there and everywhere It's been a hard day

My bad

ResultsetFields fields = new ResultsetFields(1); EntityField ef = (EntityField)EntityFieldFactory.Create("Person.ViewEntity","Surname"); fields.DefineField(ef, 0);

I'll read more slowly!