I am building a web app for which I need a bit of guidance in design. We have one application from vendor which uses SQL Server 2005 as database. Let’s say vendor’s application provides details on Order etc. I am building a web app for which I need a bit