7 blog posts tagged SQL
LINQ to SQL tips and tricks #3
Another set of useful and lesser-known LINQ to SQL techniques.
When an object-relational mapper is too much, DataReader too little
I fired up Visual Studio this evening to write a proof-of-concept app and found myself wanting strongly typed domain objects from a database but without the overhead of an object-relational mapper (the application is read-only).
LINQ to SQL tips and tricks #2
A few more useful and lesser-known tips for using LINQ to SQL.
LINQ to SQL tips and tricks #1
Being on the inside of a product team often leads to uncovering or stumbling upon lesser-known techniques, and here are a few little nuggets I found interesting – I have more if there is interest.
Getting started with Ruby on Rails on Mac OS X
I have decided to get to grips with Ruby on Rails and get it set-up on my MacBook Pro. There seem to be a variety of options available:
As Scott Stevenson points out this is too many options for a system that is described as Convention over configuration.
Parameterising the IN clause of an SQL SELECT in .NET
I’m a fan of parameterized queries with a strong dislike for building SQL (or other magic strings). Encoding, escaping errors, localization formatting problems and injection can run rampant when you think everything is a string.
Avoiding SQL injection
Back in ’98 I was developing an extranet site for a local company when I realized that it would be open for exploit if somebody put single quotes in text fields. It was early in the development cycle so I fixed it and moved on, unable to find out how other people were avoiding the problem.