DevelopmentNow Blog

Category Archives: linq

Linq to SQL: Cast Stored Procedure Results to Table Entities

So you can probably tell that I’ve been doing a lot of LINQ lately. One thing I’ve found is that it’s easier for me to write complex queries in the database as stored procedures or views, and then use Linq … Continue reading

Posted in ASP.NET, linq | View Comments

Grouping in Linq to SQL vs SQL

I wanted to put up a few examples of SQL vs Linq to SQL for my future reference, since we’re using it in one of our social media projects for artists. I’m pretty handy at SQL, but it doesn’t translate … Continue reading

Posted in ASP.NET, linq | View Comments

LinqDataSource doesn’t load child tables

FYI, there’s a bug in the RTM LinqDataSource where child tables aren’t loaded unless you have updating or deleting enabled. Apparently if you have a LinqDataSource that doesn’t have updates or deleted enabled, ObjectTracking is turned off (for performance reason), … Continue reading

Posted in ASP.NET, linq | View Comments