An Ordinary Man

Enterprise Application Integration is an integration framework composed of a collection of technologies and services which form a middleware  to enable integration of systems and applications across the enterprise.  Fundamentally, it is all about sharing and distributing data and processes among different applications and data sources of that enterprise. EAI could be divided into 4 integration levels: Data Level Application Interface Level Method Level User Interface Level Data Level:  It is actually a database-centric approach that involves the extracting of data from one database and updating it in other. At times the extracted data can be changed before entering it into that target database, for example, to apply specific business rules. It’s commonly done through ETL (Extract, Transform, and Load).  The main benefits of this approach are its low cost and low risk profile. Because in this, we don’t have to make any modifications to the existing code of the app

An exception is an event, which occurs during the execution of a program, that disrupts the normal flow of the program's instructions.  The different approaches in ASP.Net to handle exceptions Use exception-handling structures to deal with exceptions within the scope of a procedure. try { ---- } catch { ---- } finally { -----} Use error events to deal with exceptions within the scope of an object. Page_Error - The Page_Error event handler provides a way to trap errors that occur at the page level. Application_Error - Application_Error event handler to trap errors that occur at the application level. Custom error pages to display custom error pages for unhandled exceptions at application level. <customErrors mode="RemoteOnly" defaultRedirect="~/errors/GeneralError.aspx" redirectMode="ResponseRewrite" />  The ResponseRewrite mode allows us to load the Error Page without redirecting the browser, so the URL stays

SQL Server Session Management Configure SQL Server for ASP.NET SQL Server Session State in Custom Database. To install the session state database on SQL Server, run Aspnet_regsql.exe tool supply the following information with the command: aspnet_regsql -ssadd -sstype c -d < Database> -S <Server> -U <Username> -P <Password> ·          The name of the Database, using –d option. ·          The name of the SQL Server instance, using the   -S   option. ·          The logon credentials for an account that has permission to create a database on a computer running SQL Server. Use the   -E   option to use the currently logged-on user, or use the   -U   option to specify a user ID along with the   -P   option to specify a password. ·          The   -ssadd   command-line option to add the session state database. ·          The -sstype command-line option to specify the type of session state to use. c for Custom i.e. both session state data and stored