8 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
Step-by-step walkthrough of setting up Ruby on Rails on Mac OS X via Fink and gem, including Mongrel as the web server and MySQL 5.0 as the database, with a sample scaffold to verify the stack.
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.
Choose your ORM: Runtime, code generation or build provider?
Selecting the right object-relational mapper is a tricky decision with many factors to weigh up.
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.