Post reply

Fool-proof access to a database for security

  • September 7, 2015 at 11:58 pm

    #304217

    * All access through stored procedures

    * A single attribute with no other configuration

    * Interface is: Load, Store, Delete, LoadAll, LoadList (LoadList has a parameter for an alternate SP to be called)

    See attached images for example.

  • September 8, 2015 at 12:00 am

    #1825042

    Is there a question here ?

    Jayanth Kurup[/url]

  • September 8, 2015 at 12:04 am

    #1825044

    Request for comments, I suppose.

  • September 8, 2015 at 12:38 am

    #1825046

    The Persistence.DLL and some useful SQL Server SPs/Function are attached.

  • September 9, 2015 at 11:28 pm

    #1825586

    If your looking for comments on the code behind

    try catch block and validations come to min.

    At database side date format and timezone info could be useful.

    You could use some styles for the layout

    and possibly handle the valiadtion using jquery.

    Jayanth Kurup[/url]

  • September 10, 2015 at 8:32 pm

    #1825872

    Jayanth_Kurup (9/9/2015)

    If your looking for comments on the code behind

    try catch block and validations come to min.

    At database side date format and timezone info could be useful.

    You could use some styles for the layout

    and possibly handle the valiadtion using jquery.

    It throws informational errors from the database, so I don't think many try/catches are necessary.

    Date format and timezone info is interesting. I'd have to think about the right place for that specification.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply