Before going into how paging is implemented with LINQ, Let’s discuss the need for implementing paging. With large amounts of data, it is not a good practice to pull all records from database when you are showing a fraction of them in one page. It is always recommended to use data on demand approach. When [...]
Language Integrated Query (LINQ) is a query execution pipeline for use in the managed environment of .NET Framework. In essence, LINQ is Microsoft’s object relational mapper between your business objects and the underlying data sources and provides a simplified framework for accessing relational data in an object-oriented fashion. Although LINQ is great in the sense [...]
Objects that implement IDisposable are everywhere. The interface even gets its own language features (C#, VB, F#). However, LINQ throws a few wrenches into things: LINQ’s query syntax depends on expressions; using blocks are statements. When querying a sequence of IDisposable objects, there’s no easy way to ensure disposal after each element has been consumed. [...]
This video, courtesy of Microsoft’s ASP.NET video series, provides an example of using LINQ to SQL to execute arbitrary SQL against a database.
This video, courtesy of Microsoft’s ASP.NET video series, provides an example of using LINQ to SQL and stored procedures to update a table.
This video, courtesy of Microsoft’s ASP.NET video series, provides an example of using LINQ to SQL with stored procedures.
This video, courtesy of Microsoft’s ASP.NET video series, provides an example of creating a custom LINQ to SQL LinqDataSource.
This video, courtesy of Microsoft’s ASP.NET video series, provides an example of using the LINQ to SQL LinqDataSource.
This video, courtesy of Microsoft’s ASP.NET video series, provides an example of using LINQ to SQL to update a table in a database.
This video, courtesy of Microsoft’s ASP.NET video series, provides an example of using LINQ to SQL to query a database.
Read Users' Comments (0)