I am developing a sophisticated search engine for my website which would aggregate complex data that is stored in various tables in a SQL Server database. OLAP is out of question due to budgeting constrains, so we consider developing our own stored procedures and implement reports with SSRS. I am unable to find on the Internet a code generator which would let us explore with our client various data retrieval scenarios. Has anyone come across a code generator that can serve my purpose?
Thanks in advance!
Hello! I am also a web developer and I was looking for a code generator when I had to develop a database intensive project. I decided to use OxyGen Code (http://www.techinceptions.com/codegenerator.html) to generate our stored procedures and the data access layer. OxyGen Code gave us a much needed productivity boost so we were able to focus on the business rules and the UI rather than writing SQL and data retrieval logic. I would suggest downloading OxyGen Code and giving it a try! Happy holidays!