Two questions:
1) I went through a lot of trial and error installing the llblgen generated classes. I am using the adapter template.
I wasn't sure whether to add both the database generic and database specific projects, or refer to one or more dlls from those projects under my project references or what. I did finally get it working, I think by doing both of the above.
Last night I tried regenerating again and committing to our SVN repository. Had all sorts of referencing errors in my code, with the dataacessadapter, a wierd one where it complained about duplicate attributes in the assembly.info (I think - not in front of me) file. There was one of those under the database generic and one under data specific so I excluded one from the project to get past that. Now it can't find the stored procedure classes.
I basically just need a step by step best practices way of getting what I need into my VS 2010 solution (projects, dll's, and where to put them), and the best and easiest way to regenerate and manage under subversion.
2) Best way to be able to dynamically add filters on 3 or more fields and also perform a CountDistinct aggregate on a field in a related table, especially using the expression syntax to get a scalar with the dataAccessAdapter (or whatever would be better).
