Rod Paddock

In Austin, TX for Alt.Net Conference

I flew in yesterday from Seattle to attend the Alt.Net conference (http://www.altnetconf.com) I am here early because I am working with Roy Osherove (http://weblogs.asp.net/rosherove/) to see how we can implement more Agile practices in our framework/architecture.

Our framework/architecture is rather non-standard and breaks lots of “rules”

1. We do all our database access via stored procedures

2. We pass datasets over the wire to our service layers.

3. These datasets are un-typed datasets.

4. We use a combined data access and business rules class.

Our framework/architecture has a lot of cool features though:

1. Works well with windows and web applications using an MVC style controller.

2. Is very scalable (we have some sites with a million+ users)

3. Does a lot of legwork with templates and code generation.

4. Is fairly easy to use and grok.

5. It has room for growth and improvement.

My goals for this weekend:

1. Figure out how to implement TDD using our architecture

2. Gather ideas on how we could move our framework forward

3. To hang out with the cool kidz coming to AltNetConf

4. To learn how other Agile techniques might work in our development environments.

5. To have fun!

So I am here and if you want get in touch for dinner, Guinness, BBQ or just to hang…. Give me a ring 253-906-2342

crossposted from blog.dashpoint.com

Published Oct 04 2007, 01:55 PM by Rod Paddock [MVP]

Comments

cmyers said:

Awesome! Looking forward to meeting you at the conf.

By the way, stored procs aren't against the rules, it just that it can make unit testing a pain if there is any sort of logic in the sprocs (and there usually is something like default values, if/else, etc).

I have a project where we use some existing sprocs for integration with another system and I have been somewhat successful in walling them off with an interface layer that is dependency injected into my other layers so that testing is a snap (I don't test the sprocs because they've been in production for a long time and don't change much).

# October 4, 2007 10:39 AM

Raymond Lewallen said:

Awesome Rod. I'll catch you tomorrow at lunch.

# October 4, 2007 10:31 PM

Jeffrey Palermo said:

@Chad,

I find it very interesting that Microsoft's guidance is shifting to: If you need per-function security and wrapping, use a table-valued function, not a stored procedure. The advantage cited is that they have all the characteristics of a sproc, but they are composable like a view (you can join the results with something else)

# October 4, 2007 10:54 PM

Bill Campbell said:

Rod - WOW!

This is almost as exciting as the Indians winning last night (can you tell I'm from Cleveland? :)

I wanted so bad to attend this but something happened and it was sold out faster than the latest Gwen Stefani concert!

Please drop your listeners some interesting blog info. How I'd love to be looking at the TDD tie in you'll be working out. Just what I'd be interested in doing if I were there as well...

good luck!

Bill

# October 5, 2007 2:40 PM

Name (required)

Your URL (optional)

Comments (required)

Remember Me?