When performing queries over large datasets there is often the need to page the data, such that it can be displayed in smaller amounts, aka pages, incrementally. When thinking about database paging two immediate distinctions can be made; in-memory paging and database paging.
Depending on the size and usage of the data, each has its advantages [...]
The .NET managed provider factory model makes it easy to switch between database providers without having to change or re-compile any code. How does it achieve this vendor independent behaviour? Through a software pattern or model known as the database provider model.
Database Providers
Typically, when writing applications that make use of ADO.NET you make use of [...]
LINQ is a great time saving technology that distances the programmer from having to write complex SQL queries when working with databases. It offers a generic means for querying heterogenous IEnumerable data sources. It provides simple object relational mapping.
Object Initializers provide a short hand way of initializing an object in a single statement, rather than [...]
