Introduction To Microsoft DOT NET Language ,Tools and Frame Work Architecture

“.NET is Microsoft’s product”. It’s a Developer environment in which you can build, create, and deploy your applications.Microsoft introduced great technologies like COM, DCOM, and COM+ etc. to enable reuse of Software are included in .NET.  Visual Studio contain following languages C#, J#, VC++ and VB, .

About Author

This tutorial is submitted by Sajith and Mahesh , 2007 Computer Science Pass out  from  TocH Institute Science and Technology -Arakkunnam Ernakulam
Other works by same authors

• Introduction to Computer Graphics Algorithms
• Introduction to Basic Principles of Animation
• Implementing Computer graphics through C application

                                F-1 NET FRAMEWORK
                               

Visual Studio.Net contain following languages ,C#, J#, VC++, VB, and JavaScript and some additional languages which can be included in visual studio  are   ASP,CORBA,FORTRAN,PASCAL,XML MERCURY,OBERON,PERL,PYTHON,RPG,SCHEME

       VB.NET is currently a part of visual studio.NET .Microsoft Visual VB.NET is the tool set for creating application based on windows forms and controls. This robust development package which uses the component-oriented VB development language, offers language and environment for creating next generation software. Visual VB.NET delivers superior functionality for streamlining business processes, including:

•     Rapid design and development using controls
•     Form design and visual control for creating rich window based application
•     Authorized tools and services for building powerful Microsoft.NET server based solutions.
•     Migration tools for and services for building powerful Microsoft.NET server based solutions.

         ADO.NET (ActiveX Data Objects .NET) is the primary data access API for the .NET Framework. It provides the classes that you use as you develop database applications with Visual Basic .NET as well as other .NET languages. In the two topics that follow, you’ll learn about how ADO.NET uses these classes to provide access to the data in a database and the two ways you can create ADO.NET objects in your Visual Basic programs.

              To work with data using ADO.NET, you use a variety of ADO.NET objects. Figure 2-1 shows the primary objects you’ll use to develop Windows-based ADO.NET applications in Visual Basic.To start, the data used by an application is stored in a dataset that contains one or more data tables. To load data into a data table, you use a data adapter. The main function of the data adapter is to manage the flow of data between a dataset and a database. To do that, it uses commands that define the SQL statements to be issued. The command for retrieving data, for example, typically defines a Select statement. Then, the command connects to the database using a connection and passes the Select statement to the database. After the Select statement is executed, the result set it produces is sent back to the data adapter, which stores the results in the data table.

To update the data in a database, the data adapter uses a command that defines an Insert, Update, or Delete statement for a data table. Then, the command connects to the database and performs the requested operation. Although it’s not apparent in this figure, the data in a dataset is independent of the database that the data was retrieved from. In fact, the connection to the database is typically closed after the data is retrieved from the database. Then, the connection is opened again when it’s needed. Because of that, the application must work with the copy of the data that’s stored in the dataset. The architecture that’s used to implement this type of data processing is referred to as disconnected data architecture. Although this is more complicated than a connected architecture, the advantages offset the complexity.

One of the advantages of using disconnected data architecture is improved system performance due to the use of fewer system resources for maintaining connections. Another advantage is that it makes ADO.NET compatible with ASP.NET web applications, which are inherently disconnected. The ADO.NET classes that are responsible for working directly with a database are provided by the .NET data providers. These data providers include the classes you use to create data adapters, commands, and connections. As you’ll learn later in this chapter, the .NET Framework currently includes two different data providers, but additional providers are available from Microsoft and other third-party vendors such as IBM and Oracle.

 
ADO.NET working

Description

• ADO.NET uses two types of objects to access the data in a database: datasets, which can contain one or more data tables, and .NET data provider objects, which include data adapters, commands, and connections.
• A dataset stores data from the database so that it can be accessed by the application. The .NET data provider objects retrieve data from and update data in the database.
• To retrieve data from a database and store it in a data table, a data adapter object issues a Select statement that’s stored in a command object. Next, the command object uses a connection object to connect to the database and retrieve the data. Then, the data is passed back to the data adapter, which stores the data in the dataset.
• To update the data in a database based on the data in a data table, the data adapter object issues an Insert, Update, or Delete statement that’s stored in a command object. Then, the command object uses a connection to connect to the database and update the data.
• The data provider remains connected to the database only long enough to retrieve or update the specified data. Then, it disconnects from the database and the application works with the data via the dataset object. This is referred to as disconnected data architecture.
• All of the ADO.NET objects are implemented by classes in the System. Data namespace of the .NET Framework. However, the specific classes used to implement the connection, command, and data adapter objects depend on the .NET data provider you use.