.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Interview Question >> ADO.Net >> Post New Question Subscribe to Interview Questions

What are the Benefits of ADO.Net?

Posted By :Gowthammanju     Posted Date :July 31, 2011    Points :40   Category :ADO.Net 
ADO.Net offers following Benefits
Interoperability:
XML Format is one of the best formats for Interoperability.ADO.NET supports to transmit the data using XML format.

Scalability:
ADO.NET works on Dataset that can represent a whole database or even a data table as a disconnected object and thereby eliminates the problem of the constraints of number of databases being connected. In this way scalability is achieved.

Performance:
The performance in ADO.NET is higher in comparison to ADO that uses COM marshalling.

Programmability:
ADO.Net Data components in Visual studio help to do easy program to connect to the database.




You can also find related Interview Question to What are the Benefits of ADO.Net?  below: 

What are the main benefits of Office SharePoint Server 2007?

  
Office SharePoint Server 2007 provides a single integrated platform to manage intranet, extranet,and Internet applications across the enterprise.

* Business users gain greater control over the storage, security, distribution, and management of their electronic content, with tools that are easy to use and tightly integrated into familiar,everyday applications.

* Organizations can accelerate shared business processes with customers and partners across organizational boundaries using InfoPath Forms Services-driven solutions.

* Information workers can find information and people efficiently and easily through the-facilitated information-sharing functionality and simplified content publishing. In addition, access to back-end data is achieved easily through a browser, and views into this data can be personalized.

* Administrators have powerful tools at their fingertips that ease deployment, management, and system administration, so they can spend more time on strategic tasks.

* Developers have a rich platform to build a new class of applications, called Office Business Applications, that combine powerful developer functionality with the flexibility and ease of deployment of Office SharePoint Server 2007. Through the use of out-of-the-box application services, developers can build richer applications with less code. (More...)

What are the disadvantages of viewstate/what are the benefits?

  
Disadvantages
1)Performance can be reduced. becuse the viewstate is stored in the page itself, storing large values can cause the page to slowdown.It can carry only up to 10 KB of data very easily without causing any degraded perfomance.
2) As view state is stored in a hidden field on the page although it stores data in a hashed base64 encoded format, it can be tampered.

Advantages :
1) No server resources are required
2) simple Implementation
3) Automatic retention of page & view state (More...)

What are the benefits of ADO.NET?

  
BENEFITS OF ADO.NET
--------------------
1>Scalability:-
ADO.NET works on DataSet that can represent a whole database or even a data table as a disconnected object and thereby eliminates the problem of the constraints of number of databases being connected. In this way scalability is achieved.

2>Data Source Independence:-
In ADO.NET DataSet is completely independent of data source and no way DataSet is controlled by the data source as it happens in case of RecordSet.

3>Interoperability:-
As ADO.NET transmits the data using the format of XML which is not dependent on ADO.NET or windows platform.

4>Strongly Typed Fields:-
It supports strongly typed fields by using CTS.

5>Performance:-
The performance in ADO.NET is higher in comparison to ADO that uses COM marshalling.

6>Firewall:
As in ADO.NET transmission is via XML format, therefore it can pass through firewalls. (More...)

What are the benefits of globalization/localization ?

  
1. Help in being globally competitive.

2. Enhancing the impact of the product in its respective foreign market.

3. Harnessing the wide scope of entering into global markets.

4. Increased revenue and share of global and multicultural markets.

5. Better customer communications through locale-specific content

in the preferred native languages.

6. Stronger brand penetration and increased equity.

7. Lower cost of doing business.

8. Improved time to market and competitive nimbleness.
(More...)

What are the Benefits of Side-by-Side Execution ?

  
Side-by-side execution and the .NET Framework provide the following features to eliminate DLL conflicts:

1)Strong-named assemblies:-
----------------------------
Side-by-side execution uses strong-named assemblies to bind type information to a specific version of an assembly. This prevents an application or component from binding to an invalid version of an assembly. Strong-named assemblies also allow multiple versions of a file to exist on the same computer and to be used by applications.

2)Version-aware code storage:-
-----------------------------
The .NET Framework provides version-aware code storage in the global assembly cache. The global assembly cache is a computer-wide code cache present on all computers with the .NET Framework installed. It stores assemblies based on version, culture, and publisher information, and supports multiple versions of components and applications. For more information, see Global Assembly Cache.

