.net - Safety critical app - Database row validation -


this perhaps little bit vague, i'm hoping in amongst people on there have ran type of issue before.

background
our application c# / .net service controls train orders. use linq-to-sql store state of rail network , train orders in sql server 2005 database.
have safety requirement cots software cannot "trusted" per se.

requirement
risk has been captured as: "sql server or operating system modifies static or dynamic data."
our mandate: "data stored in database shall validated such on read can confirmed data access code has not changed since last commit."

question
love find "automagic" way of fulfilling requirement.
failing that, way satisfy condition without having create columns in every table of database store computed hashes in (that have validate against when reading.)

maybe md5 checksum saved in either same or different table main data. checksum generated c# application if did update using raw sql checksum off.


Comments

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

aspxgridview - Devexpress grid - header filter does not work if column is initially hidden -

c# - How to execute a particular part of code asynchronously in a class -