IQueryable: Sorting, Paging, Searching and Counting(inflecto.co.uk)

submitted by rmmason(25) 2 years, 6 months ago

A good post that contains extension methods that add sorting, paging, seacrching and countain functionality to IQueryable objects. read more...

add a comment |category: C# |Views: 115

tags: Methods LINQ2SQL IQueryable LINQ C# another

LINQ to SQL Generic Repository | {Programming} & Life(goneale.com)

submitted by goneale(1055) 2 years, 10 months ago

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. read more...

add a comment |category: Architecture |Views: 77

tags: LinqToSql LINQ2SQL .Net Architecture another

Untie LINQ to SQL Connection String from Application Settings(goneale.wordpress.com)

submitted by goneale(1055) 3 years, 2 months ago

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? read more...

add a comment |category: Architecture |Views: 66

tags: LinqToSql LINQ2SQL Architecture .Net LINQ another

How to use “IS NULL” with LINQ to SQL(goneale.wordpress.com)

submitted by goneale(1055) 3 years, 3 months ago

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... read more...

add a comment |category: Linq |Views: 219

tags: LINQ LINQ2SQL SQL .Net another

Log LINQ 2 SQL query execution to console/debug window(goneale.wordpress.com)

submitted by goneale(1055) 3 years, 3 months ago

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. read more...

add a comment |category: Linq |Views: 115

tags: LINQ LINQ2SQL SQL .Net another

LINQ 2 SQL — Less is More (More or Less)(ajdotnet.wordpress.com)

submitted by ajdotnet(2940) 3 years, 10 months ago

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 use in web applications, the second one affects the application architecture. This post focuses on the DataContext class. read more...

add a comment |category: Linq |Views: 26

tags: LINQ2SQL LINQ another

LINQ to SQL Reality Check(ajdotnet.wordpress.com)

submitted by ajdotnet(2940) 4 years, 1 month ago

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. read more...

add a comment |category: Linq |Views: 14

tags: LINQ2SQL LINQ another