http://www.computerworld.com/printthis/2004/0,4814,97224,00.html

Going down fast
Slashed resources and impossible demands have caused IT morale to disintegrate.

News Story by Julia King

NOVEMBER 08, 2004 (COMPUTERWORLD) – Skeptical, stressed, scared, sucked dry. This is how IT professionals feel about work these days.

Other telling words that surfaced repeatedly during more than 30 interviews and in 200 written survey responses include fear, loathing, disgust and dread.

To be blunt, IT worker morale sucks, and it’s getting bleaker by the day.

It’s been a while, but here’s some software for dat ass.

If you develop language-localized applications, you spend a lot of time making resource files. Mostly you use ResGen to do this, which is a fine little CLI tool that does the trick.

But, CLI tools are no fun, and this is .NET we’re talking about, so here’s a little GUI for ResGen.

Unzip, edit the config file to point to your ResGen binary (usually somewhere in the .NET SDK)

Browse to your text resource file, and *poof* – generate a binary .resources file.

The tool is by no means complete or even useful, but what the hell – I need a break from webapps now and again!

Download it here: http://portfolio.vistaseeker.com/file/ResGenGui.zip

You’d laugh if you knew how easy this is to do with .NET. All you need is the System.Process classes, a simple WinForms class, and some minor text munching. Cakewalk.

P.S. you need the .NET runtime installed for this thing to run!

After the thousandth line of boilerplate database code, I decided I had had enough and it was time too look into something new.

Most multi-tier db apps these days consist of a database layer, a business object layer, and a presentation layer. The GUI and database update the business objects, so you should always have an accurate reflection of the state being modeled.

The major problem for a dev is that you have to map the DB to the business objects. Typically this involves a whole lot of diddling with type conversions as you get your programming language’s types into DB types and vice versa. The end result is nice though – you have a UI with no connection to your functionality – so if you need to turn your webapp into a full-blown OS-native application – it’s just a matter of writing a new presentation layer.

I have started to gravitate towards ORM (Object-Relational Mapping) and code generators to get through the mind-numbing CRUD and get to the fun parts.

The gold standard is Hibernate, but it’s Java and the .NET version is still alpha software.
Olero Software’s ORM.NET is fairly popular, but it appears to be abandonware which has now found a home on SourceForge.

I found a tool from France called LLBLGen which pretty much handles all the crufty filth associated with database apps. Point it at a table, click a button, and get sprocs and an object which models the table.

No more conversion of native string and integer types to DB-native types. No more dealing with NULL. No more creating and assigning parameters. You get an object, set the fields, call insert(), update(), or delete. Cake.

For simple tasks, you can use their free, one-way data tier generator. It’s a nice medium between the ORM world and the “SQL in the code” world.

Another task that I can’t stand is writing out the getters / setters (accessors / mutators) for an object, especially big ASP.NET User Control classes with 1000 form elements. Eclipse has a nice feature to let you automatically generate getters & setters from your private class vars, but VS.NET lacks the feature. Not anymore. It’s not perfect, but it works.
vsPropertyGenerator

All you devs out there writing SQL in your loosely-typed scripting language probably feel that I’m just making things too hard. All I can say is this: your apps suck.