3)Isolation:-
-------------
Using the .NET Framework, you can create applications and components that execute in isolation, an essential component of side-by-side execution. Isolation involves being aware of the resources you are using and sharing resources with confidence among multiple versions of an application or component. Isolation also includes storing
(More...)

What are the differences between the two base classes and what are the inherit benefits of using one over another?

  
The difference is the Microsoft.SharePoint.WebPartPages.WebPart base class is meant for backward compatibility with previous versions of SharePoint. The benefit of using the SharePoint WebPart base class is it supported:
Cross page connections
Connections between Web Parts that are outside of a Web Part zone
Client-side connections (Web Part Page Services Component)
Data caching infrastructure
ASP.NET 2.0 WebParts are generally considered better to use because SharePoint is built upon the ASP.NET 2.0 web architecture. Inheriting from the ASP.NET 2.0 base class offers you features that inherit to ASP.NET 2.0, such as embedding resources as opposed to use ClassResources for deployment of said types.
(More...)

What are the benefits of using Windows Services:

  
The following are the benefits of using Windows Services:

· Network connection management

· Disk access monitoring

· Security control of application

· Log messages related to the application's requirements
(More...)

What are the benefits of ADO.NET?

  
BENEFITS OF ADO.NET


1>Scalability:-
ADO.NET works on DataSet that can represent a whole database or even a data table as a disconnected object and thereby eliminates the problem of the constraints of number of databases being connected. In this way scalability is achieved.

2>Data Source Independence:-
In ADO.NET DataSet is completely independent of data source and no way DataSet is controlled by the data source as it happens in case of RecordSet.

3>Interoperability:-
As ADO.NET transmits the data using the format of XML which is not dependent on ADO.NET or windows platform.

4>Strongly Typed Fields:-
It supports strongly typed fields by using CTS.

5>Performance:-
The performance in ADO.NET is higher in comparison to ADO that uses COM marshalling.

6>Firewall:
As in ADO.NET transmission is via XML format, therefore it can pass through firewalls. (More...)

What are the differences between the two base classes and what are the inherit benefits of using one over another?

  
The difference is the Microsoft.SharePoint.WebPartPages.WebPart base class is meant for backward compatibility with previous versions of SharePoint. The benefit of using the SharePoint WebPart base class is it supported: Cross page connections Connections between Web Parts that are outside of a Web Part zone Client-side connections (Web Part Page Services Component) Data caching infrastructure ASP.NET 2.0 WebParts are generally considered better to use because SharePoint is built upon the ASP.NET 2.0 web architecture. Inheriting from the ASP.NET 2.0 base class offers you features that inherit to ASP.NET 2.0, such as embedding resources as opposed to use ClassResources for deployment of said types. (More...)

What is unit testing? What are benefits of Unit testing?

  
In computer programming, unit testing is a method by which individual units of source code are tested to determine if they are fit for use. A unit is the smallest testable part of an application. In procedural programming a unit may be an individual function or procedure. Unit tests are created by programmers or occasionally by white box testers.

Benefits

1.1 Facilitates change
1.2 Simplifies integration
1.3 Documentation
1.4 Design

Read more at

http://en.wikipedia.org/wiki/Unit_testing (More...)

What are the benefits of views?

  
Users focus only on data that they need; user manipulation of data is simplified; database and query complexity is hidden from users, allowing users to see friendly names; and views provide a security mechanism by allowing users access to data through views only.
(More...)

What are the benefits of User-Defined Functions?

  
created and defined by the user
They can be used to create joins and simple to invoke as compared to stored procedures (More...)

What are the benefits of Microsoft Office SharePoint Server 2007?

  
Provide a simple, familiar, and consistent user experience.* Boost employee productivity by simplifying everyday business activities.

Help meet regulatory requirements through comprehensive control over content.

Effectively manage and repurpose content to gain increased business value.

Simplify organization-wide access to both structured and unstructured information acrossdisparate systems.

Connect people with information and expertise.

Accelerate shared business processes across organizational boundaries.

Share business data without divulging sensitive information.

Enable people to make better-informed decisions by presenting business-critical information inone central location.

Provide a single, integrated platform to manage intranet, extranet, and Internet applicationsacross the enterprise. (More...)

Benefits of Silverlight

  
* Silverlight offers cross-domain support for applications
* Silverlight plugin is just a 1MB download and is supported in windows XP and above.
* Silverlight also has a browser plugin but still needs to reach at pace with flash.
* supports asynchronous calls (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

 
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.


Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend