I’m new to LLBLGen Pro, and wanted to say to Frans and the team what a great product you have. I’ve been truly impressed with the application and the generated framework.

After years and years of writing stored procedures and middle-tier code to implement SP’s, this is really a big paradigm shift for me. I’m still trying to get used to the OOP implementation (which makes perfect sense, since we develop in OO environment) instead of T-SQL. I’ve read the reference manual (killed a lot of trees while printing certain sections), help, and searched online for help to my problem.

I’m certain that the answer is easy to my problem, but I could sure use some tips from those of you with experience with this tool. I have a states table and a rates table, which are related by a StateID. I need the state name from the states table along with the other fields from the rates table. This inner join is easy using the predicate (or typed list), but what I really need is to group the rates data under their respective state. (using self-servicing)

I’m using the Infragistics Win grid (VB.NET) and want to have the first band to contain the state name, and the second band (related to the first) to contain all of the rate data for that state. It should look like this:

State Name #1 Amount | Percent | EffectiveDate Amount | Percent | EffectiveDate

State Name #2 Amount | Percent | EffectiveDate Etc.

What’s the best way to implement this? Your insight is appreciated.

-rv

I'm not sure how infragistics works, but I assume that you would be able to state a column that you would want to group by as long as it was in the collection. If you are always needing the state name when you pull rates in then you may consider using the designer to map the statename as a related field that will be available when you query rates. I believe there are some nice screen shots for this with some documentation under Using the designer -> Adding and editing entities.

Thanks for you response. The answer to your question is that I do have the states relation defined in my collection. It's starting to look like I need to do some client side processing instead of server side.

Thanks again.