What are the benefits of using of ADO.NET in .NET 4.0.

CuriousTab

Discussion

Home ‣ Interview ‣ Technology See What Others Are Saying!

Question
What are the benefits of using of ADO.NET in .NET 4.0.

Correct Answer

The following are the benefits of using ADONET in NET 40 are as follows: => Language-Integrated Query (LINQ) - Adds native data-querying capabilities to NET languages by using a syntax similar to that of SQL This means that LINQ simplifies querying by eliminating the need to use a separate query language LINQ is an innovative technology that was introduced in NET Framework 35 => LINQ to DataSet - Allows you to implement LINQ queries for disconnected data stored in a dataset LINQ to DataSet enables you to query data that is cached in a DataSet object DataSet objects allow you to use a copy of the data stored in the tables of a database, without actually getting connected to the database => LINQ to SQL - Allows you to create queries for data stored in SQL server database in your NET application You can use the LINQ to SQL technology to translate a query into a SQL query and then use it to retrieve or manipulate data contained in tables of an SQL Server database LINQ to SQL supports all the key functions that you like to perform while working with SQL, that is, you can insert, update, and delete information from a table => SqlClient Support for SQL Server 2008 - Specifies that with the starting of NET Framework version 35 Service Pack (SP) 1, NET Framework Data Provider for SQL Server (SystemDataSqlClient namespace) includes all the new features that make it fully compatible with SQL Server 2008 Database Engine => ADONET Data Platform - Specifies that with the release of NET Framework 35 Service Pack (SP) 1, an Entity Framework 35 was introduced that provides a set of Entity Data Model (EDM) functions These functions are supported by all the data providers; thereby, reducing the amount of coding and maintenance in your application In NET Framework 40, many new functions, such as string, aggregate, mathematical, and date/time functions have been added

More questions

1. How would you automatically transfer your visitors to a new web page?

Discuss

Correct Answer: - You can do it with the help of meta tag mentioned below:

<META HTTP-EQUIV="Refresh" CONTENT="2"; URL="https://wwwyoursitecom">

Place this tag between <HEAD></HEAD> - It will load yousitecom in 2 seconds

3. Cash Reserve Ratio ( CRR) and Stautory Liquidity Ratio (SLR ) are terms most closely related to which of the following industries/markets :
Options
A. Mutual Fund
B. Income Tax
C. Stock Exchange
D. Banking

Discuss