26 Articles

Caching Data

Last Updated On : Thursday, May 17, 2018Lesson 1: Caching Data Not all data is volatile That should not come as much of a surprise to most of you, but if you look at the data strategies for most applications, you could surmise that most developers don’t understand this basic idea In many of those […]

Data Integrity and transactions

Last Updated On : Thursday, May 17, 2018 Data Integrity and transactions Using ADO NET data integrity can be ensured at two levels The fi rst involves making sure the data in the DataSet is valid at all times The second is to make sure that the consist state of the DataSet is stored correctly in […]

Updating Custom Types

Last Updated On : Thursday, May 17, 2018Updating Custom Types SQL Server 2005 and later support the use of Common Language Runtime (CLR) types as column types. ADO.NET supports this feature through the SqlClient namespace and a SqlCommand or even a DataAdapter UPDATE statement can be used to update a custom type. DataSet Designer, however, […]

Updating Data

Last Updated On : Thursday, May 17, 2018Updating Data There are many ways of updating data using ADO NET This lesson explains the core ADO NET elements involved in performing updates Higher levels of abstraction, such as LINQ to SQL and Entity Framework, use these elements while allowing you to program in an object-oriented manner. […]