help.net

<font size="2"><br />Musing on .Net</font>

  • How to start with N-tier architecture


    If you are a newbie with N-Tier achitecture, .Net and visual Studio, it's quite a challenge to find a good example on the subject.

    You should try NTierGen. The tool is a bit expensive, but you have eventually a trial version, just limited to three tables.

    The idea to generate the full N-Tier architecture from a wizard is good, including the fact that you can modify the code produced.

    This is a really amazing tool, and you should be able to see the sources and look at the way you can build an N-Tier architecture. Of course, I suggest to buy it ;-)

  • SQL book


    I received few days a bunch of good books. The one I want to mention is a must-have on your shelve.

    If you are working with SQL 2000,
    SQL 2000 Fast answers is a clever book in the vein of 'How to...' type of books.

    1904347096.01.LZZZZZZZ

  • Dynamic queries or stored procedures


    Just reading Frans blog about stored procedures and the future for them.
    I agree with Frans that views are really powerful.

    I like stored procedures because they can be easily updated outside your code.
    It's happen many times for me to have to add a field to a database, and if I have to modify a code already in production, I would have certainly to go through some issues.

    When you modify your code, it could be hazardous, and sometime a complex query can be difficult to understand when it's embedded in a class.

    Stored procedures are easy guys for that.

    For the future I expect that Microsoft will not go too much in the 'lazy' proprietary way of doing everything with .Net.
    I enjoy Transact-Sql and the way that I can almost change from SQL Server to Oracle without breaking too much things.