"FRONT OFFICE AUTOMATION SYSTEMCommon Type System (CTS) describes how types are declared, used and managedin the runtime and facilitates cross-language integration, type safety and high performancecode execution.The CLS is simply a specification that defines the rules to support languageintegration in such a way that programs written in any language, yet can interoperate withone another, taking full advantage of inheritance, polymorphism, exceptions, and otherfeatures. These rules and the specification are documented in the ECMA proposed standarddocument,”Reflection:The process of reading the metadata of information is reflection. Metadata is anopen standard environment.DEPT OF IT, PDCE 2009-2010 Page 7 FRONT OFFICE AUTOMATION SYSTEMTool box:It is GUI container that contains all the needed development controls like textbox(input of the data), button (to rise on event), label (Description), link etc.Solution explorer:It is GUI container that shows the various forms or web forms or list of variousitems that are used in the project.Link label: It is similar to label but with an under linking format (blue color). We can’t executelabel in the runtime where as link can be executed in the runtime. It is used for hyperlinking interface to the .Net but it has some disadvantages as it can be only opened by thedefined location by the users. ADO. NET:Stands for activeX data object. Dataset is an in-memory content of the Ado .Net and is disconnected architecture ofAdo .Net.The connection between back end (database) and front end (dataset) is called asData Adaptor. In back end, it creates a table with table name and column and required datatypes.Main database used in .Net? Oracle? Sql server? Ms access To establish connection in Sql.Sql Connection cn = New Sql Connection (connection string);DEPT OF IT, PDCE 2009-2010 Page 8 FRONT OFFICE AUTOMATION SYSTEMAs“User id= sa; Password=rvrjc; Database=swathi.mdf; Server=.”;To established connection in oracleOracle Connection cn = New Oracle (connection string);As“User id= Scott; Password=tiger; Database=swathi.mdf; Server=.”;Command object:-SyntaxSql Command <obj> = New Sql Command (“Sql Statements”, cn);Methods if command object in Ado .Net:-1. ExecuteNonQuery();2. ExecuteScaler();3. ExecuteReader();4. ExecuteXmlReader();To open connection the following method is usedDEPT OF IT, PDCE 2009-2010 Page 9 "