Add the ability to set the locking scheme

[waterfoul]

Currently it only supports No-Lock make this a setting on the SqlFieldResolver object