I wondering if anyone has seen or built a ASP.NET UI control or framework that can be passed an entity/entity collection, figure out what fields are available and what data types to expect and help an application's user pick criteria and build the LLBLBGen filter expression. It's obviously a bit more complex than that but I'd rather not try to adapt a native sql query builder that might be able look at the db directly (something like http://devtools.korzh.com/eq/dotnet/) but would not necessarily be aware of prefetch options and be leveraging the LLBLGen's knowledge of how the tables fit together.

I see that I should be able to write it myself and there are some useful code snippets on the forum for extracting fields,etc., but I can't believe that someone hasn't done something that would save me starting from scratch on a nice general purpose solution.

Suggestions?

As a matter of fact, I have, it's perhaps not that sophisticated, but it works OK. It's in the database editor templates which we'll release tomorrow (friday) in beta

Newbie call for help. I downloaded the new templates and combed through them and do not see exactly what I was expecting. Can you point me to the specific files I should be reviewing?

CMCKEACHIETITAN wrote:

Newbie call for help. I downloaded the new templates and combed through them and do not see exactly what I was expecting. Can you point me to the specific files I should be reviewing?

The Search_entitytype_ controls contain a multi field filter form. It's pretty basic, but gets you started I think. We just released a bugfixed version of the templates. Please use these to generate a dbeditor application for a given database, e.g. northwind, and click the ListSubSet on the startpage of the application (when you have everything running of course), you'll see the form for the particular entity selected.