Archives

LINQ to SQL: Left join with null values

Posted on March 16, 2011 2 Comments

I was staying up late last night coding on my project and hit a snag. Trying to join two tables that have a 1 to many relationship. The issue was that I was trying to get all the rows from one table and where there where get the corresponding entries from the other table. In short I have […]

LINQ to SQL: Update several rows

Posted on March 13, 2011 Leave a Comment

So I was coding away on an MVC project with integrated jQuery. I use jQuery UI Tabs in my page and let the user add new, delete and re-order them. All this I wan’t to save to the database so I can display it the next time the user logs on. I’m using JsonResult to handle […]