Page 110 - DCAP312_WEB_TECHNOLOGIES_II

Web Technologies-II

Notes Saves Time and Money

When Epicor realized it did not have to write its own new data access layer, the company
knew that it would be able to reduce development costs. “Because of the ADO.NET Entity
Framework 4, we no longer have to be in the LINQ provider business,” says Johnson. “We
can offload framework development, and as a result we do not spend time and money
training our developers.”
Epicor has also experienced strong compiled query performance, which will lead to further
cost savings. “We noticed immediately that the ADO.NET Entity Framework 4 is extremely
fast at row materialization,” says Johnson. “Overall, the per-row development cost was lower
in the Entity Framework 4 than in all of the other technologies we evaluated.”
Questions

1. What was the main problem in the company?
2. How the problem was solved and what benefits are found using the ADO.NET?
Self Assessment Questions

6. The term OleDb stands for:
(a) Object Linking and Embedding DataBinding
(b) Object Lightening and Embedding DataBase
(c) Object Linking and Embedding DataBase

(d) None of these.
7. The ODBC stands for:
(a) Object Linking and Embedding DataBinding
(b) Open DataBase Connectivity

(c) Object DataBase Connectivity (d) None of these.
8. In .NET, connected approach is accomplished using the ………… objects.
(a) connection (b) command
(c) datareader (d) All of these.
9. Which object is not used in connected approach?
(a) Connection (b) Command

(c) DataAdapter (d) DataReader
10. Which query will return the address of the cursor?
(a) ExecuteXmlReader() (b) ExecuteScalar()
(c) ExecuteNonQuery() (d) ExecuteReader()

11. Which query will return the number of rows affected?
(a) ExecuteXmlReader() (b) ExecuteScalar()
(c) ExecuteNonQuery() (d) ExecuteReader()
12. Which query will return the first [row][column] of the result?
(a) ExecuteXmlReader() (b) ExecuteScalar()
(c) ExecuteNonQuery() (d) ExecuteReader()

104 LOVELY PROFESSIONAL UNIVERSITY