Skip to main content

How the features of ADO.NET are suitable for building modern applications that operate with many present day as well as futuristic data storage?

·        ADO.NET has plenty of features and a rich collection of classes that can be employed by developers to develop highly efficient and robust data service for .NET applications.

·        System.Data namespace is the parent namespace of all ADO.NET features and provides access to all the sub namespaces and the classes that represent the architecture of ADO.NET. This namespace provides the access to all the providers that are available in .NET framework.System.Data namespace contains various sub-namespaces like System.Data.OleDB, System.Data.Sql etc which is used in code to use provider-specific functionalities and standards.

·        The connection classes that are available with ADO.NET providers such as OleDbConnection, SqlConnection etc can be used in code to define efficient as well as secure connection with databases. For example, developers can allow or disallow to transfer encrypted passwords among .NET applications and databases, or they can select between database and Windows authentication modes by using these connection classes. Developers perform these steps to develop flexible yet very durable 2 – tier architecture for NET applications.

·        The ADO.NET provides various command classes that can be used to execute various database commands such as SQL queries, Data Manipulation Languages, stored procedures, triggers etc. The features of ADO.NET can be easily used with ODBC driver to access .NET applications can be developed that can work with all-most all presently existing databases by applying ODBC standards. ODBC drivers enable .NET application to use DBMS specific SQL.

·        ADO.NET enables .NET applications to use the data sources which are defined at a central location. i.e the data source is not defined with the client.

·        An ADO.NET data service allows a client application to access variety of ODBC drivers that are available on various local machines or networked servers. The driver can be updated at only one location (server), and is available to use for every .NET application which accesses the server.

·        ADO.NET includes a SQL Server Provider – which enables .NET applications to give optimized performance while working with SQL Server databases. The provider for SQL Server uses Tabular Data Stream (TDS) protocol for exchanging data between .NET applications and SQL server databases such as SQL Server 2005. By using the provider for SQL Server in .NET applications, gives a very high performance while connecting and executing the queries on SQL Server 7.0 and above versions of SQL Server databases.

·        ADO.NET internally uses XML to fetch and store data in .NET applications. As, XML is the standard data interchange format for exchanging data across devices and platforms, ADO.NET enables .NET applications to fetch or store data from a wide range of data sources such as various databases or XML files that are available on local or networked resources. Data sources can also exist within the domain of some legacy software systems that can be accessed by using various routers or remote serves. As DataSets uses XML format to store data in .NET applications, they can be used by Web Services to transfer relational data which is fetched by one application to another applications. Thus, DataSets are portable units that can be shared among wide range of applications.

·        ADO.NET’s DataSet class is used for developing local data sources in .NET applications. The disconnected architecture of the .NET applications that uses DataSets is remarkably efficient and scalable. The disconnected architecture of a .NET application does not enforce any restriction on the choice and number of the data-sources that application can use to fill DataSets. Thus, an unlimited number of supported data sources can be plugged into code without any hassle in the future.

Posted By: Chaudhary Amit V.

The above content is written from various books which are available in our library.
Labels:

Comments

  1. Bhupendra SinghNovember 18, 2010 at 8:08 AM

    hi.. amit this is cool blog
    bt i want to ask that in mobiles we use WAP OR HTTP to acess the internet????
    and exactly what is GPRS ? , it is a mode or service to access internet from mobile??

    ReplyDelete

Post a Comment

Popular posts from this blog

Characteristics of a Good Programming Language

Till now there are many high level languages which are very popular, and there are others, which could not become so popular in-spite of being very powerful. There might be many reasons for the success of a language, but one obvious reason is the characteristics of the language. Several characteristics believed to be important with respect to making a programming language good are briefly discussed below. Simplicity A good programming language must be simple and easy to learn and use. For example, BASIC is liked by many programmers only because of its simplicity. Thus, a good programming language should provide a programmer with a clear, simple and unified set of concepts which can be easily grasped. It is also easy to develop and implement a compiler or an interpreter for a programming language that is simple. However, the power needed for the language should not be sacrificed for simplicity. The overall simplicity of a programming language strongly affects the readability of the pr...
1 comment
Read more

Angular 4 and Firebase Authentication: Email/Password

In our  previous  article we saw how to create authentication module using Google identity provider. Now we will see how to implement Email and Password authentication using Firebase. We will use Bootstrap form to create intuitive user interface for sign-up and login using Email and Password. Step 1: Create signUp component. ng generate component signUp Step 2: Create custom form in sign-up.component.html file. The result of above code: Step 3: Add two functions for creating the user and login using Email and Password in src/app/providers/AFAuth.ts file. Step 4: Call createUserWithEmailAndPassword function in service from sign-up.component.ts. Step 5: Update routing configuration in app.module.ts  to include signUp component. Step 6: Update Login form to have Bootstrap form. The result of the above code. Step 7: Enable Email/Password component in Firebas...
Post a Comment
Read more

Angular 4 and Firebase Authentication: Setup

If you have come to this article, it means you are keen to learn new technology and that too Firebase. I love Firebase because it provides all basic but important features of any web application. Take for example, authentication, which is cumbersome and risky if not implemented with utmost care. And when we have the integration of Angular and Firebase, it becomes a lot easier for a developer to build such crucial modules in less time with minimal efforts. In this article we will create a simple Angular application using Firebase. I am going ahead with the understanding that you know the benefits of Firebase and have little knowledge about it. There are plenty of posts out on the web if you are behind. Step 1: Install Angular CLI (if not installed). npm install -g angular-cli Step 2: Create new Angular 4 project. By default now angular CLI will create Angular 4 project so you need not fret. ng new firebase-authentication Step 3: Check whether the ne...
Post a Comment
Read more