Modified SQLHelper for .TEXT 0.94 (English)

Modified SQLHelper for .TEXT 0.94

Thursday, 29 January 2004

//

1 minute read

I am in the middle of developing a couple of new controls to work with this site (first up is a booklist which works with the amazon.co.uk web service), as part of this I need to have data access. I was having a look at the current SQLHelper class in the DotText.SqlDataProvider namespace - it is basically the same as the Data Access Application block but has a couple of useful methods missing (e.g., the SqlParameterDataCache which I use a LOT - cuts down on typing :-)). As a result of wanting to use these methods whilst still using the same class, I have modified the SqlHelper class to be identical to the Application Blockversion, but with a few methods added to make it compatible both with .TEXT and with my exisitng controls using the basic Application Block (V2). I'll update this post later with some more links...anyway, you can download my modified version from here. I'll probably modify my design later to be a bit more architecturally 'pure' but I have a dilemma, as this will mean modifying the basic DAAB to be non-sealed...hmm...any opinions??? I'm also working on a simple OPML display control which works nocely with .TEXT (i.e., lets you upload an opml file which will then display on the appropriate blog...), I know of a few existing OPML parsers and have actually written one previously so hopefully it won't take too long!

logo

© 2025 Scott Galloway — Unlicense — All content and source code on this site is free to use, copy, modify, and sell.