By tag: LINQ2SQL
0
kicks
IQueryable: Sorting, Paging, Searching and Counting
A good post that contains extension methods that add sorting, paging, seacrching and countain functionality to IQueryable objects.
0
kicks
LINQ to SQL Generic Repository | {Programming} & Life
After my last post regarding the strange NotSupportedException I was receiving on my generic repository, I thought it might be fitting to post what my LINQ to SQL generic repository looks like and what it’s all about.
0
kicks
Untie LINQ to SQL Connection String from Application Settings
Did you know that by default LINQ to SQL compiles your connection string and defines it in more than one place if you define your LINQ to SQL classes out from a web app, such as a data access layer class library?
0
kicks
How to use “IS NULL” with LINQ to SQL
Another “gotcha” using LINQ to SQL that I’ve found if you wish to test for “null” on a nullable column in SQL Server using the “IS NULL” clause...
0
kicks
Log LINQ 2 SQL query execution to console/debug window
Wow, I just learnt a valuable trick in LINQ 2 SQL. In this article I will explain how you can output to a debug window the executed SQL ran by LINQ 2 SQL.
0
kicks
LINQ 2 SQL — Less is More (More or Less)
There are two defining characteristics of LINQ 2 SQL that may affect the architecture of a web application: The DataContext class, being “the main entry point for the LINQ to SQL framework.” and the way code generation works. While the first point affects what features of LINQ 2 SQL we are able to u...
0
kicks
LINQ to SQL Reality Check
I wanted to see how LINQ fared in a real world scenario, i.e. based on existing code not built with LINQ in mind.
This is the second part of the Reality Check story.