Large reporting project in .Net

Discussion in 'Mac Programming' started by werrockjiu, Dec 13, 2007.

  1. werrockjiu macrumors newbie

    Joined:
    Dec 13, 2007
    #1
    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!
     
  2. garethlewis2 macrumors 6502

    Joined:
    Dec 6, 2006
    #2
    No-one is going to develop a free or OpenSource version of a product like this. These are like gold-dust, entire consultancy companies are based around shovelling commercial products that do what you want.
     
  3. eastcoastsurfer macrumors 6502a

    Joined:
    Feb 15, 2007
    #3
    First of all this is OSX programming.

    But since you asked...if you already have MSSQL (and I think reporting services only comes in the enterprise version) then that means you have the MS OLAP product. Build your cubes in it and use excel as your front end for a cheap, effective solution to pivot around lots of data.
     
  4. kilarforat macrumors newbie

    Joined:
    Dec 13, 2007
    #4
    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!
     
  5. Monkaaay macrumors 6502

    Monkaaay

    Joined:
    Jun 19, 2006
    Location:
    Richmond, VA
    #5
    When it comes to a data access layer, you should be checking out LINQ. It's a part of C# 3.0. It gives you a visual way to create your DAL and makes data access extremely simple.
     

Share This Page