There are many Web application frameworks emerging these days. Most of these frameworks are driven by MVC (Model View Controller) architecture. Web browsers have become the common client for most of these frameworks. Often, there is no other way to access data other than using the end client. With the increasing popularity of SOA, there is a strong need for building Web applications in such a way that the data can be accessed in flexible ways other than using a Web browser. Using traditional approaches, we end up writing the entire application from scratch to support newer ways to access the data. The focus of this thesis is to discuss the emerging framework called SOFEA (Service Oriented Front-End Architecture). This thesis discusses how to automatically generate the Persistent Object Layer, Service Layer etc., from SQL schema. This thesis also discusses a Web application called GlycoVault developed using SOFEA.