Wednesday, June 04, 2008
« New SQL security finds web.config hole | Main | The Dark Side of Extension Methods »

Now that I'm diggging a little deeper into my pet project web site, I'm learning how I really use the data. The Get() methods provided by .netTiers are great but I thought I would have more. I started looking at my database starting with the aspnet_Membership tables. I would expect unique indexes on something as obvious as the email column but it is not there. Same goes for other obvious columns in these microsoft-provided tables. So I add unique indexes to the membership tables. Of course, I do the same for my own custom tables and find that some of the text or varchar(max) have to be changed. No biggie but another step I have to take.

Now that the database is set, I need to regen the .netTiers templates, rerun the GrantUser stored proc, build the .netTiers stuff and copy it into the /bin of my project. Not hard work but just tedious to get each step completed and move on to the next one. All this so my .Get methods are consistent with my usage of the library.

All this so I can get my validators working - I really hate validators.

Monday, June 23, 2008 9:16:40 PM (Pacific Standard Time, UTC-08:00)
Sounds like you are running into the typical problem with CodeSmith and code generation in general - it works once and once only ;)

You might find it worthwhile taking a look at D&C Diamond Binding (dunnchurchill.com). The API you will end up with is a hell of a lot better, decent query support, etc. Also you don't have to throw away everything - the resync works transparantly.
James Stanley
Name
E-mail
Home page

Comment (HTML not allowed)  

Enter the code shown (prevents robots):

Live Comment Preview